If something extravagant did happen on the 1m post..the result would just be this anyway:

http://xkcd.com/570/

🙂

Do not do this. It will...

It is based on logical cores

This is also why it's typically bad to have hyperthreading enabled..SQL can't tell the difference between an actual core, and the virtual HT core, and...

That query can definitely be cleaned up, but could you please provide some sample data for both tables so we can make sure it's returning as expected?

It does not flush the buffer cache, no.

Adding memory at any time is safe..removing it will definitely kick things out of the cache, of course, so I wouldn't necessarily do...

Out of curiosity..what would you want to show up if this happened:

Student loans a book 01-01 to 01-07, then rents it again 01-09 to 01-10

Do you want it to just...

I grant permission on the SP itself when it is created. Being granular is usually the better, more secure approach.

Developer edition is not free anymore. Someone else just started a thread on this recently..they ended up buying it from CDW for like $50

Or you could just get a technet...

Post of the week right here 🙂

It goes [database].[schema].

So.. [auditdb].[orders].[customers.ordersaudit] ?

You need to put brackets around names that have spaces, periods, etc in them.

Was the database detached instead of deleted? What did you search on? Drop, Detach, and Rename are pretty much the only ways I know of to get rid of a...

Whoops..I meant MCITP rather than MCDBA (which I believe was the 2000 equivalent).

Any tips on how to justify the cost of the exams to my company? I need I believe...

That's called a PIVOT. Usually pivot operations are better done in excel or SSRS, but they are doable in t-sql.

See here for the official doc: http://msdn.microsoft.com/en-us/library/ms177410.aspx

Just a note..my post above applies to SERVER 2003 ONLY

Server 2008 allows multiple DTC services running on the same cluster, though I haven't done this yet so I can't give...

When you set up DTC as a cluster resource, it is used for the entire cluster. There is no way to have it "running" on more than 1 node, just...