Add a NOT NULL column to an existing table – Performance improvement SQL Server 2012
Why alter table add NOT NULL column takes long time? Adding a NOT NULL column to the existing table will run for longer time for high volume tables. Because SQL…
Read more »Uses of OUTPUT clause in SQL Server
The output clause introduced in SQL Server 2005 is handy and it simplifies the coding for different scenarios. It returns inserted, deleted and updated records to the client application. Employee…
Read more »Table type in sql
Table type is introduced in SQL 2008. Table type will be useful to send multiple records to a store procedure or function and it can be used to declare a…
Read more »Table variable and Table type in transaction
The myth is to roll back the work done inside the transaction, in case of any error during the transaction. However this is not the case with the SQL Server…
Read more »How to insert values into an Identity column in SQL Server
Identity is a property that can be set on a column. When an identity is enabled the column will be populated automatically by system and it will not allow user…
Read more »