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

Content with tag delete Rss

   Items 1 to 20 of 25    Older >>
 

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 4,425 reads

How to find user who ran DROP or DELETE statements on your SQL Server Objects

Someone has dropped a table from your database and you want to track who did it. Or someone has deleted some data from a table, but no one will say who did. In this tip, we will look at how you can use the transaction log to track down some of this information.   Read more...
By Additional Articles 2013/12/12 | Source: MSSQLTips.com | Category: sql server objects
Rating:  Rate this |   Briefcase | 6,230 reads

Automated Trigger To Require a WHERE Clause

Learn how you can build triggers that prevent an update or delete statement from being run without a WHERE clause in this article.  Read more...
By Rahul Kumar Ghosh 2013/08/09 (first published: 2011/01/25) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 16,506 reads

Delete v Truncate

By Naseer Ahmad 2013/03/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,441 reads

Deleting large number of rows from a table in a VLDB

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.  Read more...
By Nakul Vachhrajani 2013/03/08 (first published: 2011/03/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,957 reads

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2013/03/06 | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 12,581 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 4,425 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 4,425 reads

Large table cleanup with minimal locks

How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.  Read more...
By Edward Polley 2012/03/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,352 reads

Options to not replicate SQL Server DELETE commands

I have transactional replication configured in my production environment. The business team has requested that I do not replicate delete operations on certain articles. In this tip we look at a couple of options to not replicate DELETE commands.  Read more...
By Additional Articles 2011/11/04 | Source: MSSQLTips.com | Category: replication
Rating:  Rate this |   Briefcase | 2,257 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,682 reads

Deleting large number of rows from a table in a VLDB

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.  Read more...
By Nakul Vachhrajani 2013/03/08 (first published: 2011/03/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,957 reads

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005  Read more...
By Lynn Pettis 2011/02/18 (first published: 2009/09/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 49,330 reads

Automated Trigger To Require a WHERE Clause

Learn how you can build triggers that prevent an update or delete statement from being run without a WHERE clause in this article.  Read more...
By Rahul Kumar Ghosh 2013/08/09 (first published: 2011/01/25) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 16,506 reads

The DELETE statement in SQL Server

Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd considering the extra power conferred on the statement by the addition of the WITH common_table_expression; and the OUTPUT clause that essentially allows you to move data from one table to another in one statement.   Read more...
By Additional Articles 2010/12/13 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 5,849 reads

Easily delete database objects

The stored procedure sp_DropDatabaseObject is designed to easily drop a variety of database objects with extensive feedback to the user  Read more...
Rating: |  Discuss |   Briefcase | 1,413 reads

Identity Crisis

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

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005  Read more...
By Lynn Pettis 2011/02/18 (first published: 2009/09/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 49,330 reads

Easily delete database objects

The stored procedure sp_DropDatabaseObject is designed to easily drop a variety of database objects with extensive feedback to the user  Read more...
Rating: |  Discuss |   Briefcase | 1,413 reads

The Safe and Easy Way to Delete All Data in a SQL Server DB

Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.   Read more...
By Additional Articles 2009/03/03 | Source: DevX | Category: t-sql
Rating:  Rate this |   Briefcase | 4,183 reads
   Items 1 to 20 of 25    Older >>
 
Tags
t-sql (10)    
truncate table (3)    
update (2)    
archive (1)    
backup / restore (1)    
data (1)    
domain (1)    
drop (1)    
drop database objects (1)    
drop function (1)    
drop indexes (1)    
drop procedure (1)    
drop tables (1)    
drop views (1)    
foreign keys (fk) (1)    
generate (1)    
identity property (1)    
insert (1)    
locking (1)    
lookup (1)    
maintenance (1)    
merge (1)    
metadata (1)    
migration (1)    
objects (1)    
purge (1)    
reference (1)    
referenced tables (1)    
relationship (1)    
replication (1)    
sql server 2000 (1)    
sql server 2005 (1)    
sql server objects (1)    
static (1)    
stored procedures (1)    
top (1)    
triggers (1)    
truncate (1)    
xp_cmdshell (1)