Viewing 15 posts - 13,801 through 13,815 (of 26,486 total)
Just remember that Kimball isn't the only option. You may also want to look at other methodologies as well and then choose the one that best fits your environment.
One...
March 13, 2012 at 12:34 pm
You may want to change your where caluse to this:
...
where adddatetime >= dateadd(dd, datediff(dd, 0, getdate()), 0) and adddatetime < dateadd(dd, datediff(dd, 0, getdate()) + 1 , 0)
March 13, 2012 at 12:27 pm
capn.hector (3/13/2012)
March 13, 2012 at 12:13 pm
And the broken record returns.
Why can't he give it a break. He wants everyone to be just like him. He really needs to get over himself. Many...
March 13, 2012 at 12:08 pm
You could probably change null to 1 and get the same effect. It is generating an increasing value (row_number()) for however many rows are being generated for the dynamic...
March 13, 2012 at 12:01 pm
Not sure, but I think this part may be the problem:
DISK = 'F:\Star\PNTab_NationalCofee01.bak',
DISK = 'F:\Star\PNTab_NationalCofee01.bak'
I would think this wouldn't work as you are trying to strip the backup to the...
March 13, 2012 at 11:57 am
Most likely won't work as database mirroring requires the use of the full recovery model.
At a previous employer where I implemented database mirroring I did not attempt to change the...
March 13, 2012 at 11:53 am
Then we have to agree to disagree. Personally, I guess I should just bow out as I find the arguments so far counter productive and everyone is just trying...
March 13, 2012 at 11:49 am
Curious, what type of plan does this produce:
select
Personid
from
...
March 13, 2012 at 11:44 am
Rereading your original post I noticed this:
It always uses clustered index scan on the table A which is consuming most of the time.
With an ordered list of Personid's, this is...
March 13, 2012 at 11:39 am
SQLKnowItAll (3/13/2012)
mayur birari (3/13/2012)
Yes. it does have a foreign key in table B. I agree it may not be needed since it is also a clustered PK on the same...
March 13, 2012 at 11:34 am
And it could potentially confuse others that may come to this thread.
March 13, 2012 at 11:25 am
mayur birari (3/13/2012)
Yes.
Yes what?
Have you tested the code I posted?
March 13, 2012 at 11:20 am
SQLKnowItAll (3/13/2012)
March 13, 2012 at 11:19 am
Okay, please stop. i don't think this discussion that really comes down to semantics is really helping. All I really am seeing now is each person trying to...
March 13, 2012 at 11:05 am
Viewing 15 posts - 13,801 through 13,815 (of 26,486 total)