DELETE, TRUNCATE with RESEED Identity in SQL Server
How to Drop Primary Key Constraint
SQL SERVER – Maximum Number of Index per Table
Date and Time Function in SQL
Select Command in SQL Server
Nested Queries in SQL Server
Change Data Capture (CDC) in SQL Server
How to Backup a Table in SQL Server
How to Backup a SQL Server Database
Upgrade SQL Server 2005 SP3 to SP4
Beginning of SQL Server Security – Guest Post
SIGN is an in-build function of Transact-SQL. This is a mathematical function that returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.