May I inquire as to whether or not this is a homework or other non-work related post?

Hey guys, please check the dates on threads you are going to reply to. Please do not reply to 1.5 year old threads! Thx.:-)

1) do you REALLY need that identity clustered PK on the temp table?? I can count on 2 hands the number of times in almost 15 years of SQL...

yasubmj (7/5/2011)

---

I was expecting a more technical explanation Jeff!!! 😛

http://blogs.msdn.com/b/craigfr/archive/2007/10/25/recursive-ctes.aspx

Craig says clearly here that the anchor part is executed only once, then why is my change making such a big...

1) you should ALWAYS have a max server memory set in sql server. 9 of 12 is ok for a start, but may need to be lower if you see...

Simple answer: no, there is no FOR/NEXT looping construct in TSQL. Use a cursor if you do not want to pursue a set-based solution. Be sure...

BenWard (7/6/2011)

---

Cheers guys.

I will have a play with service broker - I think it would be a useful skill to have anyway. I though about scheduling jobs, but I dont...

Jeff Moden (7/4/2011)

---

TheSQLGuru (7/4/2011)

---

Given that a flaw was found what, a two years or more, after the "quirky update" was first put out there how many incorrect results were calculated?...

Unless you are already a SSB proficient user, that is just not the best way to go here. Simply create 13 jobs and schedule them to run at same...

1) stop using maintenance plans for index and stats mx. get a copy of ola.hallengren.com's free and fully documented maintenance suite.

2) do you have any free space...

1) It is not a rumor - Denali will have more complete support for windowing functions, including those that allow for single-pass running totals.

2) Given that a flaw was found...

I think ERStudio from Embarcadero is WAY better for SQL Server modelling. Much better pricing too.

But for what this OP needs, I would just slap something together for the...

Allan Hirt has a good book on SQL Server High Availability....

That's a nice collection of VLFs you have there! I recommend you find and read Kimberly Tripps blog post on optimizing transaction logs.

Greg Roberts-134214 (6/28/2011)

---

TheSQLGuru (6/28/2011)

---

I see you have been going back and forth for days on this issue. You REALLY should have gotten in a professional consultant initially. This type...