<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 Jorge Novo-@ETLDEVDBA
SQLServerCentral.com profile
Items 1 to 12 of 12
Dynamic Select Generator
Query to generate a dynamic Select statement from any table for moving data between servers.
Read more...
By
Jorge Novo-@ETLDEVDBA
2009/09/11
|
Source:
SQLServerCentral.com
|
Category:
dynamic query
Rating:
|
Discuss
|
Briefcase
|
1,362 reads
Table Index Store and Create
Query to save all index metadata
Read more...
By
Jorge Novo-@ETLDEVDBA
2009/07/17
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
816 reads
Backup and Truncate Transaction Logs
Save the transaction log and truncate the file to prevent Tlogs FULL Error
Read more...
By
Jorge Novo-@ETLDEVDBA
2008/12/16
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
2,558 reads
DDL Triggers Implementation
How to use DDL triggers and Query the Data with minimum performance impact.
Read more...
By
Jorge Novo-@ETLDEVDBA
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
ddl triggers
Rating:
|
Discuss
|
Briefcase
|
1,604 reads
Backup And Restore Remain Time
Script to found out how much time before Restore or Backup Process remain
Read more...
By
Jorge Novo-@ETLDEVDBA
2008/11/17
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
1,007 reads
Truncate All Tables Part 2
Restore relationships between tables
Read more...
By
Jorge Novo-@ETLDEVDBA
2011/06/03
|
Source:
SQLServerCentral.com
|
Category:
truncate table
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
944 reads
Truncate All Tables
Script to Truncate all tables part1
Read more...
By
Jorge Novo-@ETLDEVDBA
2011/06/02
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
7,346 reads
Move Physical Files
Script to move physical files to a new location
Read more...
By
Jorge Novo-@ETLDEVDBA
2012/03/30
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
2,888 reads
Set Database to Single user
How to set the database to a single user mode
Read more...
By
Jorge Novo-@ETLDEVDBA
2012/07/13
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
2,067 reads
Index File Group Locator
Find the File Group and Path of Indexes or identify where a file reside.
Read more...
By
Jorge Novo-@ETLDEVDBA
2008/05/19
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
904 reads
Find Parent Child RelationShip
Read more...
By
Jorge Novo-@ETLDEVDBA
2013/05/22
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
895 reads
Database count using system tables
Read more...
By
Jorge Novo-@ETLDEVDBA
2013/05/22
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
661 reads
Items 1 to 12 of 12
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
