Viewing 15 posts - 31 through 45 (of 405 total)
Did you try putting a break point on post execute event of the execute SQL task try watching the variable value getting assigned?
December 9, 2016 at 10:29 am
Why don't you pass the parameter like
If @alloc_id < 0
exec proc2 @alloc_id
December 9, 2016 at 9:52 am
Hi
This is a SQL server forum, so you can expect quick help for SQL questions.
Yet, looking at your code I think you need to rearrange your code, you can...
December 8, 2016 at 10:27 am
One always. Two many times. Its mostly the client's decision based on their priority and budget. My role is often to appraise the stakeholders honestly about the different options...
December 6, 2016 at 6:59 am
robert.sterbal 56890 (12/2/2016)
joeroshan (12/2/2016)
robert.sterbal 56890 (12/1/2016)
How is the script licensed?
Hi Robert
I do not have any problem someone using the script to help their job done easy. In fact that is...
December 2, 2016 at 11:06 am
robert.sterbal 56890 (12/1/2016)
How is the script licensed?
Hi Robert
I do not have any problem someone using the script to help their job done easy. In fact that is the point of...
December 2, 2016 at 10:09 am
ggrewe (12/1/2016)
If the table has an Identity column, you cannot...
December 2, 2016 at 9:58 am
Bruce-12445 (11/30/2016)
December 1, 2016 at 3:34 am
GilaMonster (11/30/2016)
joeroshan (11/30/2016)
It is recommended to create multiple data files with same size to optimize tempdb to take advantage of proportional fill algorithm and reduce allocation contention.
That is specifically for...
December 1, 2016 at 3:15 am
It is recommended to create multiple data files with same size to optimize tempdb to take advantage of proportional fill algorithm and reduce allocation contention. Unless you have separate file...
November 30, 2016 at 9:35 am
Good call. I have always found linked server/ openrowset slower and resort to it only in case of emergencies. Thanks for posting the statistics.
Just curious, why are you not executing...
November 30, 2016 at 5:28 am
The plan with join looks better since you are getting a seek for the Asset table. But both cases the left join on the asset_attr table is going for a...
November 30, 2016 at 5:12 am
I think Gail has a point there.
I have had side by side many times but I can remember always it was the lower version first.
It would be good to test...
November 30, 2016 at 3:36 am
Got your point. You will use loops sparingly. But whenever using loop is it a good practice to use temp tables instead of the actual table. is that your query?
It...
November 30, 2016 at 3:13 am
Viewing 15 posts - 31 through 45 (of 405 total)