Viewing 10 posts - 1 through 10 (of 10 total)
Ninja's_RGR'us (2/8/2011)
Like I said I NEVER leave the keys out of the dev phase.
And then I'm good enough at tuning that I don't need...
February 8, 2011 at 12:36 pm
hi
I think probably you mean the sequence in which the script will be executed .
and hence you are concerned about
ALTER TABLE [dbo].[UserInfo] WITH CHECK ADD CONSTRAINT [FK_UserInfo_Country]...
February 8, 2011 at 12:00 pm
Ninja's_RGR'us (2/8/2011)
Also, the script in that sequense qill not work, so maybe we...
February 8, 2011 at 11:53 am
pavan_srirangam (2/8/2011)
February 8, 2011 at 11:44 am
Ninja's_RGR'us (2/8/2011)
And just to point out something else. You will be able to delete, but not TRUNCATE. The fk removes the ability to truncate, but that's all.
Yeah ,...
February 8, 2011 at 11:36 am
Thanks,
but Logically speaking , Dont you think its wrong that it will not allow me to delete a record in UserInfo Table
Country Table is Master Table, I am not going...
February 8, 2011 at 11:27 am
Thanks for your quick reply
I quote you
"2 Improves db speed" and this is my primary motivation., but i wonder architecturally if its a good practice.
Limitation here i see is...
February 8, 2011 at 11:13 am
andrewd.smith (3/3/2009)
UPDATE C
SET C.rank = M.reputationvalue
FROM TblComputedData C INNER JOIN TblFeedbackData F
ON c.userId = F.UserId
INNER JOIN TblMasterData m
ON F.Score BETWEEN m.MinimumValue and M.MaximumValue
WHERE isProcessed =1
There's a potential...
March 3, 2009 at 3:43 am
Thanks Mangal, nice response, Just checking your blog now.
March 3, 2009 at 3:36 am
Viewing 10 posts - 1 through 10 (of 10 total)