lcw321321的专栏

SQL_Serverdatabasecompression

Delve inside the core SQL Server engine and put that knowledge to work with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you will gain the deep knowledge you need to exploit key architectural change and capture the products full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking—from triggers to the Extended Events Engine Why the right indexes can drastically reduce your query execution time How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan—or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

数据库管理:实时监视事务分析性能和数据库活动解决用户和应用程序错误审核用户数据 架构和权限更改数据恢复和数据库恢复还原行到先前状态