Nope. You could tweak my consistency check procedure[/url] to fit your needs.

Jack Corbett (4/6/2012)

---

Okay a couple of semi-technical questions:

What do you all run to backup your home systems?

I may need to buy a new laptop soon. I use...

This seems to be what you're looking for:

http://www.sqlservercentral.com/scripts/Administration/62598/

-- DECLARE A VARIABLE FOR DYNAMIC SQL

DECLARE @sql nvarchar(max);

DECLARE @colname NVARCHAR(max)

,@coltype NVARCHAR(10)

SET @colname = 'purchase_order_no'

SET @coltype = 'int'

-- CREATE THE SQL STATEMENT DYNAMICALLY FROM THE TABLE...

I don't think I understand your question. Can...

Throwing a wild guess:

-- =========================================== --

-- SETUP ...

sunny.tjk (4/5/2012)

---

Can we detach a database snapshot?

The interface gives me the option to detach but when I click on detach, it gives an error saying "Cannot detach database...

Yep. "Simple" means no point in time recovery.

That's why "simple recovery" and "production" are not usually found...

On another note, I would suggest resisting the temptation to throw indexes at this query before fixing it.

A smart rewrite will probably fix the performance issue without the need for...

Your query contains all sort of evil. You really need to rewrite it.

First of all, let's format the code to make it more readable:

SELECT DISTINCT TOP (100) PERCENT dbo.Job.Id

,dbo.Contact.Id AS...

This blog should help:

http://www.sqlskills.com/BLOGS/PAUL/post/Capturing-wait-stats-for-a-single-operation.aspx

Is there a question here?

I should have said "this and much more"!...

Thanks! I learned this from Jeff. 🙂

Here's one possible way:

-- =========================================== --

-- SETUP ...