I'm not totally convinced the NT groups have any relevance. You'd need to check out the permissions of these groups - that would be relevant if your account requires those...

There are several reasons for this, a couple I've encountered are - differences in SET options and compiling the proc with set ansi nulls or quoted identifier OFF.

I can confirm that this is the way to do it - from experience.

Partitioning sounds really good and should offer all sorts of performance improvements but the reality is that the key choice(s) for native partitioning is often so restrictive as to make...

I don't think there's ever an answer that fits all. I'd say that keeping developers away from any other server is good. I'd put all the devs on the same...

ah - job descriptions don't you just love them. Why not just say install sql server.

changing service accounts on a cluster can be tricky and furthermore removing permissions from an account on a cluster even more so.

I'd suggest you carefully document exactly what your sql...

The more serious observation is that of are you making changes due to performance issues or perfmon issues?

I'm never too bothered overall with cache hit ratios in as much as...

" Our programmers are pretty clever ... " an oxymoron if I ever saw one methinks.

I suspect you mean binary collation which is full blown case sensitive. It's claimed using binary collation is much faster but in reality only certain types of searches are faster...

You'll need the account you open management studio with to be a sysadmin. You should have defined the administrator account(s) for SQL Server during install. If you didn't then you...

If you give users full access to a database eventually they will write the query from hell. Find an alternative solution and get rid of select *.

The only way you...

It's a little while since I used multiple DAS but if you want a secure solution only ever use hardware raid functions. If you're setting your storage array as raid...

profiler includes reasds/writes from all/most internal operations too, this is why the same query run with show io stats in a query window will usually show a different set of...

It will to a degree depend upon your app, however, you should put the database to 2008 compat mode and make all the set commands to allow use of such...