▼
Wednesday, 17 October 2012

Exec Store Proc user defined Role

›
Several of my client request for a role which has execute permission to all store procedures in a database, most of the time I have seen ...
5 comments:
Wednesday, 10 October 2012

Behaviour of log chain with Full backup

›
Will the Log chain break when we take a full backup of a database?   As per Microsoft documents, A log chain starts with a full backu...
4 comments:
Thursday, 4 October 2012

How to reset stats in sys.dm_os_wait_stats view

›
One of main DMV's used in SQL Server for performance tuning is  sys.dm_os_wait_stats ,  the view returns all the waits executed by a ...
7 comments:

Differential backup and differential_base_lsn

›
In this blog I would like to explain where the Differential backup metadata(LSN details) are stored with an example,  Recently I took a Ful...
4 comments:
Tuesday, 25 September 2012

How to Rename SQL Server

›
With the release of SQL 2012 most of the companies might have started migration of SQL server to new version, In case of server migrations ...
7 comments:
Monday, 3 September 2012

Process Explorer

›
As a DBA you land in situation where you need to find which process is using a File on the disk,   For Eg:- Your Tape backup process ...
7 comments:
Wednesday, 29 August 2012

How to use Row_number() to insert consecutive numbers (Identity Values) on a Non-Identity column

›
Scenario:- We have database on a vendor supported application in which a Table  TestIdt  has a integer column  col1  which is not spe...
8 comments: