Grr... I knew I was going to get this one wrong. I knew you could only revert if there is only on snapshot, but it is possible to restore...

If restarting the server before the test is not an option, you could reset the plan cache using DBCC FREEPROCCACHE

Thank you Roberto for an interesting question.

Thanks Christian for the follow-up with some very useful details!

Hi gmamata7,

You didn't really say what the top queries are rated by (disk IO, cpu time, etc..)

Here is a query I use to find cached plans with tablescans in them.

I've...

Good to know, and makes sense. Thanks for the question!

You could try adding SET ANSI_WARNINGS OFF to your procedure.

I know this will supress the "Null value has been eliminated by an aggregate function..." messages. I assume...

Most comparitors will implicitly pad strings before comparing them, but LIKE will only do this if the whitespace is on the right.

Try this and see if it works:

Select * from...

Good question. Thanks for keeping the answers straight-forward!

Nice question!

It really bugs me that len() trims whitespace padding on the right.

Correct answers: 2% (8)

Incorrect answers: 98% (328)

Total attempts: 336

How did 8 people manage to get this one correct?

Toreador (6/27/2012)

---

That's exactly the basis on which I answered "None unless the rest of the statement creates one", which...

mtassin (6/25/2012)

---

sestell1 (6/25/2012)

---

I was always under the impression that there was no reason to create indexes on table variables because they exist only in memory.

Does anyone know what SQL Server...

I was always under the impression that there was no reason to create indexes on table variables because they exist only in memory.

Does anyone know what SQL Server actually does...

+1

Thank you Hugo...

SQLRNNR (6/21/2012)

---

Thomas Abraham (6/21/2012)

---

I figured it would. But it's nice to have it...