SQL Server execution plans provide a roadmap to query performance. Once you understand how to read the execution plan, you can easily identify bottlenecks and detours. This high level session introduces you to the concepts of reading SQL Server execution plans including how to get an actual execution plan, how …
Developers frequently make a big mistake: they tune out on discussions of storage performance and IO. Don’t fall into this trap! Understanding how storage impacts SQL Server performance helps you tune the right parts of your code and focus on what really matters.
When you create tables and insert data, what’s SQL Server doing behind the scenes? How do your rows become part of the files on disk?
No news isn’t good news: sometimes it’s terrifying. Just because your SQL Server slaves away silently doesn’t mean all is well. If you’re frustrated with your server’s performance and you’re not sure why things aren’t going faster, maybe there’s a hidden hazard holding you back.
There are many disadvantages to the usage of the SELECT * in a SQL Server query. This video explains how users can avoid using SELECT * but instead list the column names.
You’re faced with a bewildering array of options for AlwaysOn Availability Groups. Should all the databases be in one availability group? What service accounts and IP addresses will you need? How will failover work? I’ll get you started with a simple checklist of things to consider before deploying your first …
