Chad Crawford (5/2/2012)

---

Gus - I've done Scrums before but I'm not seeing how they would help with prioritization, perhaps we were using scrum incorrectly. We would Blitz (hope...

drew.allen (5/2/2012)

---

It clearly says,

or were you referring to not finding CROSS JOIN?

It doesn't specifically state anything about CROSS JOINS....

I've resolved hierarchies of this nature, with this kind of error handling, in the past, simply by using a While loop and a temp table.

Insert your seed value (usually either...

CrankyRat (5/2/2012)

---

" it is not beyond the pale to believe that an individual's "personal" retirement funds will be confiscated by the government at some point in the future."

Jeez, I'm listening...

Revenant (5/2/2012)

---

GSquared (5/2/2012)

---

RobertYoung (5/2/2012)

---

I guess you not noticed the...

If you reverse the sequence of shrinking it and then rebuilding the indexes, it won't speed it up, but it will at least leave you with intact indexes. Right...

You're welcome.

You're welcome.

Sometimes it's the most obvious things that are the best hidden.

What did you have to change?

sqldba_newbie (5/2/2012)

---

seth delconte (5/2/2012)

---

I guess it may depend on what sort of process(es) are kicked off in the batch...if they are able to be executed asynchronously, as with a stored...

You don't get to review the command prompt (DOS) output from a batch file run that way. You have to run the command manually in the command prompt to...

You'd do that by setting up an SQL Agent job that runs every minute and uses sp_send_dbmail to send you the appropriate data.

Why would you want an e-mail every minute?...

Do you need to query it repeatedly or just once? If repeatedly, will it be the same file each time, or will it be a different file different times.

If...

Define another output, and make the Select populate it inside the dynamic SQL.

SET @OldValueSelect = 'select @myxmloutput = (SELECT * FROM COMPARETABLE WHERE ' + @DeltaVarColumn + ' FOR XML...

capn.hector (5/2/2012)

---

You stated the DB was 4 TB before the purge what about after. as GSquared has eluded to if you have a massive amount of data to delete...