I always heard that a good rule was to start with [installed] RAM at 10% the size of the databases in the instance and go up from there as needed.

Currently...

$s = New-Object Microsoft.SqlServer.Management.Smo.Server("$instancename");

$s.IsClustered; # returns $true/$false accordingly.

you probably have a start-up parameter that should not be there. Post the errorlog as already requested, 99% chance the explanation will be in there.

That's covered in any T-SQL 101 course, even SQL for Dummies.

The key should be small as possible. Sometimes you "have" to use a char/varchar column as a key, but...

That's like asking which is the best way to eat ice cream. Pick the method that you are most comfortable with.

There probably many different ways of doing this, but the first thing that comes to mind is to create a sql job that runs on start-up. It would run...

I just finished a project to eliminate all the xp_cmdshell used in our code in one of our more sensitive databases. Sensitive information was hard coded all over the...

(I know this is pretty long but I figured it would be better that way to try to save someone else from lot of googling and headaches)

I played with this...

I'm doing the same thing and have not been able to find any information either. Have you found anything since you posted here?

I have and active-active setup. Active1 is...

Nope, not checked.

Yes, the possibilities of 2 servers failing over has already been explained. But it's up to the higher ups to decide risk vs cost.

Thanks for the quick response.

It was just surprising because I could swear that the following code used to work in sql2k:

declare @OrderBy varchar(50)

select @OrderBy = 'name'

select

Id

, [name]

, data

from

dbo.test

order by

case @OrderBy

when 'Id' then 1

when 'name'...

You were right.

Changing

...

OK, I get that, but why then, it works when @OrderBy = 'Id' which is an int, and also works when @OrderBy = 'data' which is a varchar, but not...