IF Profiler won't work, and you have some good reasons why it could be a pain, then you need to buy one of the log reader tools.

Red Gate Log Rescue

Lumigent...

That's an intersting question. No idea what will happen, but I'm guessing that it will break.

Good for you, but I'll take the sun and 2 weeks less vacation any day.

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...