CTE introduced in Microsoft SQL Server 2005 that offer a more readable form of the derived table that can be declared once and referenced multiple times in a query and we can used

You can use this approach if you want to audit any logon by user to Sql Server instance but note that the Logon triggers are fired after authentication succeeds but before the user session is

SELECT INTO statement allows you to create a new temporary or permanent table populated with the results of the defined SELECT statement

Most of us know about % and _ but what about the remaining wildcard characters so let us see them in details. Square Brackets [] are used to replace any one char within a set or range of characters

Data Compression in SQL Server has been made available in SQL Server 2005 with Service Pack 2 where a new storage format for storing decimal and numeric data was introduced