找回密码
 To register

QQ登录

只需一步,快速开始

扫一扫,访问微社区

Titlebook: Pro SQL Server Internals; Dmitri Korotkevitch Book 20141st edition Dmitri Korotkevitch 2014

[复制链接]
查看: 33089|回复: 35
发表于 2025-3-21 17:10:22 | 显示全部楼层 |阅读模式
书目名称Pro SQL Server Internals
编辑Dmitri Korotkevitch
视频video
概述Pro SQL Server Internals explains how SQL Server works focusing on how internal implementation affects your database operations.
图书封面Titlebook: Pro SQL Server Internals;  Dmitri Korotkevitch Book 20141st edition Dmitri Korotkevitch 2014
描述.Pro SQL Server Internals. explains how different SQL Server components work "under the hood" and how they communicate with each other. This is .the .practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems..Pro SQL Server Internals. covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With .Pro SQL Server Internals., you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use..Pro SQL Server Internals. does the following:.Explains how to design efficient database schema, indexing, and transaction strategies..Shows how various database objects and technologies are implemented internally and when they should or should not be used..Demonstrates how SQL Server executes queries and works with data and transaction logs..
出版日期Book 20141st edition
版次1
doihttps://doi.org/10.1007/978-1-4302-5963-3
isbn_ebook978-1-4302-5963-3
copyrightDmitri Korotkevitch 2014
The information of publication is updating

书目名称Pro SQL Server Internals影响因子(影响力)




书目名称Pro SQL Server Internals影响因子(影响力)学科排名




书目名称Pro SQL Server Internals网络公开度




书目名称Pro SQL Server Internals网络公开度学科排名




书目名称Pro SQL Server Internals被引频次




书目名称Pro SQL Server Internals被引频次学科排名




书目名称Pro SQL Server Internals年度引用




书目名称Pro SQL Server Internals年度引用学科排名




书目名称Pro SQL Server Internals读者反馈




书目名称Pro SQL Server Internals读者反馈学科排名




单选投票, 共有 0 人参与投票
 

0票 0%

Perfect with Aesthetics

 

0票 0%

Better Implies Difficulty

 

0票 0%

Good and Satisfactory

 

0票 0%

Adverse Performance

 

0票 0%

Disdainful Garbage

您所在的用户组没有投票权限
发表于 2025-3-21 23:41:43 | 显示全部楼层
Special Indexing and Storage FeaturesThis chapter discusses several storage- and indexing-related features available in SQL Server. It covers indexes with included columns, filtered indexes and statistics, data compression, and sparse columns.
发表于 2025-3-22 01:50:03 | 显示全部楼层
发表于 2025-3-22 06:51:32 | 显示全部楼层
Designing and Tuning the IndexesIt is impossible to define an indexing strategy that will work everywhere. Every system is unique and requires its own indexing approach. However, there are several design considerations and guidelines that can be applied in every system.
发表于 2025-3-22 08:48:06 | 显示全部楼层
发表于 2025-3-22 13:46:20 | 显示全部楼层
User-Defined FunctionsOne of the first things that developers learn about in their career is the benefits of code reuse. Encapsulating and reusing code into separate libraries speeds up the development and testing process and reduces the number of bugs in the system.
发表于 2025-3-22 20:28:28 | 显示全部楼层
XMLWe are living in a world full of information. Businesses are constantly collecting large amounts of data from multiple sources, processing it and exchanging it with other systems. XML has become the de-facto standard for information exchange—it works across different platforms and is supported in every development platform that exists today.
发表于 2025-3-22 23:30:07 | 显示全部楼层
Temporary TablesTemporary tables are an essential part of SQL Server. SQL Server will sometimes create them during query execution to store working tables and intermediate result sets. At other times, they are created by developers.
发表于 2025-3-23 04:49:28 | 显示全部楼层
CLR TypesCLR types is another area of Common Language Runtime integration in SQL Server. User-defined CLR types allow us to expand the standard type library by developing .Net classes and registering them as user-defined types in the database. Standard CLR types, such as ., ., and ., provide built-in support for spatial and hierarchical data.
发表于 2025-3-23 09:10:48 | 显示全部楼层
 关于派博传思  派博传思旗下网站  友情链接
派博传思介绍 公司地理位置 论文服务流程 影响因子官网 SITEMAP 大讲堂 北京大学 Oxford Uni. Harvard Uni.
发展历史沿革 期刊点评 投稿经验总结 SCIENCEGARD IMPACTFACTOR 派博系数 清华大学 Yale Uni. Stanford Uni.
|Archiver|手机版|小黑屋| 派博传思国际 ( 京公网安备110108008328) GMT+8, 2025-5-19 05:44
Copyright © 2001-2015 派博传思   京公网安备110108008328 版权所有 All rights reserved
快速回复 返回顶部 返回列表