Apologies for that slipping through. The @@ have been removed from the question.

The catalog is the database and the equivalent of the schema in SQL Server 2000 is the owner. For SS2K5, Oracle, DB2, etc., schema is the schema. It's the collection...

Thanks and I'll add that to my list of blogs for Database Daily!

And if you want to write us an article ....

Let me...

This help? http://support.microsoft.com/kb/905616

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?topicid=1&faqid=20

And when you figure out all those, check out the Joe Celko SQL books.

I'm probably a bubble and a half off, most likely colored purple or fuschia, maybe bland oatmeal.

Payment doesn't have to money. I think a more respectful treatment would pay a...

BOL is Books Online and it's the help file that's in your SQL Server Program Files group (from the Start Menu). Here's the online CREATE INDEX reference: http://msdn2.microsoft.com/en-us/library/ms188783.aspx

Now if I...

From what I've seen benchmarked, a dual core is like 1.6-1.8 CPUs, depending on what you are doing.

Two dual cores might outperform your older quad, especially if it's at a...

The clustered indexes are what hold the data, so as mentioned above, move them.

The MCDBA is a SQL2K cert, as mentioned above. The MCITP is a 2005 cert. If you have experience with SLQ Server and Windows, I'd get the MCDBA as there...

It's a sad ending and Mr. Kim did what he thought was right. Thoughts and prayers to his family.

They didn't do anything wrong, jusgot caught in a bad situation. I'd...

It seems from my testing that both the '' and ' ' are treated the same. This doesn't seem right since I'd expect a '' to be stored as ...0000000...

John,

a couple things. First simple logging does clear the transaction log, but only of committed transactions! So if you run 100,000 deletes as a "set rowcount 100000 delete from mytable...

Mike,

I don't think there's anything to take you from start to guru. You'll probably end up with a variety of materials.

For books, I think any of the "SQL Server in...

rao's solution is the best.

if (x = y)

raiserror ()

return

else

-- continue