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"....

djackson 22568 (10/25/2011)

---

IT does not generate revenue no matter how you want to measure it. We cost money. Hopefully if we do our job right we allow the...

Sorry you missed the game. I heard it was pretty good.

I didn't get to any games last year. Too busy, and didn't want to spend 8-10 hours down there with...

Sorry to hear that, but glad you're not discouraged.

I don't have any more great prep, but I'd go through the list of things on the MS exam site and make...

I stand corrected then. It was always my understanding physical order was maintained inside pages.

Nothing wrong with basic phones, despite what my kids think. If you use it to just make calls, or text a bit, that's fine.

However for me, I'm more productive. I...

Yes and no, and I shouldn't write physical order. I realize what Gail is saying and it is true that the clustered index doesn't mean that the extents and pages...