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

If you're getting problematic plans, it's probably because of out of date statistics, so getting more up to date statistics is usually the solution. USE PLAN might not work that...

Doctor Who 2 (7/19/2016)

---

Hi Steve,

Tonight I have a chance to go through the MSDN article you've posted in response to my question. It looks as though I need to first...