×

SQL Saturday 953 Rochester NY

Date/Time: Saturday, February 29, 2020 1:20 PM to 2:20 PM
Location: Rochester Institute of Technology, 1 Lomb Memorial Drive, Rochester, New York, 14623, United States

View Event:  New features in Management Studio — Performance Troubleshooting made easier!

SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan.

Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for the table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?

In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

My Stackexchange Profile

profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Announcing the 1st Data Platform Discovery Day - a 100-level, 1-day virtual conference intended for those looking to ... change their career path or data platform beginners looking to expand their skill sets. CfS live at https://dataplatformdiscoveryday.com/ til 4/13. US day 4/29, Europe day 4/30.

We are pleased to announce #SQLSaturday #1000, in Portland, Oregon on October 24, 2020!

... http://www.sqlsaturday.com/1000/EventHome.aspx

Since #SQLSat started in 2007, there have been some amazing milestones achieved along the way. Check out some of the highlights by clicking the image below! #sqlpass

I know many of us are biased between blue and red.
U want to know the fact. Call someone you trust and works in NY city ... hospital.
I did with 2 doc, 1 admin and 1 finance person.
You are bound to get angry and not trust a bit of these TV shows at 5pm.

#CoronaPandemic

No days off. Thanks to some serious teamwork, Massachusetts is set to receive over 1 million N95 masks for our ... front-line workers. Huge thanks to the Krafts and several dedicated partners for making this happen.

Load More...