#important script for sql server

[jayeshsorathia]

Some time you Database Physical file Address and file size using sql script.

[jayeshsorathia]

Sometimes we have situation in which we want delete all records of table and that table contains identity column as primary key and we want again insert some new records in this table , so in this case identity column does not start with 1 but it start with last number that we had before deleted records.