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

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,451 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 | 856 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,652 reads

DDL Triggers Implementation

How to use DDL triggers and Query the Data with minimum performance impact.  Read more...
By Jorge Novo-@ETLDEVDBA 2008/10/02 | Source: SQLServerCentral.com | Category: ddl triggers
Rating: |  Discuss |   Briefcase | 1,699 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,034 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 | 977 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,543 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 | 3,044 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,104 reads

Index File Group Locator

Find the File Group and Path of Indexes or identify where a file reside.  Read more...
Rating: |  Discuss |   Briefcase | 917 reads
   Items 1 to 12 of 12