Hints and tips on mssql

These are some helpful hints on various topics.

 

MSQQL count(columnt) doesn't support all data types

In MSSQL queries like

select count(col1) from table1

will fail if column type is uniqueidentifier, text, image, ntext. Those types are not supported also in aggregate functions and subqueries.