Please note that we are not looking to create a data warehouse. We just need to create tables in star schema so the 3rd party tool can access these tables...

Okay thanks. I will post the same on SQL Server 2008.

Friends, if anyone has implemented star schema on the transactional database please give your thoughts...

Thanks again

Oh yes it works !!! THank you

Thanks got it.

declare @weekday varchar(10)

declare @in_date date='01/20/2016'

select @weekday=datename(weekday,CONVERT(VARCHAR(10),@in_date,101))

select @weekday

THank you. In the 1st query, does the date have to be in this specific format or is it possible to change @in_date format? BEcause the input date will be...

Thank you again. It is possible that the slowness is not caused due to the cache. But in any case, to rule out it is not cache, I'm trying...

Thanks..

I ran the below commands to clear the cache and ran the test again but we did not see any difference to the...

Thank you for the info.

When you mentioned database restore will clear cache, will making database offline/online clear cache for that database as well?

Thanks a lot

If the buffer cache is for the Instance, when does the clear cache happen? Is checkpoint an internal process that happens after a specific time?

Also, is there a way...

I tried EXECUTE (@sql) as below, command completes successfully. But then it executes the alter command for only one constraint at a time... Please help...

declare @sql nvarchar(max)

SELECT @sql =...

I tried the below script, it prints all the alter commands. But, when I do execute @sql instead of print, I get the below error..

declare @sql nvarchar(max)

SELECT 'ALTER TABLE...

Thank you so much.. I've generated the alter commands below to make the constraints trusted. Totally there are about 2000 alter commands, but just wondering if it is possible to...

Thanks but my understanding was that only when enabling/disabling constraints needs to be created 'with check check'. Do we need to use 'with check check' when dropping and...

Friends,

What are other causes that make check/FK constraints non trusted because we normally don't enable/disable constraints during loads or scripts or anything. We always drop and re-create constraints....