<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
Scripts by Jorge Novo-396570
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-396570
2009/09/11
|
Source:
SQLServerCentral.com
|
Category:
dynamic query
Rating:
|
Discuss
|
Briefcase
|
1,246 reads
Table Index Store and Create
Query to save all index metadata
Read more...
By
Jorge Novo-396570
2009/07/17
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
776 reads
Backup and Truncate Transaction Logs
Save the transaction log and truncate the file to prevent Tlogs FULL Error
Read more...
By
Jorge Novo-396570
2008/12/16
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
2,345 reads
DDL Triggers Implementation
How to use DDL triggers and Query the Data with minimum performance impact.
Read more...
By
Jorge Novo-396570
|
Source:
SQLServerCentral.com
|
Category:
ddl triggers
Rating:
|
Discuss
|
Briefcase
|
1,437 reads
Backup And Restore Remain Time
Script to found out how much time before Restore or Backup Process remain
Read more...
By
Jorge Novo-396570
2008/11/17
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
967 reads
Truncate All Tables Part 2
Restore relationships between tables
Read more...
By
Jorge Novo-396570
2011/06/03
|
Source:
SQLServerCentral.com
|
Category:
truncate
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
904 reads
Truncate All Tables
Script to Truncate all tables part1
Read more...
By
Jorge Novo-396570
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
7,149 reads
Move Physical Files
Script to move physical files to a new location
Read more...
By
Jorge Novo-396570
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
2,714 reads
Set Database to Single user
How to set the database to a single user mode
Read more...
By
Jorge Novo-396570
2008/05/20
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
1,555 reads
Index File Group Locator
Find the File Group and Path of Indexes or identify where a file reside.
Read more...
By
Jorge Novo-396570
2008/05/19
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
884 reads
Find Parent Child RelationShip
Read more...
By
Jorge Novo-396570
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
867 reads
Database count using system tables
Read more...
By
Jorge Novo-396570
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
641 reads
Items 1 to 12 of 12
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
