I have seen extremely talented software engineers leave companies because of a bad manager. These were non-nonsense programmers that wanted nothing more than to do a good job. ...

GilaMonster (10/4/2015)

---

If you're in compat mode 100, then it's not the cardinality estimator. That's usually what causes performance regressions in 2014. The traceflag Phil suggested won't help if it's not...

Eirikur Eiriksson (10/4/2015)

---

Quick suggestion, have a look at this article When is a Seek not a Seek? by Paul...

Yes, it is a huge IN clause with hundreds of elements.

If a company wants to attract and retain the best software engineers, then they will allow them to dress as software engineers. Remember, the good engineers are in demand...

There is a YouthDigital course: "kids ages 8-14 learn Java programming by modifying Minecraft®* and creating their own

Mods from start to finish."

The application should specify the columns in the query and be immune to new columns in the database. Different applications can share the same database and each use their...

I sux at sql, but isn't the fact the error is in line 1 a huge hint?

I think the "% Free" column should be labeled "% Used".

The system is already working. Best case scenario after upgrading is that the system still works. There is no motivation to spend the time and money to get...

Ed Pollack (6/16/2014)

---

That's an understandable question---and I intentionally left out any automatic scripting from the article. Adding and removing indexes is delicate work and should be done carefully with...

This is a great article and very useful....

"Finding and Eliminating..." - Nothing said about eliminating the duplicates!

We don't have managers. We use the "Group System" where everyone is a member of one or more groups. Each group reports to another group in a hierarchy....