Viewing 15 posts - 7,096 through 7,110 (of 49,552 total)
Database files never reduce in size automatically.
Don't run that backup with truncate only. That's just a log backup which doesn't write the backup file, no special magic in it. However...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2014 at 1:41 am
Alex Jordan (12/3/2014)
I figured it out. Apparently I can order sub-queries as long as I provide a alias.
Nothing to do with the ORDER. Derived tables always need an alias.
Edit, and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2014 at 1:39 am
Database files never reduce their size automatically.
And I would strongly recommend against going and putting page compression on all tables. Have you tested the performance? Is the CPU overhead of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2014 at 1:32 am
Without seeing the execution plan, vague guess. Index is not covering and too many rows are being returned to make index seek + all the key lookups efficient.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2014 at 1:30 am
SQL doesn't have block scope for variables.
From Books Online (DECLARE)
The scope of a local variable is the batch in which it is declared
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 6:16 am
Why?
MSDB shouldn't see heavy usage, not to the point of being a concern around size of cache plans.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 5:20 am
Very first sentence in the section "Include columns"
Columns specified as include columns are stored at the leaf level of the nonclustered index
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 5:15 am
http://www.sqlservercentral.com/articles/Indexing/68636/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 3:08 am
It does not. That's generally something that you do in source control.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 1:41 am
Don't flush the plan cache. All you're doing with that is forcing SQL to do more work to recreate the plans. You're going to be hindering performance by doing that,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 1:40 am
The reason is right there in the message.
'Failed to open a file. Access is denied'
Whatever user is trying to access the file does not have permission on either file or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 1:39 am
In that case, why are you even bothering to do the checks? Just do the insert and then run the select.
Generally, when someone writes code that:
- Checks if a row...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 1:36 am
Sachin Bankar (12/2/2014)
Can I consolidate above index to a single index?
Yes
Is sequence important?
Not of includes
Note : If these indexes have been automatically created by DBA based automatic analyser suggestions and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 1:28 am
Set the log to the size it needs to be for regular operations, configure a sensible autogrow, then leave the file alone. Stop shrinking it and forcing it to regrow.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 1:13 am
Joy Smith San (12/2/2014)
I have enabled DDL trigger for auditing purpose. It inserts a record into one of the table in that database which is dropped already.
Hence will be failing,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2014 at 1:12 am
Viewing 15 posts - 7,096 through 7,110 (of 49,552 total)