SQL Server – Car crash queries.
What happens when a query goes wrong. We’ve all had the occasion where a query was running fine and then suddenly it doesn’t. You then get the query from profiler and run it in management studio and it runs fine, but your app is still running slowly. What is happening? In this session we will be looking what causes the query to fail and why you get odd results when you run in management studio. Importantly you will find out what to do avoid this happening on your system.
Simon Sabin is director of his own company that provides training and consultancy around SQL Server development and business intelligence.
He has a particular expertise in the areas of search, distributed architectures, business intelligence and application development. He has worked with SQL Server since 1998 and has always focused on high performance reliable systems.