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 dbcc
Search options not deleted
user 219639
DBCC is a T-SQL statement provided by SQL Server. This tag is used for questions regarding DBCC and its use.
1
vote
1
answer
715
views
Log File Size and dbcc sqlperf (logspace)
#TempForLogSpace'))
DROP TABLE #TempForLogSpace;
CREATE TABLE #TempForLogSpace
(
DBName varchar(MAX),
LogSize real,
LogSpaceUsed real,
Status int
)
SELECT @sql_command = 'dbcc … )
should be increasing,
and if the ldf size reaching the initial size, SQL server
would increase the ldf file size by another 500MB and so would the the value of
FileSize = LogSize (DBCC). …
- 113