Lock Escalation

Fun with Light Bulbs

I needed an image of a “great idea”, and decided to use a light bulb. I started looking through Flickr...

Parameterization Settings

Collation Conflicts in a SQL Server Join

I went to run this query recently:
select TOP 10 *
from users a
inner join Banned b
on a.username = b.usernameand...

Hints Are Not Always Better

This week Steve Jones reminds us that improving performance in T-SQL is not always obvious. Those little nuggets of knowledge can be very handy, which is why you should be regularly looking to acquire more of them.

Which Bugs Do You Find?

This Friday Steve Jones wonders what types of bugs you find in software. Are there more prevalent because of design or coding?

Filestream

IT and Innovation

This is a powerful quote:
“This is the digital world IT must keep up with–one where Apple can view a...

Plans

Fun with SQLskills

I’m in a fun mood today, so a few silly items for you.
The last few weeks, Paul Randal (blog | @PaulRandal)...