http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapters 6 and 7

I would recommend you get into the habit of qualifying your columns names

DELETE FROM Despatch

WHERE Despatch.ordno NOT IN

(SELECT Order.ordno FROM Order)

It wasn't missing. The script you refer to generated the sp_detach statements, allowing someone to copy the...

Jeff Moden (12/10/2012)

---

In that case, the number of page reads has a direct correlation to the number of and "age" (they empty space may have be inserted to) of...

If those 2 columns are in a table, then

SELECT name FROM SomeTable ORDER BY sortorder

No CTE required

Missing files will not result in the DB being in the offline state. They result in the Recovery_Pending state if...

Nope, that's not something you'd use a trigger for. That's something you'd probably use an extended events sessions for, or SQL Trace if you're using SQL 2005 or below.

If you delete it then anyone who's created a database diagram (from SSMS) will lose...

If you are partitioning with the idea that queries are automatically faster on partitioned tables, don't waste your time.

You see all the locks that are held.

If the select's session was holding an IS (from an open transaction and previous statements), that's enough to block the index rebuild. Everything...

It's created when someone creates a database diagram

What locks was it holding?

DBA24 (12/9/2012)

---

My transaction log backup today took longer time to complete than usual. Daily it runs at 1:00PM for about 2 mins and today it took like almost 2 hours....

What was session 88 doing?

CheckDB won't tell you the last time an index was rebuilt (however you need to run it regularly).

That information isn't stored by default. If you're running a reindexing job, you...