ScottPletcher (9/16/2013)

---

An overgrown log file can have too many VLFs, which can adversely affect performance.

On some disks, the autogrowth can result in a less contiguous log file, which can also...

Amen to that. Rote memorization has its place, but that's not the highest skill level you should want in an employee, or contractor. I rarely even bother trying to memorize...

GilaMonster (8/23/2013)

---

pdanes (8/23/2013)

---

I suppose during the import process. This table is not copied - it's part of a design change, and is newly generated from...

GilaMonster (8/23/2013)

---

Heaps you can't defrag (well, there's alter table rebuild, but...), and fragmentation means something very different on a heap vs a table. The other one, it's honestly far too...

GilaMonster (8/23/2013)

---

The rough guideline is somewhere in the vicinity of 1000 pages (8MB data). It's not a hard number (defrag at 1001, ignore at 999), just a rough figure about...

Hi Gail. I was hoping to meet you in person during SQL in the City last month, but I got involved in a scuffle with the passport control police...

MyDoggieJessie (8/23/2013)

---

192K, still quite small. The effectiveness of an index seek on a table with so few little rows really won't show much of a performance hit/improvement that a...

Umm,...

Thank you. SQL Server purists may howl, but I'm pretty pleased with it. It took a while to get all the string assemblies working correctly (missing commas,...

Absolutely. In fact, I have an app that gets most of its data via such queries. After much experimentation, including a SQL in the City session in London last summer,...

Sean Lange (8/22/2013)

---

Are you always this snarky to people who are honestly trying to help? I tried to explain how TOP works. Maybe TOP is not the most efficient way...

L' Eomot Inversé (8/22/2013)

---

Obviously there's no way to avoid a complete scan when all the values are the same.

It's possible to have something which takes quadratic time when...

Steve Jones - SSC Editor (8/22/2013)

---

Doctor Who 2 (8/22/2013)

---

I like what you wrote here, Steve, but I wonder how practical it is. However, it might just be my work environment....

Sean Lange (8/22/2013)

---

No that is how it works. If you use the TOP predicate you generally should also use an order by clause. Without the order by there is no...

Doctor Who 2 (8/22/2013)

---

I like what you wrote here, Steve, but I wonder how practical it is. However, it might just be my work environment. Having worked in a small...