摘要:
用普通的 while循环插入数据执行5分钟(未执行完,并且已经报内存溢出的错误。)declare @feesCount bigint;declare @feesid bigintset @feesCount=1set @feesid=100201000000002422while(@feesCount<=100000)beginINSERT INTO [dbo].[TF_Fees] ([FeesID] ,[CommID] ,[CustID] ,[RoomID] ,[CostID] ... 阅读全文
摘要:
查询索引碎片--QUERY INDEX FRAGMENTATION INFO AGAIN SELECT DB_NAME(V1.database_id) as 'Database Name', OBJECT_NAME(V1.object_id) as 'Table Name', v2.name as 'Index Name',V1.index_id as "Index ID", V1.avg_fragmentation_in_percent as 'Average Percent Fragmentation' F 阅读全文