SQL

It is very difficult to find a procedures / Commands used in SQL Server Jobs from the huge cluster of Jobs through SQL Server Management St...

By default SQL Server loads master databse. Sometimes it is required to change the default database in SQL Server. Use below query to chag...

Use below query to get the database file size.  I have used system view “sysaltfiles” from “master” database which keeps information about ...

Today my one client told me that their database could not access in yesterday, we try to use the database and got message error  the da...

Sometime we may mistakenly insert data into a wrong column if we have two identical columns with same data type. To correct this we have to...