Sql Server

We're back from our trips, and on show 19, we juggle around a few topics. We talk about super indexes, trivial plans and whether they're the best choice, Dynamic SQL and automatic code, Replication, a hidden and yet important property of Failover Clusters, and more.. Also, Matan declares that User Defined Functions need to be wiped out. Listen to hear why! Links mentioned in the show: Super Index Kendal Van Dyke - Troubleshooting Transactional Replication Eitan Blumin - Let SQL Server Write Code for You Avi Niv - Generating Email Reports Using XML Michael J Swart - Trivia about Trivial Plans Paul White - Forcing a Parallel Query Execution Plan Guy Glantser - How to Use Parameters Like a Pro and Boost Performance Modifying Clustered Service Settings Global Hebrew Virtual Chapter August Meeting Israeli SQL Server User Group Meeting #145