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 2241
An operation that removes all rows in a table without causing any triggered action
27
votes
Accepted
Truncated 200GB table but disk space not released
Best Practices
Consider the following information when you plan to shrink a file:
A shrink operation is most effective after an operation that creates lots of unused space, such as a truncate …
- 42.4k
14
votes
What permissions are necessary for truncating a table?
TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable. … However, you can incorporate the TRUNCATE TABLE statement within a module, such as a stored procedure, and grant appropriate permissions to the module using the EXECUTE AS clause. …
- 42.4k
21
votes
Accepted
Safe way to truncate SQL Server Error Log
This will not technically "truncate" the log, it'll just roll it over and you can handle the old logs as you so please, like any other file system file. …
- 42.4k