Find Primary Keys or Constraints in a database, SQL Server 2008
I was asked to list the Primary keys in our databases then I listed using the below script. This is very
Month: June 2011
Compare Two Tables Using T-SQL or Command Line Utility (tablediff.exe)
There is out too many ways to compare two tables in SQL server but I prefer to do this task
ColumnStore Indexes in SQL Server 2011, Code Named “Denali”
This new type of Index is introduced with new upcoming 2011 version of SQL Server. This new index improves the
New Features in SQL Server 2011 or Code Named “DENALI” CTP1
Microsoft SQL Server Code-Named “Denali”, this release increases the power and productivity of architects, developers, and administrators who design, develop,
Script to find Backup History- SQL Server
This Script gives the backup history of all databases with in a instance. Also gives you when is the database
Database Comparision- Schema Compare, Data Compare,synchronization and validation
Have you ever given a task to do validate two databases on different servers or on the same server? Usually
Robocopy
Robocopy is used to move or Copy files or folders Also have multiple options Check out this link for more
Activity monitor, Script to find Head blocker- SQL Server 2005, 2008 and later
This is very handy useful script in production environment. Even the activity monitor does the same but when there is
Script to backup all databases in an instance – SQL Server
I have this script for a while and used it as many times in my daily routine. The below script
Script to find Unused Indexes- SQL Server
Run the below script on a database where you want to find the missing indexes. DECLARE @sql varchar(2000) ,@DatabaseName varchar(20)
