Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Jason S Wong

SQLServerCentral.com profile

   Items 1 to 11 of 11   
 

T-SQL CLR to query session hostname

This code allows you to query hostname of each session on your database.  Read more...
By Jason S Wong 2012/06/01 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 814 reads

sp_spaceused2

The sp_spaceused procedure does not provide schema name in return. Here is sp_spaceused2 that does.  Read more...
By Jason S Wong 2012/04/02 | Source: SQLServerCentral.com | Category: size
Rating: |  Discuss |   Briefcase | 1,361 reads

Backup by datetime file name

An example script to show how you backup database by the datetime file name  Read more...
By Jason S Wong 2010/07/12 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,857 reads

Huge Insert .... Select that not blocking using snapshot isolation

a technique that allows large insert .... select but blocks no other queries  Read more...
By Jason S Wong 2010/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,711 reads

Find backup set

When you need to know where your backup files are and the timing.  Read more...
By Jason S Wong 2009/11/24 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 871 reads

Partition table is easy

Partitioning table is easy. Learn how to do this.  Read more...
Rating: |  Discuss |   Briefcase | 1,486 reads

Copy/Refresh a database in the night

Refresh a report database with this script.  Read more...
By Jason S Wong 2010/07/16 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,484 reads

Index defrag - rebuid/reorg

Have databases maintenance tasks run itself in the weekend  Read more...
By Jason S Wong 2010/07/07 | Source: SQLServerCentral.com | Category: defragmentation
Rating: |  Discuss |   Briefcase | 5,057 reads

Search a particular text string in all SPs

An easy method to search inherited SP codes for a particular text  Read more...
By Jason S Wong 2009/10/23 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,064 reads

Find Foreign Key Tables

an easy method to find foreign key tables from primary key table  Read more...
By Jason S Wong 2009/10/27 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,456 reads

Automate scripting of database file shrink

I have a large number of databases that I can free up significant space, but to avoid resource conflict,   Read more...
By Jason S Wong 2009/11/09 | Source: SQLServerCentral.com | Category: shrink database
Rating: |  Discuss |   Briefcase | 2,261 reads
   Items 1 to 11 of 11