Viewing 15 posts - 46,666 through 46,680 (of 59,062 total)
ggraber (12/10/2008)
Jeff Moden (12/10/2008)
I already did such a comparison in Part 1 of this series, Goldie. 😉 Of course, I don't mind if someone else does a head-to-head comparison.
Jeff,...
December 10, 2008 at 6:07 pm
Madhivanan (12/10/2008)
Nice Article JeffHere is mine
http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx
Thanks for the feedback and the link, Madhivanan.
December 10, 2008 at 5:22 pm
I already did such a comparison in Part 1 of this series, Goldie. 😉 Of course, I don't mind if someone else does a head-to-head comparison.
December 10, 2008 at 5:17 pm
Heh... nah... I've got a couple of folks like that at work... they're actually pretty nice if you can get them to stop talking about their damned hump! 😛
December 10, 2008 at 5:13 pm
I concur... haphazard formatting is tough on anything that expects a consistant format. OPENROWSET and Text Linked Servers do a pretty job job there.
Of course, when you have haphazard...
December 10, 2008 at 5:06 pm
Garadin (12/10/2008)
(I know I know, it makes it easier to comment out lines and such, but I still hate it)
I do put each...
December 10, 2008 at 5:02 pm
Shoot (no pun intended)... it was the counseling that caused the disorder. 😛
December 10, 2008 at 4:57 pm
Amazing story, indeed. Lynn is lucky to be alive never mind without having any broken bones.
Me? I'd have just shot the car. 😉
December 10, 2008 at 4:48 pm
Patricia Monreal (12/10/2008)
Jeff and Jeffrey,Thanks to both of you. That seems like a very doable solution that will avoid the duplication. I really appreciate your help.
Pat
Thanks for the feedback, Pat......
December 10, 2008 at 4:42 pm
Nah... I'm with ya, Jeff. Temporary insanity on my part. Ignoring the dupes is intentionally destroying data in an unaccountable fashion and shouldn't be used. Sorry I...
December 10, 2008 at 6:20 am
madhu.arda (12/10/2008)
Iam curious to know why the available space for the database was showed as zero in enterprise manager and negative value when I ran sp_spaceused before running DBCC...
December 10, 2008 at 6:03 am
Nah... the worst posts ever (there were 2 at the same time) both beat 209 by a mile. Remember {shudder} "Bankers Rounding"? Even some of the good guys...
December 10, 2008 at 5:55 am
Jeffrey Williams (12/7/2008)
Instead of trying to fiddle with IGNORE_DUP_KEYS on the index, ...
No "fiddling" required... it's set it and forget it. 😉
December 9, 2008 at 10:35 pm
... heh... or some very high velocity pork chops fired at point blank range. 😉
December 9, 2008 at 10:31 pm
That method using insert/rollback is a great place for more RBAR to occur... and it takes twice as long... 1 period for an insert... 1 period for a rollback... and...
December 9, 2008 at 10:27 pm
Viewing 15 posts - 46,666 through 46,680 (of 59,062 total)