Testing and comparing SQL Server query performance

A while back I talked to a developer, who played also the role of involuntary DBA at a company.
As we were discussing the poor performance of one of their servers, I realized that something wasn’t adding up, so I decided to ask the blunt question:

“How do you measure the performance of the

Continue reading […] Testing and comparing SQL Server query performance […]

 

Beware: collation database_default

I have seen in so many blog posts a proposed solution to the ‘cannot resolve the collation conflict’ problem; many of the blog posts and forums suggest that the collate database_default will solve the problem.

As I got a similar problem a few days ago, I stopped for a second and I though ‘hm, can

Continue reading […] Beware: collation database_default […]