You must mean GilaMonster.

The article contradicts the title.

SHRINKFILE is not "a very bad thing" and the article confirms that. It is no different than any other tool in the arsenal of...

stevehindmarsh (12/9/2011)

---

One comment - 'Dynamic Ports being the default for named instances'. The port is only truly dynamic for the installation of SQL Server - once it's installed, the port...

Ninja's_RGR'us (12/6/2011)

---

Because the table variable is so small, I figured that without the overhead of statistics or minimal disk I/O, I might gain some time. It's an interesting thought, but...

Evil Kraig F (12/5/2011)

---

I was going to get back involved here, but after what appears to have happened over the weekend and this morning, I'll pass.

Nico, did Ninja use the...

Grant Fritchey (12/5/2011)

---

nico van niekerk (12/2/2011)

---

The original query's construct, somehow, allowed SS to rely on the statistics alone and not look at the query from a new perspective. The OPTIMIZE...

bteraberry (12/5/2011)

---

Good article, but I would highlight a point...

No offense taken.

We're good. Thanks for clarifying.

Grant Fritchey (12/5/2011)

---

nico van niekerk (12/4/2011)

---

...Table variables are created in memory with the current batch as scope exclusively. #temp and other tables are explicitly created "on disk" as you put...

If nobody is challenging what I said, then what does Dixie Flatline's comment "But the above statements can't remain unchallenged" mean? Dixie also didn't challenge...

Fair enough.

The Dixie Flatline (12/4/2011)

---

nico van niekerk (12/2/2011)

---

The temp table was not #tmp but @Tmp, a table definition and one cannot create indexes on table definitions. Its residence in...

Ninja's_RGR'us (12/4/2011)

---

I'm not snide, I have different POV in mind.

People find these threads with google and they need to know the whole story.

You got my info and best links. ...

Ninja's_RGR'us (12/2/2011)

---

nico van niekerk (12/2/2011)

---

The original query's construct, somehow, allowed SS to rely on the statistics alone and not look at the query from a new perspective. The OPTIMIZE hint...

Table variables, not definitions. I age quicker than originally expected. 🙂