GilaMonster (4/11/2011)

---

Yes, I have a bunch of PMs on the topic....

GilaMonster (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

I'm likely using the wrong word. the metrics that are gathered by SQL Server to improve performance on subsequent runnings of a query. I knew the word...

People complained about the lizard?

GilaMonster (4/11/2011)

---

Errr, what statistics are you talking about and why...

Brandie Tarvin (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

GilaMonster (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

Believe me, I don't want to be using a cursor, but it is part of production code and every time I mention changing...

GilaMonster (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

Believe me, I don't want to be using a cursor, but it is part of production code and every time I mention changing it to set based...

WayneS (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

CirquedeSQLeil (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

WayneS (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

Can someone point me to one of the posts where the keywords to make a cursor run as fast as possible...

CirquedeSQLeil (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

WayneS (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

Can someone point me to one of the posts where the keywords to make a cursor run as fast as possible are listed? I...

WayneS (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

Can someone point me to one of the posts where the keywords to make a cursor run as fast as possible are listed? I searched, but couldn't...

Can someone point me to one of the posts where the keywords to make a cursor run as fast as possible are listed? I searched, but couldn't find what I...

This article might help.

Solving the Running Total and Ordinal Rank Problems[/url]

It was very nice to meet you. Did you want my agency contacts so you can call them?

One way is to create the query as a string, put it in a variable and execute the variable

DECLARE @LinkedQuery varchar(500)

DECLARE @NoDossier varchar(10)

SET @NoDossier = '1315-21738'

SET @LinkedQuery = 'SELECT RowID,...

GSquared (4/8/2011)

---

SanDroid also sent me some inane private messages. Somehow, me not quoting "who guards the guards" in Latin (I wrote it in English) was wrong, referencing Plato in...

WayneS (4/8/2011)

---

Kiara (4/8/2011)

---

Frankly, I learn more when I get a QotD wrong than when I get it right. The points are meaningless - the knowledge, on the other hand, is...