SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag delete Rss

   Items 1 to 20 of 32    Older >>
 

Can you prevent deletes and inserts without a WHERE clause from running?

Erik writes a script to do what it says on the tin.  Read more...
By Additional Articles 2018/01/01 | Source: Brent Ozar Unlimited Blog | Category: delete
Rating: (not yet rated)  Rate this |   Briefcase | 4,354 reads

OUTPUT Clause Basics (For Inserts and Deletes)

When INSERTING or DELETING rows from a table, the OUTPUT clause can be used to return a dataset containing the changes made. Mat Richardson explains how.  Read more...
By Mat Richardson 2017/05/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,064 reads

SQL Prompt 7.2 – Now With Execution Warnings!

Redgate’s code completion tool SQL Prompt now provides you with a handy warning if you try to execute an UPDATE or DELETE statement without a WHERE clause. Bob Pusateri explains why he loves this added layer of protection, and why you should too.  Read more...
By 2016/06/02 | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,848 reads

Differences between Delete and Truncate in SQL Server

Atul Gaikwad details the differences between DELETE and TRUNCATE, including how they vary in terms of being rolled back.   Read more...
By Additional Articles 2016/05/18 | Source: MSSQLTips.com | Category: delete
Rating: (not yet rated)  Rate this |   Briefcase | 4,328 reads

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2015/09/04 (first published: 2013/03/06) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 22,989 reads

Remove data from tables

By G. C. 2015/03/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,979 reads

Difference between Delete,Truncate and drop

By Vivek Raj 2014/12/01 | Category: transactions
Rating: (not yet rated) |  Discuss |   Briefcase | 2,241 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 | 5,153 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,753 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,556 reads

Delete v Truncate

By Naseer Ahmad 2013/03/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,512 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 | 23,138 reads

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2015/09/04 (first published: 2013/03/06) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 22,989 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 | 5,153 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 | 5,153 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,820 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,774 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,798 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 | 23,138 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 | 50,334 reads
   Items 1 to 20 of 32    Older >>
 
Tags
t-sql (13)    
truncate table (4)    
insert (3)    
truncate (3)    
update (3)    
where (2)    
archiving data (1)    
backup and 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)    
execution warnings (1)    
foreign keys (fk) (1)    
generate (1)    
identity property (1)    
locking (1)    
lookup (1)    
maintenance (1)    
merge (1)    
metadata (1)    
migration (1)    
objects (1)    
output (1)    
purge (1)    
reference (1)    
referenced tables (1)    
relationship (1)    
replication (1)    
rollback (1)    
sql prompt (1)    
sql server 2000 (1)    
sql server 2005 (1)    
sql server objects (1)    
static (1)    
stored procedures (1)    
top (1)    
transactions (1)    
triggers (1)    
xp_cmdshell (1)