Showing posts with label appear. Show all posts
Showing posts with label appear. Show all posts

Friday, March 30, 2012

Managed Disks in Windows 2003

While setting up windows cluster in 2003, my external array which is
logically partiotioned into P and Q appear as one disk group.
If i wanted to setup an active/active SQL cluster, how can i seperate into 2
groups, so that one node owns P and SQL instance 1 has data files on P and
the other node owns Q with another SQL instance owning Q. I didnt see a
managed disk dialog during the 2003 windows cluster instance.
Consult with your extenal array vendor documentation/support. It may be that your array cannot present virtual disks (like many high-end SANs can). This may mean that you need disk sets made up of different physical disks to present 2 "disks" to your cl
uster. eg physical disks 1, 2+3 are drive P, while physical disks 4 and 5 are drive Q. Don't forget that you'll also need a separate disk for the Quorum. So, in your configuration you'll need to have AT LEAST 3 separate disks to present to your cluster
. What sort of external array are you using?
|||MSCS looks at the physical layer, not the partition level. So you can have 4
partitions on a single disk, but MSCS will display this as one physical disk
resource. The only way to achieve an active/active configuration would be to
add another physical disk...can't be done with your current config.
Regards,
John.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e$W6OIPFEHA.2768@.tk2msftngp13.phx.gbl...
> While setting up windows cluster in 2003, my external array which is
> logically partiotioned into P and Q appear as one disk group.
> If i wanted to setup an active/active SQL cluster, how can i seperate into
2
> groups, so that one node owns P and SQL instance 1 has data files on P and
> the other node owns Q with another SQL instance owning Q. I didnt see a
> managed disk dialog during the 2003 windows cluster instance.
>
>

Wednesday, March 28, 2012

Making SQL Keywords All Caps

Is there a way to make keywords such as SELECT, FROM, WHERE, HAVING, AND, ON etc. always appear in all caps when typing queries n the SQL Query Editor?

I have looked in the Options under Fonts and Colors but I dont see a way to make these keywords all caps. Any advice is appreciated.

Regards,

Randy J

Hi Randy,

holding the Shift Key during the typing of the keywords ? :-) Just kidding :-) I don′t think that there is an option for putting them all in caps. External tools can do this (like also providing Intellisense for the database), Query Editor AFAIK not.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Thanks for the reply. I now know about that odd key on the keyboard :)|||

Hi Randy,

just as a followup, PromptSQL does contain automatic uppercasing and other cool features, perhaps this is capable for you (and its not expensive)

http://promptsql.com/

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

sql

Wednesday, March 21, 2012

Make Table not appear

Hello
I want to edit my visibility of a table depending on the number of rows
it has. i.e if there are no rows present I want to display a message
instead, so make the table invisble and make the message visible. Is
this possible if so how do I do it, my gues would be to count the
number of rows and display if greater then 1?
Any help would be greatly appreciated
DenverHi Denver.
The way I would go about doing this is by placing an iif statement in the
visibility section of the properties. This would basically specify true for
if there were no rows returned or false if there is data returned.
Regards
"Denver" wrote:
> Hello
> I want to edit my visibility of a table depending on the number of rows
> it has. i.e if there are no rows present I want to display a message
> instead, so make the table invisble and make the message visible. Is
> this possible if so how do I do it, my gues would be to count the
> number of rows and display if greater then 1?
> Any help would be greatly appreciated
> Denver
>

Monday, March 19, 2012

Make items bold in parameter selection list

Is it possible to make certain items in a parameter selection list appear bold?No, parameters are not configurable in terms of presentation.


HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I am getting available values from a calculated member in analysis services. The definition pane for a calculated member contains a section for 'font expressions'. I tried to use that, but didn't succeed. Does anyone know what you can do with font expressions?

Wednesday, March 7, 2012

Maintenance Plans Disappear

I recently restored 3 databases. The maintenance plans responsible for
creating the backups for those databases appear to have disappeared after th
e
restoration. I deleted the databases prior to restoration, but did not touc
h
the plans.
Is there a way to make sure that the next time I have to restore the
databases that the plans do not get removed? Is there a way to backup or
export the maintenance plans?
Thanks
MarkDid you restore msdb? Or did you perform a rebuild of the system databases?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark Coffman" <MarkCoffman@.discussions.microsoft.com> wrote in message
news:970287BA-384C-49A8-BA53-26E1BE124F57@.microsoft.com...
>I recently restored 3 databases. The maintenance plans responsible for
> creating the backups for those databases appear to have disappeared after
the
> restoration. I deleted the databases prior to restoration, but did not to
uch
> the plans.
> Is there a way to make sure that the next time I have to restore the
> databases that the plans do not get removed? Is there a way to backup or
> export the maintenance plans?
> Thanks
> Mark
>

Maintenance Plans Disappear

I recently restored 3 databases. The maintenance plans responsible for
creating the backups for those databases appear to have disappeared after the
restoration. I deleted the databases prior to restoration, but did not touch
the plans.
Is there a way to make sure that the next time I have to restore the
databases that the plans do not get removed? Is there a way to backup or
export the maintenance plans?
Thanks
MarkDid you restore msdb? Or did you perform a rebuild of the system databases?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark Coffman" <MarkCoffman@.discussions.microsoft.com> wrote in message
news:970287BA-384C-49A8-BA53-26E1BE124F57@.microsoft.com...
>I recently restored 3 databases. The maintenance plans responsible for
> creating the backups for those databases appear to have disappeared after the
> restoration. I deleted the databases prior to restoration, but did not touch
> the plans.
> Is there a way to make sure that the next time I have to restore the
> databases that the plans do not get removed? Is there a way to backup or
> export the maintenance plans?
> Thanks
> Mark
>

Maintenance Plans Disappear

I recently restored 3 databases. The maintenance plans responsible for
creating the backups for those databases appear to have disappeared after the
restoration. I deleted the databases prior to restoration, but did not touch
the plans.
Is there a way to make sure that the next time I have to restore the
databases that the plans do not get removed? Is there a way to backup or
export the maintenance plans?
Thanks
Mark
Did you restore msdb? Or did you perform a rebuild of the system databases?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark Coffman" <MarkCoffman@.discussions.microsoft.com> wrote in message
news:970287BA-384C-49A8-BA53-26E1BE124F57@.microsoft.com...
>I recently restored 3 databases. The maintenance plans responsible for
> creating the backups for those databases appear to have disappeared after the
> restoration. I deleted the databases prior to restoration, but did not touch
> the plans.
> Is there a way to make sure that the next time I have to restore the
> databases that the plans do not get removed? Is there a way to backup or
> export the maintenance plans?
> Thanks
> Mark
>