Explore all the products and find the right solution for your business
Proactively manage server performance on-prem or in the cloud with timely alerts and analytics
Fast configuration of regulatory and audit compliance settings with proactive monitoring, alerts, and reporting
Automated database security, monitoring and management for MS SQL, Azure and Amazon RDS for SQL Server
Backup and instant recovery for SQL Server, Azure Blob Storage and Amazon S3
Discover, track and manage database inventory across the entire environment
24 Essential tools to simplify daily server administration
Get the right solution to keep your database running at peak performance.
All of the support you need at your convenience.
The good news? T-SQL is one of the easiest coding languages to learn. The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master. In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Non-Parameterized SQL and Parameter Sniffing. Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let's get things moving!
About Mindy Curnutt: Mindy is a SQL Server MVP and has been actively involved in the SQL Server Community since 2000. She has presented at her local North Texas SQL Server User Group (2002, 2003, 2015), SQLPASS Summits (2005, 2006, 2012, 2013), and numerous SQLSaturday events (2013-2015). She was a SME for both the SQL 2012 and 2014 Certification Exams and is an MSPress Books co-author. Mindy works for Trimble Navigation/TMW Systems as a distinguished engineer and the director of database architecture.
Topics: Database Performance, Database Monitoring, Database Diagnostics, SQL Query Performance Products: SQL Diagnostic Manager for SQL Server