SQL Server Basic Performance Tips and Gotchas for beginners
Yes this is a performance tuning session for SQL beginners. So forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Architecture Joes 2 Pros Vol3.
Rick Morelan is the author of the “Joes 2 Pros” book SQL series designed to prepare the reader to pass the Microsoft exam 70-433 for SQL Developers. He also co-wrote a book T-SQL 2008 Joes 2 Pros which was one of the featured books at SQL PASS 2009. Rick has previously worked at Microsoft for more than 10 years and has obtained SQL Certifications in versions 7.0, 2000, 2005 and 2008. Rick has presented at SQL Saturdays in the USA, Canada, and India. Currently Ricks Joes2Pros YouTube channel has 1,800 subscribers, gets about 1000 views per day, with over 600,000 total video views since 2010. http://www.youtube.com/joes2pros. In 1994, you could find Rick Morelan braving the frigid waters of the Bering Sea as an Alaskan commercial fisherman. His computer skills were non-existent at the time, so you might figure such beginnings seemed unlikely to lead him down the path to SQL expertise at Microsoft. However, every computer expert in the world today woke up at some point in their life knowing nothing about computers. It was a long and difficulty Journey for Rick as he transitioned from a life on the sea to an IT Professional and he is committed to helping others make similar transitions.
- Not Interested