What are SQL Query Hints?

SQL server usually selects the best query plan required to execute a T-SQL query. However, there might be cases where …

Compound Operators in SQL Server

There was a time when we all wished SQL Server supports compound operators just like any other programming languages. Wouldn’t …

GUID (Globally Unique Identifier) in SQL Server

The GUID (uniqueidentifier) data type is one of the most interesting data types available. uniqueidentifier column holds a GUI, a …

Save storage disk space by replacing “space” with “horizontal tabs”

This was a simple experiment that I performed to find, how much difference it makes by replacing some of the …

Insert “Space”,”new line”,”tab” characters into a field as value

There are times when you need to insert some special characters such as “newline”,”tab” etc as values into a field. …

ASCII character set table

ASCII character set and values in decimal,hexadecimal,oct Special Characters Char Oct Dec Hex Remarks NUL 0 0 0 Null character …