full screen
booksbay Icon
Logo1
Login & Sign up
AddBanner
Home icon Home
Account Icon Account
Wishlist Icon Wishlist
Cart Icon Cart
humburger icon Categories
Home > Computer & Internet > Databases > Object-oriented databases > Pro SQL Server Internals
Pro SQL Server Internals

Pro SQL Server Internals


     0     
5
4
3
2
1
Write Reviews


International Edition


About the Book

Part 1: Tables and Indexes

1. Data Storage Internals

2. Tables and Indexes

3. Statistics

4. Special Indexing and Storage Features

5. SQL Server 2016 Enhancements

6. Index Fragmentation

7. Designing and Tuning the Indexes

Part 2: Other Things That Matter

8. Constraints

9. Triggers

10. Views

11. Functions

12. XML and JSON

13. Temporary Tables and TempDB

14. CLR

15. CLR Types

16. Data Partitioning

Part 3: Locking, Blocking, and Concurrency

17. Lock Types and Transaction Isolation Levels

18. Troubleshooting Blocking Issues

19. Deadlocks

20. Lock Escalations

21. Optimistic Isolation Levels

22. Application Locks

23. Schema Locks

24. Designing Transaction Strategies

Part 4: Query Life Cycle

25. Query Optimization and Execution

26. Plan Caching

Part 5: Practical Troubleshooting

27. System Troubleshooting

28. Extended events

29. Query Store

Part 6: Inside the Transaction Log

30. Transaction Log Internals

31. Backup and Restore

32. High Availability Technologies

Part 7: In-Memory OLTP Engine

33. Column-Based Storage and Batch Mode Execution

34. Columnstore Indexes

Part 8: In-Memory OLTP Engine

35. In-Memory OLTP Internals

36. Transaction Processing in In-Memory OLTP

37. In-Memory OLTP Programmability


About the Author: Dmitri Korotkevitch is Microsoft SQL Server MVP and Microsoft Certified Master. He brings years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. He specializes in design, development, and performance tuning of OLTP Systems working under heavy load. Dmitri regularly speaks at various Microsoft and SQL PASS events, and he provides SQL Server training to clients around the world.

Best Sellers

See All
My First Library: Boxset of 10 Board Books for Kids
Quick View

My First Library: Boxset of 10 Board Books for Kids Wonder House Books Editorial

4.1 (8)

AED105

Psychology of Money
Quick View

Psychology of Money Morgan Housel

No Review Yet

AED147

Architectural Digest at 100
Quick View

Architectural Digest at 100 Architectural Digest

5 (7)

AED758

Lego Gear Bots
Quick View

Lego Gear Bots

3.5 (8)

AED198

Atomic Habits
Quick View

Atomic Habits James Clear

No Review Yet

AED189

Surrounded by Idiots
Quick View

Surrounded by Idiots Thomas Erikson

4 (8)

AED84

Ikigai
Quick View

Ikigai Francesc Miralles

No Review Yet

AED159

How to Talk to Anyone
Quick View

How to Talk to Anyone Leil Lowndes

4.7 (9)

AED119

The Intelligent Investor REV Ed.
Quick View

The Intelligent Investor REV Ed. Benjamin Graham

4.5 (6)

AED196

Can't Hurt Me
Quick View

Can't Hurt Me David Goggins

4.4 (8)

AED264

Guide to the Project Management Body of Knowledge and the Standard for Project Management
Quick View

Guide to the Project Management Body of Knowledge and the Standard for Project Management Project Management Institute

4.8 (8)

AED651

Numicon: Box of 80 Numicon Shapes
Quick View

Numicon: Box of 80 Numicon Shapes

No Review Yet

AED555

Product Details
  • ISBN-13: 9781484219638
  • Publisher: Apress
  • Publisher Imprint: Apress
  • Edition: 0002-
  • Language: English
  • Returnable: Y
  • Spine Width: 42 mm
  • Width: 178 mm
  • ISBN-10: 1484219635
  • Publisher Date: 01 Dec 2016
  • Binding: Paperback
  • Height: 254 mm
  • No of Pages: 804
  • Series Title: English
  • Weight: 1477 gr

Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Pro SQL Server Internals
Apress -
Pro SQL Server Internals
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Pro SQL Server Internals

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Booksbay (the "CRR Service").


    By submitting any content to Booksbay, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Booksbay (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Booksbay a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Booksbay may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy. 


    All content that you submit may be used at Booksbay's sole discretion. Booksbay reserves the right to change, condense, withhold publication, remove or delete any content on Booksbay's website that Booksbay deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Booksbay does not guarantee that you will have any recourse through Booksbay to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Booksbay reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Booksbay, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Booksbay, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    See All
    Diary of a Wimpy Kid: Book 18
    Quick View

    Diary of a Wimpy Kid: Book 18 Jeff Kinney

    No Review Yet

    AED84

    Dog Man 12: The Scarlet Shedder
    Quick View

    Dog Man 12: The Scarlet Shedder Dav Pilkey

    No Review Yet

    AED156

    Untitled Rebecca Yarros 2
    Quick View

    Untitled Rebecca Yarros 2 Rebecca Yarros

    No Review Yet

    AED210

    Spreading Joy
    Quick View

    Spreading Joy Joy Alukkas

    No Review Yet

    AED100

    Untitled Nonfiction PP
    Quick View

    Untitled Nonfiction PP Walter Isaacson

    No Review Yet

    AED154

    First Aid for the USMLE Step 1 2024
    Quick View

    First Aid for the USMLE Step 1 2024 Vikas Bhushan

    No Review Yet

    AED495

    So Good
    Quick View

    So Good Emily English

    No Review Yet

    AED275

    Anxious Generation
    Quick View

    Anxious Generation Jonathan Haidt

    No Review Yet

    AED238

    Cat Kid Comic Club: Influencers: A Graphic Novel (Cat Kid Comic Club #5): From the Creator of Dog Man
    Quick View

    Cat Kid Comic Club: Influencers: A Graphic Novel (Cat Kid Comic Club #5): From the Creator of Dog Man Dav Pilkey

    No Review Yet

    AED152

    Poor Charlie's Almanack
    Quick View

    Poor Charlie's Almanack Charles T. Munger

    No Review Yet

    AED245

    Untitled Rebecca Yarros #2
    Quick View

    Untitled Rebecca Yarros #2 Rebecca Yarros

    No Review Yet

    AED222

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!