Viewing 15 posts - 49,531 through 49,545 (of 59,078 total)
Ummm... go check the final date Barry... might explain the "speed" you're getting...
June 29, 2008 at 1:05 pm
I think that's more of what they're after... I don't listen to the pod-casts for many of the same reasons... I'll even add a reason... I don't remember as...
June 29, 2008 at 1:02 pm
Wingenious (6/28/2008)
...
The databases were built on an impromptu basis by application developers working outside their area of...
June 29, 2008 at 12:58 pm
Nah... After adding the "ALL", yours is just as fast, fewer lines to remember, and easier on the eyes.
a lot of shops have prohibitions about using system objects...
June 29, 2008 at 12:47 pm
Sorry... I don't get it... Why were 7 rows for EventData1 = 7 included in the output?
Also, please see the link in my signature for how to post data so...
June 29, 2008 at 12:36 pm
You can't replace the vendor's sproc? Heh... I do it all the time especially when it sucks the life out of my servers... 😉
June 29, 2008 at 11:27 am
Matt Miller (6/28/2008)
It's just that I can more easily control the number I need to generate
Just messing with you a bit now, ol' friend... It's pretty easy to...
June 29, 2008 at 11:24 am
Matt Miller (6/28/2008)
June 29, 2008 at 10:42 am
That's the big thing... the other thing not so obvious is you don't show how to limit the output to any given number. 😉
June 28, 2008 at 11:57 pm
Thanks Matt...
Hey... like I said, take the exact code you posted and try to gen a 1000 rows... you'll see why...
June 28, 2008 at 10:31 pm
rbarryyoung (6/28/2008)
OK, I sent you the draft. Heh, I didn't see your reply before I sent, hopefully the mess o' text I sent will be alright.
I gotta wonder how...
June 28, 2008 at 6:11 pm
You're gonna think I'm nuts, but that's the kind of stuff that you should turn around and write an article about.
June 28, 2008 at 6:02 pm
rbarryyoung (6/28/2008)
Writing here is hard enough, but adapting to the form or an article, especially anything long, presents an almost insurmountable barrier to me...
Heh... nah... you have the knack and...
June 28, 2008 at 5:16 pm
Then, if you add a check, all this talk about dynamic SQL becomes a moot point. 😉
June 28, 2008 at 5:09 pm
Like everyone has said, we'd probably need a lot more detail than that to actually help...
... but, based on your general description immediately above, I have to say that...
June 28, 2008 at 1:53 pm
Viewing 15 posts - 49,531 through 49,545 (of 59,078 total)