What do you think all the possible answers are and why?

I can think of at least 3.

Won't matter if it returns too much data. Assuming that what you posted is the full list of columns, a table scan is actually a very good plan.

Case sensitive server?

Got one here, really annoying as hell!

L' Eomot Inversé (9/21/2011)

---

I did say...

I don't think this is bug.

You say 1 query hits the cpus at 30%. It takes 3-4 of them to kill the server.

I've seen powerfull server (way overkill for...

Ha finally!

Pretty much what I expected. Maybe it's time to ask for a new feature??

You'd need to have both the use and the next select in the same dyamic sql call.

What do you need to do exactly?

Thanks for...

sbentz 2061 (9/20/2011)

---

Just to clarify on the scope of stored procedures, as I am new to SQL*Server development --

When executing a stored procedure, the scope of that stored procedure is...

And what does this return as well?

Anything weird in the logs?

SELECT state_desc FROM sys.databases WHERE name = <your db name here>

GilaMonster (9/21/2011)

---

tfifield (9/20/2011)

---

Ninja's_RGR'us (9/20/2011)

---

You can do that in the restore GUI.

Pick your db, the PIT to which you want to restore to. Then SCRIPT & manually add...

As requested 5 times already we also need sample data (insert statements).

This can generate thos for you in 2 sec.

http://www.ssmstoolspack.com/

Not for a specific select statement that is not in a view.

Well that error means you need enterprise, dev (if not prod server) or datacenter edition.

Rokh (9/21/2011)

---

Funny, has about the same execution speed as my original query. have to deal with the fact that implementing CASE/WHEN statements like this implies a serious performance hit. It...