Wednesday, 15 February 2017

How to check the Log Space of a database in SQL server ?

›
In SQL Server maintaining the transaction log is a big challenge and as a DBA we always need to monitor the space used by the transaction ...
Tuesday, 14 February 2017

How to find the SQL Server Last Restarted date & time ?

›
One of the easiest way to find when SQL server was restarted is using Dynamic Management view (DMV). In some of the scenarios we need ...
Sunday, 12 February 2017

Types of Recovery Models available in SQL Server ?

›
In SQL server there are 3 different types of recovery models. Each database mush be selected to any of these 3 recovery models. Followi...
Saturday, 17 December 2016

How to find the last identity value in a table ?

›
In SQL server you can get the last value of the identity column in table using the Ident_Current function. Syntax IDENT_CURRENT(...
Tuesday, 13 December 2016

How to insert the Value in the Identity column of the table ?

›
In SQL server each table has identity column to auto increment the value , but there is sometimes we need to insert the value in the ident...
Sunday, 9 October 2016

Use of DATALENGTH function in SQL server ?

›
DATALENGTH function in SQL server is used to return the no of bytes used by the expression. SYNTAX DATALENGTH (EXPRESSION) EXA...
Monday, 26 September 2016

How to find the data file location of the Database ?

›
While creating the database the two types of data files such as MDF & LDF will be created in the drive. If we want to see the data...