I'm thinking of angling them a bit more, moving...

There should be entries in the SQL Server error log saying what's happening with the database and how long recovery will take. What's in the SQL error log?

If you query sys.databases, what's the value for state_desc for this database? Recovering or restoring?

Changing the subject (if there is one), any art critics here?

Been fiddling with this on and off for a couple years now. Initial idea was just the light from the...

Index key.

http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

The optimiser's job has never been to find the best plan. It's job is to find a good plan fast. To find the best plan, on anything other than a...

http://twitter.com/sqltech2 if you're interested in the 'defendant's' views/

Probably this:

http://www.brentozar.com/archive/2010/03/plagiarism-inspiration-and-john-dunleavy/

http://itknowledgeexchange.techtarget.com/sql-server/todays-plagiarism-incident/

http://itknowledgeexchange.techtarget.com/sql-server/plagiarism-inspiration-and-john-dunleavy-madder-and-more-pissed-off/

Spid -2 is an orphaned distributed transaction. A distributed transaction that was cancelled improperly and SQL's left holding locks without knowing who they belong to.

To kill that, query sys.dm_tran_locks. There's...

Jack Corbett (3/23/2010)

---

Personally I think the certification debate ought to be a priority for the organization. Setting some kind of continuing education should be important as well. I'll have...

GabyYYZ (3/23/2010)

---

On a CV/Resume, would it be better to list your experiences first and then, at the end, list the cert(s), or flip the order and have the certs first,...

WayneS (3/23/2010)

---

In MY experience, those people that go to college from high school, get a degree in an IT field (even a masters!), and then join the work force have...

WayneS (3/23/2010)

---

That being said, employers are still impressed by having certifications. For that reason, I feel that all the denizons of the thread would benefit from being certified... that coupled...

How about attending to the root problem instead of just preparing for when it fails?