SQL Server Mythconceptions and Mythteries
Duration: 60 minutes
Track: Database Administration
There are a lot of misconceptions and mysteries in SQL Server due in large part to there be no single right answer for just about any question you have. How many times have you heard, ‘It Depends’ as the answer to a complex SQL Server question? So often that it has almost become a joke. When it’s your SQL Server, it’s no joke.
Why won't that query go parallel? Why won't the optimizer use that index? Why did rebuilding that index improve performance 10 times over?
Sometimes misconceptions become accepted as fact, and they spread. Occasionally, these mistold tales come from very reliable sources. It can be extremely difficult to tell what is fact and what is fable.
In this session, we will explore some of these misconceptions and mysteries turned myths and bust out the truth. We will prove the right answer and free you from these myths that have taken on a life of their own.