Viewing 15 posts - 871 through 885 (of 5,590 total)
riya_dave (5/9/2012)
ok.i remove inserting in identity,but still nt improving performance
The identity column was only to aid you in adding a unique index on your table variable with duplicate values.
May 9, 2012 at 9:44 pm
Lynn Pettis (5/9/2012)
WayneS (5/9/2012)
Lynn Pettis (5/9/2012)
riya_dave (5/9/2012)
i got it,but anyhow i have to use while loop for condition
Okay, riya_dave, do you have a solution yet? I have 3 cursor-based...
May 9, 2012 at 9:41 pm
Lynn Pettis (5/9/2012)
riya_dave (5/9/2012)
i got it,but anyhow i have to use while loop for condition
Okay, riya_dave, do you have a solution yet? I have 3 cursor-based solutions and a...
May 9, 2012 at 9:28 pm
riya_dave (5/9/2012)
i tried join also.nothing seems to work.
my question is i have table variables,i can use
UNIQUE CLUSTERED ( id ,account)
in table definition. and its improving performance,but i...
May 9, 2012 at 2:35 pm
capn.hector (5/9/2012)
Lynn Pettis (5/9/2012)
riya_dave (5/9/2012)
i have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.
I...
May 9, 2012 at 1:01 pm
riya_dave (5/9/2012)
i have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.
I am calling 5-6...
May 9, 2012 at 12:57 pm
Steve Jones - SSC Editor (5/8/2012)
Thanks, everyone. She struggled a bit to get going yesterday in the rain, but today she's having fun working in the barn.
First of all, congrats...
May 9, 2012 at 7:16 am
Working on a different solution, but I have some questions.
1. How many programs can an applicant apply for? (All the examples show a maximum of 2 - is 2...
May 1, 2012 at 11:07 am
dwain.c (4/27/2012)
Check out this thread: http://www.sqlservercentral.com/Forums/Topic1290424-392-1.aspx
Maybe I've overcomplicated it...
April 27, 2012 at 8:14 am
Are we limited to using SQL 2008 for this solution? I think a sliding window will work for this... but that requires SQL 2012. (see my article[/url] for how this...
April 27, 2012 at 8:11 am
Well, I see that Steve is catching up from being in England... I have an article and a QotD being published on 5/10. Plus my UG mtg that night. Plus...
April 27, 2012 at 8:03 am
Jeff Moden (4/26/2012)
dwain.c (4/26/2012)
You mean I gotta remember who and when?I'm lucky sometimes if I can remember the day of the week.
Nope... just quote the thread by hitting the quote...
April 27, 2012 at 7:59 am
GilaMonster (4/25/2012)
If anyone's willing to offer suggestions, I'm looking for examples of two things:
Query optimisation/query execution myths (for a blog post series). Things like implicit conversions always...
April 25, 2012 at 4:54 pm
The Dixie Flatline (4/19/2012)
Yes, Gail, I was at the last Summit...
April 21, 2012 at 10:48 am
SQL Kiwi (4/19/2012)
SQLRNNR (4/19/2012)
Thanks for double checking my code. Too bad my results were wrong. There has got to be a way of doing this.
I agree, but we...
April 21, 2012 at 10:45 am
Viewing 15 posts - 871 through 885 (of 5,590 total)