2016-05-25 (first published: 2014-03-06)
2,198 reads
Defragmentation.
RE: Delete Large records 20 million rows!!! FAST
I would use the the TRUNCATE command. The deletions will not be logged in the transaction log. e.g. TRUNCATE TABLE authors You need to be either a member of the sysadmin role the database owner or a member of the db_ddladmin to run this command hope this helps Dave
2004-03-22
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers