A fun question for a holiday. At least it was supposed to be for me, but a little behind.

It's a bit of trivia, totally useless, but we stick those in...

When you say unique to each instance, do you mean each instance on each node, or do you have multiple instances on the virtual clustered instance? The jobs on Node...

Indeed, congrats to the Cards. I had mixed feelings, and watched the final game Fri night, wishing it were closer. Sad to see the Rangers implode, hitting two batters in...

First, turn on more logging from plans or SQL agent. Use a log file.

By default what you have doesn't provide enough information to determine the issue.

A few questions. Are you...

If you create a physical user for each login, you are asking for a lot of administrative work to be done, unless you expect the application to create the user,...

The post above explains how to do it, but as a few people have said, there's no need.

SQL Server does not need cold backups. Ever. The online backup is rock...

Just a quick note. I have an iPad 1 and use a bedside charger station. It always says "not charging", but it charges, albeit slow. I can be down to...

I would try pasting it in notepad, and ensure it has the line breaks, then cut/paste from notepad (after saving) to the form.

Are you pasting in the script code box...

Also this: http://www.sqlskills.com/blogs/jonathan/post/Finding-what-queries-in-the-plan-cache-use-a-specific-index.aspx

Perhaps a better formula for PLE from Jonathan Kehayias.

Thanks, everyone, for the kind words.

SQLDCH (10/26/2011)

---

The Steelers play the Niners in a Monday night game, will hopefully be attending that one. I do my best to hit the games when the Steelers are...

Yes, I think some running total is needed. Something like this: http://www.sqlservercentral.com/articles/T-SQL/68467/

The problem is that you cannot do the division in the same way as you're doing the multiplication since...

A lower fill factor should result in lower fragmentation, since you will get more new rows on the pages before they split, but over time, you might continue to get...

I am getting two rows from your test script, with the values of 48 and 959.999

Is that correct? It's hard to know what's not working. Division operations work the same...

L' Eomot Inversé (10/25/2011)

---

I agree it's necessary and should be there, but I don't agree that it's always an overhead.

...

Also remember that "overhead" doesn't mean "not valuable" or "not necessary"....