SQL

You cannot restore the individual table(s) from a database backup!  So, you had to follow the following steps to restore single table from ...

With the help of built in SQL Server functions we can easily achieve this as shown below. Select Day(DateAdd(Month, 1, '01/01/2012...

Option 1:  Right-click on a table and choose 'View Dependencies'. Option 2:  For some reason if you want to do it programmatically ...

If we drop a column it gets dropped but the space which it was occupying stays as it is!   In this article we would see the way to reclaim ...

This procedure gets the date a file was updated, as reported by the file system.  exec sp_configure 'show advanced options', 1;   ...