<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
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
|
764 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,315 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,818 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,657 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
|
848 reads
Partition table is easy
Partitioning table is easy. Learn how to do this.
Read more...
By
Jason S Wong
2009/11/25
|
Source:
SQLServerCentral.com
|
Category:
partition table performance
Rating:
|
Discuss
|
Briefcase
|
1,436 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,440 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,004 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,043 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,393 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,221 reads
Items 1 to 11 of 11
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
