Viewing 15 posts - 5,161 through 5,175 (of 49,571 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...
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.
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.
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????
July 28, 2015 at 6:01 am
A misspelling. Should have been klap (Afrikaans)
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...
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...
July 28, 2015 at 5:32 am
I'm not all that familiar with SSDs, but that doesn't sound at all healthy...
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...
July 28, 2015 at 3:06 am
sqlguy-736318 (7/27/2015)
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...
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...
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.
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...
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?
July 28, 2015 at 2:52 am
Viewing 15 posts - 5,161 through 5,175 (of 49,571 total)