Excellent. Good luck.

You can't really plan for the crazed variability that comes up. Instead, I took an approach of getting an alert at 85% and 95% full on the drive. However, as...

DOS?

I mean, seriously?

DOS?

Not even going with "command line" or "shell" or anything even remotely WITHIN THE LAST TWENTY YEARS modern.

DOS?

I really don't know which is more appropriate, pointing and...

Maybe update your profile with the blog location. I was interested in reading this too.

Even if you delete all the databases, the "server" will still be there. You don't pay for them, only the databases that are running on them.

Gone for a week and come back to find you guys talking about Excel. Looking around now for talking apes and an exploded statue.

It's only filtering a very small subset of the data. Because of that, it really is cheaper for the optimizer to scan rather than seek. Go back to my original...

koti.raavi (7/21/2016)

---

GilaMonster:

Thanks for your response; you mean to say if query is big it’s better to use CTE instead of derived table?

Grant Fritchey:

Thanks for your response.

1) I know...

GilaMonster (7/21/2016)

---

I've done the second a few times, out of forgetfulness only not malicious...

Innocent of that crime... yikes.

Even for a data warehouse you don't want to move all the rows every time. You have limited to zero tuning opportunities for a query without any filtering.

It's about capturing metrics. If you suspect that an action on the app is delayed by other actions on the database, you'd focus on queries against the database during the...

matt.gyton (7/20/2016)

---

Hi All,

Many thanks for all your responses. I have restored a fresh copy of the database to try and ensure there are no differences and all these things appear...

koti.raavi (7/20/2016)

---

I have few quick questions

1)

If table variable is storing in tempdb why can't I use them like temp tables?. How can I check table variable in tempdb?.when...

The scans and the hash matches make sense. You don't have any kind of a WHERE clause to filter the data so the query is returning 300,000 rows. Scans &...