Viewing 15 posts - 2,131 through 2,145 (of 3,232 total)
Nested cursors on large tables, awesome!! If speed is your concern, scrap the cursors. I agree with Peter, post your code and work towards creating a SET-based solution.
August 28, 2007 at 3:59 pm
They do look good, but I still think it is extremely important to capture the execution plan using profiler.
August 28, 2007 at 10:49 am
Everyone's favorite answer....it depends. Roger has given you some very useful info here, but much of what you are after depends on what you are trying to accomplish. You say...
August 27, 2007 at 3:27 pm
Dave,
You mention that you believe that your index strategy is sound, but nowhere throughout this thread do I see that you’ve verified that your execution plan...
August 27, 2007 at 3:00 pm
Roger beat me to this, but here's my answer too. I'm in agreement with Roger, but I will add that the trace flags in SQL Server 2000 do work!
There’s...
August 27, 2007 at 2:33 pm
What happens if you set the job owner to 'sa'?
August 27, 2007 at 12:10 pm
I would recommend that you become an expert in T-SQL. While you can spend as much time as you want on the front-end coding, you will want as much of...
August 27, 2007 at 12:05 pm
Nimesh,
This is usually due to permissions. When you execute the package manually, it will run under the context of the user account that you are logged in as. When...
August 27, 2007 at 11:43 am
Why does this need to be dynamic SQL? I don't see anything in your code that would require dynamic SQL to accomplish.
August 24, 2007 at 12:13 pm
I'm not sure if this is much more efficient and there is probably a better method to this madness, but here's an example of code that will produce the same...
August 23, 2007 at 9:36 am
When I run your code with your sample data, I do not get the results that you show here. Here's what I get, can you clarify?
CallID UCID GroupID
----------- ----------...
August 23, 2007 at 8:24 am
Just curious, but what advantages are you trying to get by running this as a script over a stored procedure?
August 22, 2007 at 3:18 pm
It would help if you could show an example of how the new column's data should look. Can you take your sample data and show how the data for the...
August 22, 2007 at 10:27 am
Here it is with the PATINDEX used also:
DECLARE @string varchar(100)
SET @string = '12345 Test Address Dr.'
SELECT LEFT(@String,CHARINDEX(' ', @string)),
LEFT(@string,PATINDEX('%[^0-9]%',@string))
August 22, 2007 at 10:24 am
DECLARE @string varchar(100)
SET @string = '12345 Test Address Dr.'
SELECT LEFT(@String,CHARINDEX(' ', @string))
August 22, 2007 at 10:19 am
Viewing 15 posts - 2,131 through 2,145 (of 3,232 total)