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.