Jeff Moden (8/10/2009)

---

[font="Arial Black"]Absolutely not true. Please, folks... stop perpetuating this myth.[/font] That's a left over wives tale for the original version of 6.5. Don't take my...

rja.carnegie (8/10/2009)

---

How much space does a variable consume? I assume kilobytes at most typically, which is really nothing at all. I mean, you aren't going to use thousands...

No. But then not everything in the article is true for 2005 or 2000 either.

Try moving the subquery to the from clause as a derived table.

I just told you how to troubleshoot and fix orphaned connections. The first part of my post above that talks about sys.sm_tran_locks.

The exams for the MCDBA cert were retired months ago and hence the cert can no longer be obtained.

See here for current certs

http://www.microsoft.com/learning/mcp/certifications.mspx

Be patient. It's not finished yet. If you're keen to...

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Woot. My muse has returned. Sat down over the weekend and hammered out 3 pages of an article that I've been staring blankly at for the last couple months.

Any...

What he said is mostly true. It was true on SQL 2000 (if I recall)....

To fix the spid -2 problems (which is an orphaned distributed transaction) run this

select request_owner_guid from sys.dm_tran_locks

where request_session_id = -2

Pass the guid the the query returns to the KILL command...

Sorry, but I'm going to greatly disagree with a number of these 'tips'

8. sp_executeSQL and the KEEPFIXED PLAN options - Both sp_executesql and the KEEPFIXED PLAN option avoid the recompilation...

Can you explain what it is that the cursor's doing?

The Database tuning advisor is only included in Standard, Enterprise and Developer editions. You can either download a 180 day trial of Enterprise edition or you can buy developer edition...

vishal (8/9/2009)

---

the account with which sql servies run and is having full control over the db and log files but still my db is in suspect mode and im unable...