Paul Randal (@PaulRandal) of SQLskills.com discusses the myth that DROP and TRUNCATE operations are not logged, and shows that this is simply not true.
Continue Reading »May 312013
May 282013
Joe Sack (@josephsack) of SQLskills.com outlines his approach to troubleshooting CPU performance issues in SQL Server.
Continue Reading »May 232013
Wanted to give a heads-up about some of the sessions we're presenting at PASS Summit, some great pre-conference seminars, and a contest you'll really want to consider entering in June and July.
Continue Reading »May 212013
Jonathan Kehayias (@SQLPoolBoy) of SQLskills.com takes a look at snapshot performance, with some surprising observations about what happens if you have more than one concurrent snapshot.
Continue Reading »May 172013
Aaron Bertrand (@AaronBertrand) talks about a subtle way that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.
Continue Reading »