Viewing 15 posts - 601 through 615 (of 3,232 total)
Phil Parkin (3/22/2010)
Expressions allow you to use variables, but not to assign their values.
Yep, Phil's correct. I did not see the assignment. You'll need to increment your variable...
March 22, 2010 at 3:15 pm
Make sure you type cast your counter variable as string....otherwise, you cannot include it in your string variable.
March 22, 2010 at 3:10 pm
Well, what error are you getting?
March 22, 2010 at 2:22 pm
What error are you getting?
Just off the top of my head, you need to change your sysdatabases to sys.databases.
March 22, 2010 at 11:43 am
Looking back at the original post, I now see that we were not told of the nature of the timeout operation. I was assuming that a SELECT statement was...
March 22, 2010 at 10:21 am
Glad to help.
So now that you've fixed the performance problem with your SP, I think you still have some work to do. Go back to my first post and...
March 19, 2010 at 3:44 pm
Very interesting...I have never read that before. When performance testing, I typically just issue the DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE commands.
It makes sense that dropping only the...
March 19, 2010 at 3:26 pm
Where did you get the idea that you have to checkpoint before running this? DBCC DROPCLEANBUFFERS clears out the clean buffers. Checkpoints flush out the dirty buffers so...
March 19, 2010 at 3:12 pm
One more thing to keep in mind.....if you plan to combine the 2 packages into one, you no longer need the Stored Procedure so everything I stated above was really...
March 19, 2010 at 2:44 pm
rds207 (3/19/2010)
could you please let me know why we have used where ec_step_id is Null?As there are no nulls in ec_step_id.....
It's how you write an outer join when you want...
March 19, 2010 at 2:43 pm
First, your stored procedure will still be inefficient. Replace your query with the query that I posted in my last post. You are still using NOT IN....change that...
March 19, 2010 at 1:20 pm
It really depends on what the data represents. If it represents numeric data, it needs to be stored as a numeric type like int. Theres a difference in...
March 19, 2010 at 12:35 pm
Viewing 15 posts - 601 through 615 (of 3,232 total)