摘要：
Last week I talked about Clustered Indexes in SQL Server. When you define a Clustered Index on your table, you are physically sorting your table data 阅读全文
posted @ 2017-06-22 18:21
FH1004322
阅读(152)
评论(0)
推荐(0)
摘要：
In the last weblog post I have talked about the differences in unique and non-unique non-clustered indexes on a unique clustered index. In this weblog 阅读全文
posted @ 2017-06-22 14:07
FH1004322
阅读(245)
评论(0)
推荐(0)
摘要：
参数说明 database_id--要查看索引所在数据库，当前数据库ID我们可以用db_id()函数来取到object_id--要查索引所在表的id,比如我们要查看表T1，可以用object_id('T1')来取到该表的IDindex_id--要查看索引的索引号,该索引也同样可以用object_id 阅读全文
posted @ 2017-06-22 12:03
FH1004322
阅读(695)
评论(0)
推荐(0)
摘要：
Last week I taught an internal SQL Server Performance Tuning course to a customer in Switzerland. As usual we had a lot of fun, and at some point an a 阅读全文
posted @ 2017-06-22 11:28
FH1004322
阅读(146)
评论(0)
推荐(0)
摘要：
In the last months I had done a lot of performance tuning workshops(n. 车间; 工作坊;), and there is almost the same question: How SQL Server stores indexes 阅读全文
posted @ 2017-06-22 11:11
FH1004322
阅读(121)
评论(0)
推荐(0)
摘要：
Years ago I wrote about how SQL Server stores VARCHAR columns in the Navigation Structure of an index. As you might know, the key columns of an index 阅读全文
posted @ 2017-06-22 10:23
FH1004322
阅读(153)
评论(0)
推荐(0)
浙公网安备 33010602011771号