The great thing about new versions of SQL Server is the fact that they are packed full of new features but there some that don’t really get talked about much. I found out about a concept called lightweight query execution … Continue reading
Tags: SQL Server
Related Articles
Schema Compare in Toad for SQL Server
In this short demo, you will learn about the Schema Compare feature in Toad for SQL Server. ...
Devops without management buy in?
I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database but they had a number of issues, the main was that because management wasn't sold on...
Allowing Only One NULL
While the SQL standard allows multiple NULLS in a unique column, and that is how Postgres behaves, some database systems (e.g. MS_SQL) allow only a single NULL in such cases. Users migrating from othe...
