Viewing 15 posts - 47,056 through 47,070 (of 59,064 total)
Like I said... you got lucky. There have been dozens of posts where folks want to go back to 2k because 2k5 made the app slower.
Very glad it worked...
November 21, 2008 at 5:00 pm
Heh... then there are the folks that believe those datatypes are nothing more than a form of formatting that should really be done in the GUI. I'm one of...
November 21, 2008 at 5:19 am
sandeephughes (11/21/2008)
Thanks for everybody's reply for confirming that SQL Server 2005 has much better performance improvement than SQL Server 2000.
Nah... that's just not true. It may be true for...
November 21, 2008 at 5:14 am
Damned smiley faces... see attached, please...
November 20, 2008 at 9:25 pm
Well, kinda... 😉 It doesn't use xp_CmdShell, but it does (I'm a bit embarrassed but couldn't be helped with sp_OA* in SQL Server 2000, that I know of) use...
November 20, 2008 at 9:20 pm
Heh... yeah... I don't even look for the word CURSOR, anymore... they need a WHILE loop to really do anything and, since both are RBAR, I just look for the...
November 20, 2008 at 9:09 pm
Run the code... what do you think from running the code?
November 20, 2008 at 9:04 pm
karthikeyan (11/20/2008)
...and send the reports to the business users...
Not quite what I was looking for... What type of report are you sending to the business users where you have to...
November 20, 2008 at 8:07 pm
You're lucky... I've also seen it do just the opposite.
November 20, 2008 at 8:05 pm
mpdillon (11/20/2008)
It was late. The DateAdd function is incorrect. It should read.DateAdd("d",1,Now)
or in VB 2008
DateAdd(DateInterval.Day,1,now)
T-Sql to the left of the operator, VB to the right.
Nope... should be DateAdd(d,1,GETDATE()) in T-SQL....
November 20, 2008 at 8:03 pm
venkat (11/19/2008)
I don't know who you are? And remind one thing may be you are not a Database Administrator because of as...
November 20, 2008 at 7:52 pm
Lynn Pettis (11/20/2008)
Kicking_Fish0713 (11/19/2008)
Thanks for a quick response.I don't use hardcoded values that's why I'm using a cursor.Can you pls send me a sample script using a cursor?Thanks in advance.
First...
November 20, 2008 at 6:48 pm
longobardia (11/20/2008)
I couldn't bare the pain any longer reading your suggestions.
Let me give hime the answer:
SELECT T1.ObjectID FROM....
SELECT T2.ObjectID FROM ....
see below:
IF EXISTS(SELECT T1.ObjectID FROM @tmp_subjects t1
...
November 20, 2008 at 6:43 pm
Adrian Nichols (11/20/2008)
Jeff Moden (11/19/2008)
Boy oh boy do I ever agree with that! Guess that makes us "elitists", huh? 😛
I wouldn't say that makes you elitist in the slightest....
November 20, 2008 at 6:38 pm
Christopher Stobbs (11/20/2008)
Thanks Jeff,Very useful info there 🙂
You bet, Chris... thanks for the feedback.
November 20, 2008 at 6:02 pm
Viewing 15 posts - 47,056 through 47,070 (of 59,064 total)