Viewing 15 posts - 56,716 through 56,730 (of 59,069 total)
The auto update statistics is off. |
Luk... Sorry I missed that comment... Like I said... that's a form of...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2007 at 4:32 pm
Not a bad approach but have you tried it on, say, a million rows? Makes a real busy server if you have 2000 connections trying to do the same thing...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2007 at 4:13 pm
Yep, I agree... triggers will normally do the trick. My only concern with triggers would be that folks with DBO, SA, DDL Admin, and (I think) Bulk Insert Admin privs...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2007 at 6:34 am
Hi Lowell,
Heh... Not to worry, Lowell... as always, your response shows the good person you are.
The give away is normally a question laid out so well that if the person...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2007 at 6:14 am
If it's a once per month report as you say, Craig, then a view offers no particular advantage because the underlying data will have changed enough to force a "recompile"...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2007 at 5:43 am
Lowell covered that... you just need to modify the numbers in the "row 5 through row 12" example you asked for and he gave. If you are using SQL Server...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2007 at 9:05 pm
Ah... got it... especially the part about developers thinking that data is stored in a physical order... thought you were just being obvious and that's not the case at all. Thanks...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2007 at 8:59 pm
You'll need to do a fair bit more reasearch, but this snippet from Books OnLine (found under "auditing", imagine that?) should help you get started...
C2 auditing is necessary...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2007 at 8:49 pm
Be careful using "Views of Views"... the outer view will frequently cause the inner view to fully materialize it's rows especially when aggragates are used in the outer view... it...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2007 at 8:38 pm
And... he's learned nothing because none of you asked him to show what he tried on what is very likely to be a homework problem...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2007 at 8:33 pm
I believe adding the transaction increases the chances of a deadlock... better to let it wait than to form deadlocks.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2007 at 8:23 pm
??? I'm thinking that Lowell covered that pretty well...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2007 at 6:44 am
How far back ya wanna go on the Month-x columns?
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2007 at 6:41 am
Heh... yeah... I remember that discussion... It's a bloody shame that Microsoft keeps changing features to bugs especially on things like this... no wonder lot's of folks are hesitant to...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 19, 2007 at 7:56 am
Well... hats off to MS... ALL of our servers had the MS patch and all switched time correctly at the appointed time. Even my home machine updated correctly and on...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 19, 2007 at 6:55 am
Viewing 15 posts - 56,716 through 56,730 (of 59,069 total)