Awesome, you made my day, Thanks

Hello,

Partition function and scheme as below

-- Step 1: Create Partition Functions and schema

CREATE PARTITION FUNCTION PF_MONTHLY (DATETIME)

AS RANGE LEFT FOR VALUES ('2014-01-01')

-- Step 2: Create partition scheme

print char(9)+'Create Partition...

please share document with me as well sachinonnet@gmail.com. Thanks in advance.

How about snapshot ?

we can take DB snapshots on PROD and execute ETL on snapshot. let me know your view / recommendation on this.

well most of the Pinal questions comming as academic and not as experienced users.

mssqltips.com is also good website to find more interview questions.

you can follow Pinal @ SQLAuthority

he listed questions for basic to advanced.

Hi,

If we keep SQL 2005 as primary and 2008 as secondry :-

The databases don't get upgraded along the way. The upgrade doesn't occur until the database is recovered. For this...

This is the best link.

Regards,

Sachin

i think 3/4 - SQL treat both as integer and won't return result but when we work with 3.0/4.0 or below convert it works fine,

select (convert(decimal(2,1),3)/convert(decimal(2,1),4));