You and me both....

Yup.

CirquedeSQLeil (5/7/2010)

---

You can also take a look at sys.dm_exec_query_stats. You will need to know the sql_handle for the query you are running though. You would want to look...

Why not? Insufficient permissions? If you're testing your optimisations on a dev system, there's no reason you shouldn't have ALTER TRACE rights....

When the query(s) have no single optimal plan. One example is when you have severe parameter sniffing, data skew or similar.

I'm not...

Problem with that...

100%. SQL tries to run a query as fast as possible, so it will try to use a CPU to 100% for the duration of the query. If it doesn't,...

Lowell (5/7/2010)

---

i was under the impression that the mdf is a standard file format for each version(2000/05/08)...meaning that all versions of SQL save to the same format for the mdf...

Likely that's exactly the point, to tell what version a detached DB came from...

You could try opening it in a hex editor and manually cracking the value out of the database header page (9th page of 8kb each) and getting out the database...

Filter your trace. If you're just interested in an object being dropped, just use the Objects: Object Dropped event

Don't understand what you're asking.

You shouldn't be using nolock anyway, not as a 'default' solution. It has side-effects. http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Switch traceflag 1222 on. That will result in a deadlock graph been written to the error...

Development work should be done on development workstations, ie desktops, not on the server directly. You...