2014年05月_OnlyQi

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

转载 Eliminating bookmark (key/rid) lookups

When we were looking at the index scan and table scan section we were able to eliminate the scan which was replaced with an index seek, but this also introduced a Key Lookup which is something else

2014-05-23 14:30:56 946

转载 Evaluating Memory and Cache Usage

http://technet.microsoft.com/en-us/library/cc958290.aspx这篇官网的文章不错。

2014-05-21 14:53:42 830

原创 Move data files to other disk

Move CDW data file to R:\ drive on BODCPRODVSQL100 Right Click CDW database Click Detach Copy CDW_RESTORE.mdf from M:\DBFiles to R:\DBFiles Attach CDW database By locating the R:\DBFiles\C

2014-05-21 12:07:04 1082

转载 Online restore

http://msdn.microsoft.com/en-us/library/ms188671.aspx指的是

2014-05-16 13:18:22 764

转载 SPID和KPID的区别

http://support.microsoft.com/kb/117559

2014-05-15 13:02:13 3107

转载两个查询index size的sql

因为sp_spaceused 返回的是一个表中所有index size的SELECT i.name AS IndexName, SUM(s.used_page_count) * 8 AS IndexSizeKBFROM sys.dm_db_partition_stats AS s JOIN sys.indexes

2014-05-06 16:57:43 1620

原创 sp_spaceused

这个大家用的很多了，我在这里只是解释一下fan

2014-05-06 16:54:24 2802

原创估算SQL Server表和索引大小的方法

http://technet.microsoft.com/en-us/library/ms175991.aspx

2014-05-06 16:28:31 1166

转载链接数据库时，几个可以设置timeout的地方

1.Configuring (Server Configuration Options - remote query timeout )( but Not Recommended)The remote query timeout option specifies how long, in seconds, a remote operation can take before SQL

2014-05-06 14:44:40 5658

原创自动备份SSAS数据库

Use XMLA to backup SSAS databases. Below is an simple example: http://schemas.microsoft.com/analysisservices/2003/engine"> CDW_Analytics \\Prodsqlbackups\backups\BODCPRODVSAS13

2014-05-04 10:17:44 1484

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人