Jack Corbett (12/2/2010)

---

Great article again Grant. I just prefer to use sys.traces over fn_trace_getinfo. I think it gives an easier to decipher set of information.

Hmm, I'm going to...

CavyPrincess (12/2/2010)

---

Thanks for the great article. I create a baseline performance measure every so often on my servers, and this will simplify the process. I'm currently placing the...

For the non-SSIS version, what language are you using? Because if it's not PowerShell, I might want to do one using PowerShell.

jason.spangler (12/2/2010)

---

Great article. I have been using this technique for a few months now and it saves tons of resources on the server, plus helps with my sleep when...

PAH-440118 (12/2/2010)

---

Thanks for this article. it was just what I needed and a feature I did not know about. I have been experimenting and it looks great however I get...

The one place where I consider using table variables is when I'm having issues with excessive, or long running, recompiles on a query. In that instance, I might choose to...

GilaMonster (12/1/2010)

---

You know there's a problem when...

In the last 2 weeks there have been three resignations at current client:

The senior developer (leaving only 2 permanent developers)

The Chief Enterprise...

joerg.kannengiesser (12/1/2010)

---

It seems, that MS changed something in the optimization,

maybe it's a bug in 2005R1 - I will check this again after installation of SP3.

Does anyone know if there's a...

The thing to remember is, despite it's unfortunate name, TIMESTAMP has nothing whatsoever to do with time. It's simply an incrementing number that is automatically updated each time a row...

I'm sorry, I don't understand the order that you're trying to achieve. It doesn't look like you're ordering by managerid or by employee id. Are you trying to retrieve the...

For what it's worth, foreign keys, constraints, statistics, and indexes can all affect the execution plan, so simply pointing at a query and asking which table is accessed first can't...

Oooh, good question. I haven't. I have listed...

Kit G (11/30/2010)

---

Grant Fritchey (11/30/2010)

---

Jeff Moden (11/30/2010)

---

Changing subjects, have you seen today's featured script? It comes under the category of "Are the featured scripts getting worse"? I try...

This is piling on, but I agree with Gail & Lowell. I've had the situation where certain tables (badly designed tables I might add) needed stats updated hourly, with a...

It sounds like the regressions I've heard from other people. In general, SQL Server 2005 and 2008 are much better with execution plans, etc, than 2000. But, there were some...