The Axis Of Evil
Views, table variables and local variables are great in terms of programming principles. But In terms of performance, they can be a honey...
Search
max data types performance
On some occasions, migrating from text, ntext or image to varchar(max), nvarchar(max) or varbinary(max) can hurt performance. How is that...
Collations vs. Performance
Recently I’ve stumbled upon an apparently little known fact about SQL Server – specifically SQL Server collations and how they affect...