<br />declare @src nvarchar(200)<br />set @src= 'TableName'<br />   select d.[name],d.system_type_id,d.max_length,d.[precision],d.[scale]<br />       ,d.[is_identity],d.[is_nullable],d.[is_rowguidcol],d.[column_id]<br />       ,isnull(ipkc.[key_ordinal],0)

<br /> <br />-- Select TOP N query templates based on average CPU time<br />SELECT TOP 5<br />query_fingerprint,<br />SUM(total_worker_time)/SUM(execution_count)<br />AS [Avg CPU Time],<br />MIN(statement_text)<br />FROM<br />(SELECT qs.*,<br />substring(s

<br /> <br />create table sequence (<br />    id int not null primary key<br />);<br /> <br />insert into sequence(id) values<br />    (1), (2), (3), (4), (6), (7), (8), (9),<br />    (10), (15), (16), (17), (18), (19), (20);<br />    select * from sequenc

<br /> <br /> update statistics [[zping.com]]](_WA_Sys_creater_4C02DB92)  with fullscan<br /> <br />源文档 <http://www.cnblogs.com/zping/archive/2008/07/20/1247210.html>

Sp_who2Kill ID

<br /> <br />declare        @MinUPSPartNum smallint = 1<br />declare        @MaxUPSPartNum smallint = 6<br />declare @RunId                int = NULL<br />declare @Options nvarchar(100) = null<br />begin<br /> <br />set nocount on<br /> <br />declare @tran

<br /> <br />SET NOCOUNT ON<br />DECLARE @LogicalFileName sysname,<br />@MaxMinutes INT,<br />@NewSize INT<br /> <br /> <br />USE EPNY_Staging  -- 要操作的数据库名<br />SELECT @LogicalFileName = 'EPNY_Staging_log', -- 日志文件名<br />@MaxMinutes = 10, -- Limit on time

<br />select count(*) from table 已经out拉!<br /> <br />select rows from sysindexes where id = object_id('SearchLastUseDay_FACT') and indid in (0,1)