Viewing 15 posts - 8,836 through 8,850 (of 49,552 total)
patrickmcginnis59 10839 (6/3/2014)
So whats the beef with "best practices"?
Over-priced 'consultants' who justify their non-standard settings and unconventional configuration options with 'It's best practice' with an undertone of 'and lesser...
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
June 3, 2014 at 2:58 pm
Faisal Malik (6/3/2014)
You can't use copy_only backup in point in time recovery.
The only thing you can't do with a copy-only is restore differentials onto it. You can restore log backups...
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
June 3, 2014 at 10:28 am
The key column vs include column should be answered by the third one.
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
June 3, 2014 at 10:26 am
All you need to do there is get the date of the current getdate(), with the time portion removed (easy enough), then add that 23 hours and 59 minutes to...
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
June 3, 2014 at 6:35 am
SET @StopTime = DATEADD(MINUTE,59,DATEADD(HOUR,23,GETDATE()))
Trace will stop 23 hours and 59 minutes after it starts, so if started at midnight it will stop at 23h59
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
June 3, 2014 at 2:38 am
The only way a DB can record 'negative' size or free space is when the page allocation data is wrong. Hence Jeff's recommendation.
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
June 3, 2014 at 2:34 am
Can you please run the following and post the full and complete, unedited output?
DBCC CheckDB(<database name here>) with no_infomsgs, all_errormsgs
I can't tell if you've left out a line or not.
Edit:...
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
June 3, 2014 at 2:13 am
Last time you asked that question (http://www.sqlservercentral.com/Forums/Topic1574340-2799-1.aspx), I referred you to three articles on indexes. Did you read them?
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
June 3, 2014 at 2:04 am
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??
Replacing EXISTS with (something) because Some Person said it's slow.
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
June 2, 2014 at 2:23 pm
BWFC (6/2/2014)
It seemed logically different from looking up something each time needed it with the subqueries.
But that's not how subqueries behave....
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
June 2, 2014 at 6:15 am
BWFC (6/2/2014)
It was just that conventional wisdom is that set based is best so I thought that there would be an improvement.
What does set-based have to do with changing...
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
June 2, 2014 at 6:00 am
Igor Micev (6/2/2014)
GilaMonster (6/2/2014)
Igor Micev (6/2/2014)
Can you run this set (do it on test)
dbcc dropcleanbuffersdbcc freeproccache
dbcc freesessioncache
Why?
Sometimes when you run the same query again it uses less physical reads, since...
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
June 2, 2014 at 5:39 am
In general, lower numbers are better, however those stats values are so low there's no point in tweaking.
As for subqueries vs joins, depends on where the subqueries are, how...
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
June 2, 2014 at 5:37 am
Igor Micev (6/2/2014)
Can you run this set (do it on test)
dbcc dropcleanbuffersdbcc freeproccache
dbcc freesessioncache
Why?
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
June 2, 2014 at 5:33 am
First test and see if there's a gram of truth in that statement and whether you even need to be looking for an alternative.
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
June 2, 2014 at 1:01 am
Viewing 15 posts - 8,836 through 8,850 (of 49,552 total)