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 TempTableWHERE 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) durationfrom  (select  source,executionid,sourceid,MIN(ID) id,min(event)

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

SELECT *FROM  Tablewhere condition="a"group by ahaving count(a)>1order by a各子句在逻辑上按一下顺序处理：1、From2、 WHERE3、Group BY4、Having5、SELECT6、Order by