bbbrian007 (12/27/2007)

---

Yep - sounds like dynamic SQL is my best bet, I've got lots of optional parameters and lots of rows.

Maybe in the future, Microsoft will improve their optimization algorithms...

Chris Morris (1/2/2009)

...In the absence of an index, Adi's query will always be fastest because dates in the table are checked as-is against the reference dates - the other methods...

But it is precisely these Waits that you should address. i.e. where there are many requests each experiencing (on avg) a 11ms wait. Thus the cumulative figure is significant. I...

The upgrade advisor documentation answers this. Install UA on another server and run the analysis of your target server from there.

Good points.

I share your frustration when we seem to have to hunt endlessly for a post by somebody who has managed to resolve a problem that you now face. Far...

sobrien (11/7/2008)

---

I wasn't being overly critical. I was stating my opinion. I found the article very hard to get through because of the way it was written; therefore, I got...

We shouldn't be overly critical of somebodys work unless it is seriously wrong. I am guessing English is this guy's second language. At least he has taken...

Basic intro for newbies.

Isn't SP_MSforeachdb undocumented, therefore unsupported ? I'm always a bit wary of using undocumented sprocs as they may be withdrawn in later releases thus requiring you...

Like many who attempted the question, I got the right answer but possibly for the wrong reason. At first, I though truncation and implicit conversion would occur, but as 600,000...

Rajan John (9/9/2008)

---

douglascfast (9/9/2008)

---

Did I miss something? If two columns are 1 in lengh, and the others are 9 "some text" and 14 "Some more text", then would not...

Questions like these should be worth more than 1 point!

Good 'trick' question!

Ric Sierra (9/4/2008)

---

I'm not completly agree with the answer, because depends of the context:

If you are looking for the best execution plan the answer is #1

If you are looking for...

Dual Core (as above) or hyperthreading is enabled. Check the BIOS/CMOS settings of the server.

Thanks Gail

Hi Phillip

If I ran a query in QA and wanted to clear out any caching before executing the query again, would 5) DBCC FREEPROCCACHE also apply in that case or...