随笔分类 -  SQLServer

摘要：大致的重建范围是 逻辑密度碎片>30以及页码总数>8以上的数据库索引碎片 直接上代码（附带生成执行完之后生成日志记录表） SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GO Create PROCEDURE [dbo].[p_index_rebuild_tes 阅读全文

摘要：如果我们的语句为：?12345678910111213IF NOT EXISTS(SELECT 1 FROM sys.views WHERE name='Report_IndividualTicket') BEGINcreate view Report_IndividualTicket asSELE... 阅读全文

摘要：public string GetObjectTypeName(object oType){switch (oType+""){case "U":return "用户表";case "V":return "视图";case "P":return "存储过程";case "TF":return "表函... 阅读全文

摘要：create table tmp( name varchar(50), rowscount int, reserved varchar(50), data varchar(50), index_size varchar(50), unused varchar(... 阅读全文

摘要：SQL Server1、查询所有表 select [id], [name] from [sysobjects] where [type] = 'u' order by [name]2、查询所有数据库 select [name] from [sysdatabases] order by [name]3... 阅读全文