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.
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.
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.
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.
