MyDoggieJessie (7/8/2013)

---

This was my original thought. Perhaps...

MyDoggieJessie (7/5/2013)

---

I've read various articles on how to do this but tried a different approach and while it appears to work for the most part, there were still some issues...

I was too fast. Lost my points. Good question though.

Bobby Glover (5/8/2013)

---

I don't have a problem at the the mo. But was wandering after making a fairly large deployment of multiple sprocs/views.

Is there an easy way of finding out...

Want my points back. The answer is those hints can be used either with "with" hint or without the with hint. My points back.

I'm just curious to find what made you to think that renaming a system databases is option for you. 🙂

+ 1.

ChrisM@Work (4/15/2013)

---

That looks ok to me, other than the joins to the temp table not being optimized. You don't really need the temp table anyway:

SET @RowsDeleted = 1000;

WHILE @RowsDeleted >...

Nice learning. Thank you.

Neither I don't understand for the reason for char(3).

I didn't knew the answer for this question. But based on the elimination I eliminated A and B....

Compare the period of transaction log backups and see which time frame the...

Good question !!!

Awesome

For me at least option b and option d looks pretty much similar.

option B.

Query 1 will return all rows of table 1 and Query 2 will return only...