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

Content with tag Truncate Table Rss

   Items 1 to 20 of 20   
 

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition   Read more...
By Vidyadhar Pandekar 2014/01/20 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 7,146 reads

Truncate Table

By Vinay Kumar 2013/03/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,247 reads

What will the max id be?

By Ben Kubicek 2012/12/19 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 2,163 reads

Table Variable

By Clare Newman 2012/08/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,952 reads

T SQL

By Samith C 2012/07/10 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,192 reads

Grant Truncate Table Permissions in SQL Server without ALTER Table

How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip.  Read more...
By Additional Articles 2012/01/16 | Source: MSSQLTips.com | Category: truncate table
Rating: (not yet rated)  Rate this |   Briefcase | 2,758 reads

Difference between Truncate and Delete

This article explains you the differences between the Truncate and Delete commands in SQL.  Read more...
By Prashant Pandey 2011/07/04 (first published: 2007/11/22) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 27,674 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 | 980 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,575 reads

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition   Read more...
By Vidyadhar Pandekar 2014/01/20 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 7,146 reads

Truncate Transaction - All Databases

Script to help you to truncate TL for all databases.  Read more...
By Disney Hammerschmidt 2010/05/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,937 reads

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition   Read more...
By Vidyadhar Pandekar 2014/01/20 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 7,146 reads

TRUNCATE

By Prakriti Agrawal 2010/02/05 | Category: truncate table
Rating: (not yet rated) |  Discuss |   Briefcase | 4,728 reads

usp_ShrinkAllLogs

Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.  Read more...
By Banyardi Schmardi 2009/11/27 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 915 reads

Identity Crisis

By dun 2009/10/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,772 reads

TRUNCATE vs DELETE

By Noel McKinney 2009/10/09 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 5,266 reads

sp_truncate

Truncates referenced tables  Read more...
By Sergey Benner 2009/01/23 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,708 reads

Truncate Referenced Table

Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.  Read more...
By Chris Morton 2009/01/19 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,251 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,575 reads

Difference between Truncate and Delete

This article explains you the differences between the Truncate and Delete commands in SQL.  Read more...
By Prashant Pandey 2011/07/04 (first published: 2007/11/22) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 27,674 reads
   Items 1 to 20 of 20   
 
Tags
t-sql (8)    
delete (3)    
foreign keys (fk) (3)    
identity property (3)    
administration (1)    
alter table (1)    
development (1)    
logs (1)    
metadata (1)    
partitioned table (1)    
referenced tables (1)    
relationship (1)    
sql server 2008 (1)    
table partition (1)