I just got back from leave and Tech-Ed and noticed this

Very nice article.

There's nothing that gets at me more than a harsh or insulting reply to a post I've made,...

My recomendation would be to use profiler.

The event you want is under stored procedures, sp:recompile

You want to catch the object name, the event subclass (which gives you the reason for...

I can't reproduce the problem, but something I saw a couple days ago at teched might help you.

You aren't by any chance connected to a SQL 2000 instance are you?...

Can you post the sp code please?

The only thing that imediately comes to mind is that it was a real table created, not a temp table

The only problem I have with the page peel it that if I run the mouse over it, IE crashes. It's a little slower, but since I browse while working,...

Ah, thanks. That's great. I don't want to miss out on the party.

Now, where's my boss........

I don't suppose there's any way to use 2 codes when registering?

I've got a code that gets me a massivly discounted rate (because I submitted an abstract for the...

Any fuinction applied to a column will prevent index seeks, even if it's something simple like column+0

Check the queries for unnecessary work been done or inefficient queries

Check the blocking on the server

Check for hardware bottlenecks (disk, memory, cpu, network)

It's SQL Server 2000 sp4 running on Windows Server 2003 build 3790, SP1.

the 8.0.2039 refers to SQL, the build and teh sp that @@version returns refers to the underlying operating...

Can you post the text of the stored proc?

If timestampstr is an automatically generated value, then it's easy. don't mention the column in the insert or the select.

It it's not autogenerated, then you need to find out...

If you need a point-in-time copy of a database that must survive hardware failures and natural disasters and exist for several months, then just restore a backup and set it...

I'm a little confused. Does this mean that the snapshot will be updated each time data in the source data file is changed?

Not necessarily. Sorry if I confused, let me...

No, because a snapshot is not a real copy of a database. It's a virtual copy where pages that are changed in the source database are copied to the snapshot before...