SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Sheraz Mirza

SQLServerCentral.com profile

   Items 1 to 9 of 9   
 

Getting TEXT, NTEXT and IMAGE columns in Database

As per Microsoft documentation these types will be removed from future version   Read more...
By Sheraz Mirza 2017/06/02 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 304 reads

Converting values into Rows

Script describe one of the way to divide values into rows by using any specified dividing value.  Read more...
Rating: |  Discuss |   Briefcase | 688 reads

Getting top ranked employee detail for each department

Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.   Read more...
By Sheraz Mirza 2016/10/25 | Source: SQLServerCentral.com | Category: over clause
Rating: |  Discuss |   Briefcase | 443 reads

SQLCMD to export data in txt file

SQLCMD is one of many methods to export your database data to some text file  Read more...
By Sheraz Mirza 2016/10/12 | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 774 reads

Handling with currently running and blocking sessions

Checks currently running sessions and blocking queries with session information  Read more...
By Sheraz Mirza 2016/10/05 | Source: SQLServerCentral.com | Category: current running sessions
Rating: |  Discuss |   Briefcase | 585 reads

Script to Generate Foreign Keys

Generate Script for existing Foreign Keys for any emergency.  Read more...
By Sheraz Mirza 2016/07/05 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 679 reads

Procedure to Find Candidate Keys

This Procedure will Display all the keys in a Specified Table   Read more...
Rating: |  Discuss |   Briefcase | 558 reads

Getting LEAD and LAG values manually

LEAD and LAG functions are new in SQL Server 2012 , This short Script could be used to get these values in Earlier versions also  Read more...
By Sheraz Mirza 2016/06/28 | Source: SQLServerCentral.com | Category: lead function in 2008
Rating: |  Discuss |   Briefcase | 699 reads

Table Comparison Procedure

Procedure to compare two tables , getting table names and rows to display  Read more...
By Sheraz Mirza 2016/06/07 | Source: SQLServerCentral.com | Category: table data comparison
Rating: |  Discuss |   Briefcase | 908 reads
   Items 1 to 9 of 9