Also note that a company that will ignore software laws in order to save money, because they can get away with it, may just as willfully ignore labor laws to...

One trick is to hit the table twice: the first pass selects the 'buy' columns and aliases their names to simply Curr and Amt, and the second pass select the...

SET NOEXEC ON

After that, you can execute you procedure. The procedure will compile (and perform the object and syntax checks you seek), but will not execute.

If you wish...

Note that it's just the dbcc index defrag syntax that has been removed....

Changing MAXDOP only makes the CXPACKET waits go away, but doesn't cure the problem. You'll get some cycles back from not having to assemble the streams, but the bottom...

Note: see link at bottom of post.

There are two types of CALs: Machine and User.

A Device CAL licenses a single workstation/phone/etc. from which multiple users may interactively log in and...

You may only install one default instance of SQL Server on a server.

For clustering to work, you must install an instance on every node (server) in the cluster...

I just threw that together as an answer to...

The key is the ability to recover to a specific point in time (mentioned above), and not just they time they took the 'SAN backup' (only relevant if you are...

This info rocks! Awesome!

The link I provided explains type 8 and 11 as follows:

Type 8: password mismatch (you typed the wrong password)

Type 11: Valid login but server access failure

- This one is...

If you're getting error 18456, then you're successfully connecting to the server, but the login is being denied.

To find details, view the SQL Server logs (I'm guessing SQL Server is...

Clustered indexes and Primary Keys are two independant entities. It just turns out that most people build their primary keys also as clustered indexes, even when their queries would...

I use the following script to pull a list of tables and space used. Add a HAVING clause to only return those tables with > 0 rows, and it...

SET NOEXEC ON

That will compile but not execute.

1. SET NOEXEC ON

2. Execute the code

3. SET NOEXEC OFF

...and react to any errors.

-Eddie