Search


	Podcast:		voiceofthedba's podcast
	Episode:		SQL Server Tuning Skills
	Category:		Technology
	Duration:		00:04:42
	Publish Date:		2018-06-05 20:00:00
	Description:		Performance tuning a SQL Server instance, database, or even query is a skill that most of us could improve. In fact, I see that the query performance presentations are often the most popular learning items at any event. I've seen quite a few people asking for more tuning talks in different areas, which is a good thing. I think most SQL Saturdays could schedule a different tuning session every hour, or even repeat the same one a few times, and the room would be mostly full each time. Learning to look at the various possible problems in a SQL Server is both a science and an art. There are good methods, such as waits and queues, for examining where an issue occurs. There are basic techniques for looking at execution plans and then making changes to indexes or T-SQL. There are different options for queries, SET values, and more that will affect your query or even all your queries. Read the rest of SQL Server Tuning Skills
	Total Play:		0