Did you install SSMSToolspak [/url]? ( which is very good , but has this behavior by default, but you can change it)

HW is supposed to be ok, how about the batteries ? ( I/O caching on/off will be noticeable )

Did you try a scenario "disable index + load + enable index...

Can you post your sqlserver instance version information ( @@version ) so we are sure we're posting for the correct one ? ( rtm sp1/sp2 R2 R2sp1 )

I'm glad you like it.

As George stated sp_help_revlogin can help you doing just that. ref: support.microsoft.com/kb/246133

Thank you for the feedback about the remediation. :w00t:

Did you manage to find the cause for this to happen ?

Can you elaborate what you did to handle the issue and solve it ?

great summary, John !

It's good you mention "DB restores" as well, as it is a "non trivial" usage area in many cases. :exclamationmark:

MyDoggieJessie (3/28/2012)

---

GOOD LORD JEFF!!! :w00t:

The efficiency of this using the TVF is incredible. I processed a years worth of data in just under 2 minutes...WOW - THANK-YOU!!!

The ROLLUP is not...

did you compare both sqlplans ?

how old is the cached plan for the parameterized query ?

( you can add the .sqlplan as attachment with your reply )

have you checked with...

Since you really want to shoot yourself in the foot at certain moments , why not just add another factor of uncertainty by using the sqlserver alerts.

Have a look at...

Another great SQL Spackle, Jeff :w00t:

Koen Verbeeck (3/29/2012)

---

Dalibor Margotic (3/29/2012)

---

You need to eliminate hash join and Index scan.

With this query you can do that using INTERSECT AND EXCEPT

...

Or, this one...

Great extrapolation of the KISS principle, Jeff.

Need it to be sead ... [font="Times New Roman"]I LOVE IT[/font] :w00t:

What topology of mirroring did you configure ?

Keep in mind to double check your current principal server has enough free space (log) to cope with the time frame your secondary...

I suggest to read the information already pointed to by the previous respondents.

To help out a bit more I've added a Powershell (2.0) script that I created at the time...

just my 2ct 😉

So you have "missing" ddmm in some cases. ( or all cases ? )

Are you going to store the actual birth date from now on ?

If...