Viewing 15 posts - 22,066 through 22,080 (of 26,484 total)
Kit G (3/9/2009)
Lynn Pettis (3/9/2009)
I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.
Perhaps you should send back...
March 9, 2009 at 2:37 pm
Alvin Ramard (3/9/2009)
Lynn Pettis (3/9/2009)
DavidB (3/9/2009)
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSC
Top 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone...
March 9, 2009 at 2:35 pm
DavidB (3/9/2009)
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSC
Top 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you...
March 9, 2009 at 2:20 pm
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSC
Top 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you are...
March 9, 2009 at 2:10 pm
Okay, this topic has been double posted. I suggest any further discusion continue in this thread. To see what else has been suggested, look here.
March 9, 2009 at 2:05 pm
Okay, we have a double post here with answers going in both. I suggest continuing any further discussion on this topic here (meaning the other thread).
March 9, 2009 at 2:03 pm
Brandie Tarvin (3/9/2009)
Depends on the situation. You can't always fix the Group By. Sometimes it screws up your result set if you do.
Believe me, I've tried that. Sometimes fixing the...
March 9, 2009 at 12:27 pm
GSquared (3/9/2009)
Grant Fritchey (3/9/2009)
All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.
That is too funny! ...
March 9, 2009 at 12:08 pm
Can you capture the execution plan, zip it, and post to this thread? there may be more going on than just changing to a hard coded set of values.
Also,...
March 9, 2009 at 12:06 pm
Lynn Pettis (3/9/2009)
And Gail, its easy to see why you leave Mike to others to answer. I mean, really.
Look at his latest post on that thread. I mean,...
March 9, 2009 at 11:55 am
Mike Levan (3/9/2009)
Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows...
March 9, 2009 at 11:54 am
After a couple of minor changes to your code:
CREATE PROCEDURE sp_TransferData_Compare
(
@StartDate varchar(10),
@EndDate varchar(10)
)
AS
BEGIN
...
March 9, 2009 at 11:52 am
DavidB (3/9/2009)
Lynn Pettis (3/9/2009)
Lynn Pettis (3/9/2009)
And Gail, its easy to see why you leave Mike to others to answer. I mean, really.Okay, I just went sarcastic in this thread.
I...
March 9, 2009 at 11:42 am
Is the actual code being run inside a stored procedure? If so you are probably suffering from parameter sniffing. Please post the code for the stored procedure.
March 9, 2009 at 11:36 am
Lynn Pettis (3/9/2009)
And Gail, its easy to see why you leave Mike to others to answer. I mean, really.
Okay, I just went sarcastic in this thread.
March 9, 2009 at 11:33 am
Viewing 15 posts - 22,066 through 22,080 (of 26,484 total)