Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with truncate
Search options answers only
not deleted
user 133879
An operation that removes all rows in a table without causing any triggered action
19
votes
Accepted
Truncate a table with 17 billion rows in an AG
Truncate table command truncates rows instantly and does not write deleted rows to transaction log file
Usually Truncate table executes instantly and there is no noticeable network traffic between replicas … Consider backing up the database and save the backup to archive before doing truncate, so you can restore the 17 billion table later, if needed …
- 5,964