Viewing 15 posts - 5,161 through 5,175 (of 49,552 total)
Fragmentation affects large range scans from disk. Emphasis 'large' and 'disk'.
It has no effect on data which is already in memory. What fragmentation does is reduce the efficiency of the...
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
July 29, 2015 at 3:47 am
Probably the checkpoint process.
The ALTER might wait for the system process to finish, but it should work.
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
July 28, 2015 at 6:16 am
Just bear in mind that TRUNCATEONLY is ignored when shrinking a log file (log records can never be moved within the log), so that may shrink the log to 0.
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
July 28, 2015 at 6:09 am
Lowell (7/28/2015)
DBCC SHRINKFILE (N'UserAnalysis_Data' , 0, TRUNCATEONLY)DBCC SHRINKFILE (N'UserAnalysis_log' , 0, TRUNCATEONLY)
Wha????
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
July 28, 2015 at 6:01 am
A misspelling. Should have been klap (Afrikaans)
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
July 28, 2015 at 6:00 am
Drop database will fail if there are connections. Plus if you drop the DB, the restore has to go and recreate the files, which may take some time if the...
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
July 28, 2015 at 5:43 am
The missing index DMV is a place to start looking at indexes, not the final answer. You need to take the recommendations, evaluate them, test each one and see what...
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
July 28, 2015 at 5:32 am
I'm not all that familiar with SSDs, but that doesn't sound at all healthy...
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
July 28, 2015 at 3:12 am
WayneS (7/27/2015)
If I were to say that one of Gail's answers wasn't, well, entirely accurate... do you think this would get her out to Summit this year to whoop on...
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
July 28, 2015 at 3:06 am
sqlguy-736318 (7/27/2015)
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
July 28, 2015 at 3:03 am
WayneS (7/27/2015)
jasona.work (7/27/2015)
And I just realized that until we get a TLog backup, it's in "pseudo simple" mode, ain't it...
Pseudo-simple is a new database in the full recovery model 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
July 28, 2015 at 3:00 am
Not really surprising. IN is usually a tad faster than a join (a very, very small amount). Changing the IN to a join may have also changed the logic 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
July 28, 2015 at 2:58 am
What's changed?
Compare query plans from before and now, see what's different. Compare your wait stats baseline to what you see now, see where the waits have increased.
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
July 28, 2015 at 2:57 am
abhishek_300 (7/27/2015)
How to get the last record value in sql server without using MAX/TOP clause?
Answer: Why are you enforcing silly and unrealistic restrictions on my code? Should I be expecting...
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
July 28, 2015 at 2:55 am
Eirikur Eiriksson (7/27/2015)
Although "theoretically" this is right, one cannot endorse the use of @@ROWCOUNT in that way, too many gaps and exceptions.😎
What gaps and exceptions, other than a trigger?
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
July 28, 2015 at 2:52 am
Viewing 15 posts - 5,161 through 5,175 (of 49,552 total)