Sql Server

Show 8 – Works Great with NOLOCK

Informações:

Synopsis

After the conference season, we go back to the regular format of events, blogs, forum discussions and other goodies. Here's some of the topics we cover: Is index maintenance still necessary in 2013? How to really monitor page splits? "Smelly" code What CXPacket really means and how can we leverage it Past and future events We also have a very interesting "top 10" list, and much more.. Links mentioned in the show: Next Israeli SQL Server User Group meeting Previous Israeli SQL Server User Group meeting An index build takes a long time when a SQL Server database backup is running Guy Glantser - Forty Things You Didn’t Know About SQL Server The Data Loading Performance Guide Ola Hallengren's Index and Statistics Maintenance Script #FiveWordTechHorrors Eitan Blumin - Service Broker Sample: Asynchronous Triggers Matan Yungman - Using CXPacket Waits to Detect Query Bottlenecks Michael J. Swart - Overly Complex Views, Procedures And Functions Matan Yungman - Finding The Needle In The Haystack