Tags » T-SQL
The “include actual execution plan” feature in SQL Server Management Studio is an invaluable tool for performance tuning. It returns the actual execution plan used for each statement, including actual row counts, tempdb spills and a lot of other information you need to do performance tuning. 242 more words
This blog post is a follow up to a question I received when I gave my Advanced TSQL Webinar for Pragmatic Works. If you haven’t seen that yet and would like to see it you can view the webinar… 341 more words
This post is Part 1 of my series of upcomingposts on Index Maintenance for a DBA. So here goes.
There are all sorts of indexing tuning & optimizations that can be done on a SQL database. 676 more words