What a kooky aspect of this statement, but thanks for the question!

- webrunner

Great question, thanks.

- webrunner

mtassin (2/4/2013)

---

There is an option 4 on wait states (at least)

1. Capture the wait stats every 15 minutes

2. Store the current captured value into a staging table

3. Calculate the differences...

Thanks for this article!

- webrunner

Thanks so much for this query. Is there a similar one for retrieving tempdb log space used per SPID?

I'd like to track such a query for an issue where...

Perry Whittle (4/8/2016)

---

You've got a spill to tempdb thats not playing nicely in the park.

Do you know who the user is running the query and the actual query they're running.

If...

How could someone get the question wrong? There is only one choice.

I guess maybe they clicked Submit without clicking the radio button first?

- webrunner

jeff.mason (4/14/2016)

---

Grant Fritchey (4/13/2016)

---

I agree with Jeff, it depends.

However, let's say Staging is really Staging, a place to validate deployments prior to production. Then no. I wouldn't have backups...

lptech (4/14/2016)

---

Based on my experience, staging could be the +1 version of production, but it could also be the place where they work on bugs that only show up with...

Same here. I am not sure of the point of this kind of indiscriminate masking to '.com'. Seems like a recipe for...

jeff.mason (4/13/2016)

---

There is no one answer to that question but "it depends". Does your app team need to be able to recover its testing to a point in time?...

Thanks,...

TheSQLGuru (4/8/2016)

---

I don't think CHECKPOINT will help with a full tempdb. Maybe a transaction log (but likely not then unless there is enough room to write a bit of stuff...

TheSQLGuru (4/8/2016)

---

It is critically important to gather as much forensics as possible before pulling the plug. Often with good diagnosis the sledge-hammer approach isn't even necessary. But regardless, if...

Great, thanks for your advice on this!

- webrunner