Thanks dave... its working but in my real time scenario where i have a millon of records to compare count(*) over (paritition...

is taking very long time to return the...

Thanks Hugo. Nice explanation.

I have used the below DBCC to see how page allocation happening and how it logically arranged using NextpageID and PrevpageID.

DBCC IND(Demo, Demo, -1);

GO

My guess is right. 🙂

Nice Question.

Yes nakul...

Thanks for the nice question.

It would have been tough if you didn't have "-- Drop the associated constraints" in the statements.

Yes Happycat...Good Explanation.

Select ceiling(Convert(decimal(2,1),1.09)) will give you the result 2.

..

Try This..

Create Table TableA (ID int identity(1,1),FakeName1 Varchar(20),FakeName2 varchar(20),Amount int)

Create Table TableB (ID int identity(1,1),Actualname Varchar(20),FakeName varchar(20))

Insert into TableA Values('Mike','Johnny',10000),('Ruke','Dirk',10000),('Andy','Micheal',10000)

Insert into Tableb Values('Peter','Johnny'),('Andrews','Andy'),('Stephen','Dirk'),('Murray','Micheal')

Select * from TableA

Select * from TableB

;with P1CTE...

Nice question..

Complex select statements ..so I ignored it and guessed the answer with the where condition.

Must be typing mistake from the author of this question... but how can we have "-0" in the result. 😉

Good Question.

SELECT @t = @t + @comma + a.a

,@comma = ','

FROM #a a

ORDER BY 1

Result : C

SELECT @t = @t + @comma + a.a

,@comma...

Good.

but when tried with SET QUOTED_IDENTIFIER OFF; also it is working fine. (in SQL Server 2008).

Hi Namrata,

All I found was in the first SP in line number 28 you are passing "password". In that place you should pass the variable "@Password".

Is this cause the problem?

Thanks Site Owner..

Exactly I have the same requirement in my offfice as we are going to change few of our indexes as unique based on the natural keys. This helps...

Hi bijs,

You can create 12 partitions based on the month key(Mkey) value. But it will store the data irrespective of the year.

2009 January data and 2010 January data will...