We have been looking for key changes as a cause for index changes. What if there are no key changes at all? I'm betting that there are no...

Eric M Russell (1/26/2015)

---

Hey, it's 2015; the developer should code the application first, and then with a few clicks of the mouse they can auto-generate all the database junk in...

Nice article Ben. Thanks. I had often wondered about some of these super complex queries that I have seen. Why is that alias there? This makes...

Usually I'm the odd one out. It's comforting to know that I have been taking the reasonable course the whole time. The database is the foundation and the...

Eric the folks in the UK just went, "What?". Over there "biscuits" means something else. However free food and coffee is likely to clear out a data center...

Thanks Jeff. No actual test data but you would be right in presuming that if you change the type of a column that is indexed, either as the key...

Ic guess its funny that my experience is upside down from the rest. I've had better results when I go in someplace cold. I love design conferences.

"Folks we...

Understanding the way that SQL Server stores things is very helpful in understanding why some table alterations seem to take no time at all and other will bring the server...

Sean Lange (1/16/2015)

---

TomThomson (1/16/2015)

---

Sean Lange (1/16/2015)

---

TomThomson (1/15/2015)

---

Sean Lange (1/14/2015)

---

Koen Verbeeck (1/14/2015)

---

Nope, I'm control freak enough to change it to SELECT 1. I even do it in the scripts generated by...

To drive home the point that Jeff was making you can look at the PCs that your users are running. If the application lives on the desktop then for...

I have not had my coffee yet but I thought that on recent versions of SQL server that TempDB was cleared each time the instance started. Might it take...

Great QOD Steve. I would have not thought that this would have that many issues.

Seems that COUNT() does some fun things. I have been using COUNT(1) to mean...

At one company where I worked the development team worked for the support manager. This worked very well as our top priorities were to put in code to make...

At one company in a staff meeting it was said, "We don't prevent the user from shooting themselves in the foot. Rather we sell them a LASER sight." ...

ScottPletcher (1/2/2015)

---

GilaMonster (12/31/2014)

---

It's also far less clear than a DATEADD...