![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQLServer2005
文章平均质量分 84
易班雄
简单而不简约
展开
-
SQL Server2005 表的使用情况监控
-------------------------查询表的使用情况,读写情况、锁的情况、页面情况SET NOCOUNT ONCREATE TABLE #tab(database_id INT ,object_id int ,index_id int ,leaf_insert_count int ,leaf_delete_count int ,原创 2010-01-22 09:41:00 · 497 阅读 · 0 评论 -
索引碎片监控
----------ana_index.sqlSET NOCOUNT ON--SET QUOTED_IDENTIFIER OFFDECLARE @sqlNVARCHAR(MAX)DECLARE @db_name VARCHAR(30)DECLARE@object_name VARCHAR(30)DECLARE @db_id INTDECLARE @object_id INTDECLARE原创 2010-01-22 09:17:00 · 316 阅读 · 0 评论 -
SQL Server2005 表分区
---1、添加数据文件use mastergo--Fam200901alter database RedfDBadd filegroup FGAM200901goalter database RedfDBadd file(name=FGAM200901,filename=D:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/DATA/Fa原创 2010-01-22 14:09:00 · 320 阅读 · 0 评论