hxp42的专栏

declare @objectid int,@indexid int,@partitioncount bigint,@schemaname sysname,@objectname sysname,@indexname sysname,@partitionnum bigint,@partitions bigint,@frag float,@command varchar(1000),@databas

CREATE TABLE [dbo].[ETLSourceDataProcessRecord]( [RecordID] [int] IDENTITY(1,1) NOT NULL, [SourceSystemKey] [int] NULL, [DataRangeStart] [nvarchar](40) NULL, [DataRangeEnd] [nvarchar](40) NULL, [

CREATE TABLE [dbo].[ETLSource]( [SystemKey] [int] IDENTITY(1,1) NOT NULL, [SourceName] [nvarchar](50) NULL, [SystemName] [nvarchar](50) NULL, [SourceDescription] [nvarchar](100) NULL, [SystemDesc

;WITH T AS (SELECT ROW_NUMBER() OVER(ORDER BY [SalesDate] DESC) AS ROWNUM ,Amount ,[SalesDate] FROM TempTable WHERE UserID=N'AA') SELECT A.ROWNUM,A.Amount,A.[SalesDate], (SELECT SUM(B.Amount) FR

CREATE TABLE [dbo].[ETLBatchPool]( [BatchID] [bigint] IDENTITY(1,1) NOT NULL, [BatchStatus] [tinyint] NULL, [Generator] [nvarchar](100) NULL, [GenerateTime] [datetime] NULL, [ProcessStartTime] [d

转自：http://www.cnblogs.com/lanzi/archive/2010/10/26/1861338.html

文章地址：http://www.cnblogs.com/chillsrc/archive/2012/09/19/2694313.html

--查询sqlserver 正在执行的sql语句的详细信息  --包含用户名，所在数据库，执行的sql语句,执行开始时间，驱动程序，主机名称 SELECT [Spid] = session_Id, ecid, [Database] = DB_NAME(sp.dbid),  [User] = nt_username, [Status] = er.status, [Wait] = wait_ty

文章地址：http://www.cnblogs.com/lori/p/3340719.html

select b.source as package,a.source as task,a.starttime,a.endtime,right(convert(varchar(19),a.endtime - a.starttime,120),8) duration from   (select  source,executionid,sourceid,MIN(ID) id,min(event)

1、SQL Server 2014新聚合columnstore索引介绍 http://news.cnblogs.com/n/189427/ 2、SQLServer索引的四个高级特性 http://blog.youkuaiyun.com/yzsind/article/details/8719594 3、 聚合索引(clustered index) / 非聚合索引(nonclustered index

SELECT * FROM  Table where condition="a" group by a having count(a)>1 order by a 各子句在逻辑上按一下顺序处理： 1、From 2、 WHERE 3、Group BY 4、Having 5、SELECT 6、Order by