Abbiamo lavorato con Microsoft su un ticket che abbiamo aperto a causa di una delle nostre query molto più lenta su MS Sql server 2k8 enterprise vs sql 2k5 standard. Gli ingegneri con cui lavoriamo hanno strumenti e conoscenze incredibili sugli interni di SQL Server.
C'è un corso che potrei prendere per ottenere questa conoscenza?
SQL Skills offre corsi di formazione Master su interni SQL e così via: link
These classes are designed to be standalone training classes for anyone wanting to know more about SQL Server. While these are slated as “deep events” we want to stress that you can be really successful if you understand a lot of the basic requirements of data/databases but just not with SQL Server. The first week – which starts with internals and then moves into database design and then ends with indexing for performance – is the best base that anyone can have that works with SQL Server. This answers a lot of the “how” and “why” questions in terms of setup, design and tuning.
Paul lavorava per Microsoft (nel team SQL) e Kimberly ha insegnato e parlato in SQL per sempre. Sono entrambi persone incredibilmente divertenti e intelligenti - mentre non ho preso corsi da loro sono stato a sessioni che hanno dato e hanno avuto conversazioni tecniche con loro molte volte.
Kalen Delanay's è il corso più avanzato di cui sono a conoscenza.
SQL Server 2005/2008 Internals and Query Tuning
This is an advanced 5-day course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2008 and cover features specific to that version, but most of the information is relevant to SQL Server 2005 as well. This 5-day intensive seminar was developed by one of the world's leading experts in SQL Server internals. Topics to be covered include the following:
- SQL Server Architecture and Metadata
- Physical Storage Structures
- Index Design and Tuning
- Query Processing and Query Plans
- Optimization and Recompilation
- Concurrency Control: Locking, Blocking and Row Level Versioning
- Query Tips and Techniques
- Troubleshooting Tools
The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques...
Leggi altre domande sui tag sql-server