Viewing 15 posts - 51,421 through 51,435 (of 59,072 total)
Exceptional DBAs are not just defined by what they know, but what they do. I guess we all know roughly how a good DBA would react if a server is...
March 29, 2008 at 7:57 pm
I agree... Use IF UPDATE(somecolumn) instead of trying to setup the byte slicing of COLUMNS_UPDATED.
March 29, 2008 at 7:08 pm
Ummm... I don't get it... if you have a WAN amongst all of the offices and you're required to report on all the offices, why don't you have a centralized...
March 29, 2008 at 6:59 pm
Sorry folks... I actually deleted my post (Jack caught a piece of it in his reply) because I was on more of a rant about performance than why to use...
March 29, 2008 at 6:52 pm
Marios Philippopoulos (3/25/2008)
I want to replace the xp_cmdshell call with a call to a CLR sproc...
WHY??? A proxy account for xp_CmdShell will be much more secure than some adhoc...
March 29, 2008 at 6:49 pm
Pho...
Sorry... I didn't understand your problem before.
Barry is absolutely spot on in his post above... two sets of tables and a view that is repointed (very much like...
March 29, 2008 at 6:38 pm
Pretty darned good post, yourself, Barry.
March 29, 2008 at 6:32 pm
pho (3/28/2008)
noone any idea?...
Yes... take the delay out and remove the transaction. The data will be available instantaneously and everyone will be happy. 😛
There's gotta be more to this...
March 29, 2008 at 1:38 pm
Heh... yeah... I don't like recursion for the same reason you do... I end up sucking my thumb and twiddling my hair when I'm trying to troubleshoot one that doesn't...
March 29, 2008 at 1:06 pm
Yeaup... I normally do too. I think the difference between 2k and 2k5 might be that 2k is identifying how the first row is found and 2k5 is identifying...
March 29, 2008 at 11:16 am
Robert (3/29/2008)
In money calculations you shouldn't use float.
Again... right with you until you said that...
March 29, 2008 at 11:07 am
blahknow (3/29/2008)
Using XML is a satisfactory resolution for me.
There could of course be better solutions which are above my present comprehension and i admit i didnt understand all the...
March 29, 2008 at 10:58 am
rbarryyoung (3/29/2008)
Here is my Adventureworks version. It seems to be faster than the Tally Table approach, but I am not sure if they are returning equivalent datasets:
Thanks Barry... I...
March 29, 2008 at 10:27 am
Cory Ellingson (3/29/2008)
March 29, 2008 at 9:07 am
Mike C (3/28/2008)
Jeff Moden (3/28/2008)
Mike C (3/28/2008)
March 28, 2008 at 11:15 pm
Viewing 15 posts - 51,421 through 51,435 (of 59,072 total)