Well, the books have been very well received and in fact we ran out of huge stock 2 times in India so far and once in USA during SQLPASS. I have received so many questions on this subject that I feel I can write one more book of the same size. I have been asked if I can create videos which can go along with this book. Personally I am working with SQL Server 2012 CTP3 and there are so many new wait types, I feel the subject of wait stats is going to be very very crucial in next version of SQL Server. If you have not started learning about this subject, I suggest you at least start exploring this right now. Learn how to begin on this subject atleast as when the next version comes in, you know how to read DMVs.
I will be presenting on the same subject of performance tuning by wait stats in webcast embarcadero SQL Server Community Webinar. Here are few topics which we will be covering during the webinar.
- Beginning with SQL Wait Stats
- Understanding various aspect of SQL Wait Stats
- Understanding Query Life Cycle
- Identifying three TOP wait Stats
- Resolution of the common 3 wait types and queues
Details of the webcast:
How to Identify Resource Bottlenecks – Wait Types and Queues
Date and Time: Wednesday, November 2, 11:00 AM PDT
I thank embarcadero for organizing opportunity for me to share my experience on subject of wait stats and connecting me with community to further take this subject to next level.
One more interesting thing, I will ask one question at the end of the webinar and I will be giving away 5 copy of my SQL Wait Stats print book to first five correct answers.
Reference: Pinal Dave (https://blog.sqlauthority.com)
Pinal, can you explain the situation with several domain groups and user who belongs to them.
What default kanguage user will get?
DOMAINUser is a member of DOMAINGroup1 and DOMAINGroup2.
DOMAINGroup1 and DOMAINGroup2 are logins on the SQL Server. DOMAIN
User is not.
DOMAINGroup1’s default language is English
DOMAINGroup2’s default language is British English
My question is, when DOMAINUser logs on, is their default language