Lempster (7/3/2014)

---

SQLRNNR (7/3/2014)

---

A lot of the point to relaying a story where a problem occurred and you fixed it is to see a) how you fixed it, b) your attitude...

No offense at all. I just wanted to be clear. I did assume that you didn't mean to literally make stuff up.

As to interviewing, it's subjective. There just isn't a...

Something that severe sounds like a major issue with the SQL Server installation. First I'd try putting on the CU. If that doesn't resolve the issue, I'd get in touch...

It did start out as a figurative unit of time. Now it's just a figurative unit. It's never been meant as an actual measure.

Backups work in 2014, so we'll need more information. I would suggest you install the cumulative updates though. They fix some pretty serious bugs.

Let me first assume this is just an "English as a second language" moment and point out that "make up a story" would mean...

Sometimes I wish I could just vote for answers here.

Karen has the cause, Sean has the solution.

Who says it needs correcting? PLE < 300 is not necessarily a bad thing. It could be that your system just has a highly volatile memory use. I'd want to...

And... what's the question? Ha!

That would have made a great blog post.

If a process has timed out, you won't see blocking now. There may have been blocking during the process. Depending on how long things were running, I'd suggest taking a...

Views aren't just for security. They're basically a mechanism that is used to mask structures. This may be for security. It may also be for backwards compatibility for an application....

That might not work well. Back...

I'd suggest looking at the wait statistics. It might just be CPU, but sometimes a problem with I/O or memory can show up as CPU. You may also need to...

A safe recovery from a possible outage is a great story. I'm not sure why they were unimpressed. Maybe it was delivery. Maybe they were hoping for something more spectacular....

And the queries would run even faster if we could...