Viewing 15 posts - 811 through 825 (of 844 total)
Eric M Russell (8/22/2013)
Chrissy321 (8/22/2013)
And as I stated earlied how do you look at a log for a stored procedure? If I have a 1000 line SQL with 50...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 22, 2013 at 1:05 pm
Chrissy321 (8/22/2013)
And as I stated earlied how do you look at a log for a stored procedure? If I have a 1000 line SQL with 50 different SQL statements...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 22, 2013 at 12:25 pm
Why don't you just right click on the table name in SSMS in the object explorer and do 'Script table as' then select 'SELECT to'. This will do the...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 22, 2013 at 7:44 am
Craig-315134 (8/21/2013)
Tom, I agree strongly with you. I favour moving as much application business logic into stored procedures as is possible,
As a developer I have to disagree. 🙁 Where...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 21, 2013 at 10:25 am
Craig-315134 (8/21/2013)
... I sometimes think that an investment in developer education would quickly erase any productivity losses ...
Education is always a good thing, but it applies all around,...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 21, 2013 at 9:37 am
In the past when we have tried to use views the performance was horrible so we stopped using them. And we avoided using stored procedures as much as possible....
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 21, 2013 at 6:43 am
When I tried something similar awhile ago I found it was faster to delete the records from the 'temp' table as I went. I would think this would do...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 19, 2013 at 8:25 am
I guess in the 10+ years I've been writing SQL I haven't found that 'awesome' moment with subqueries yet. Like I said I don't completely avoid them, I do...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 16, 2013 at 2:07 pm
Thanks for the info, I'll have to look into 'cool' ways I can use this. I know it's just a simple example but I can't see how I would...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 16, 2013 at 1:11 pm
It can be very frustrating looking at other peoples code to try and determine what it is doing. What I like to do is make a copy of it...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 16, 2013 at 9:44 am
Here is some code I've used to try and get this info, it helps cut out some of the clutter, but it still doesn't produce one line per 'step' with...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 15, 2013 at 7:39 am
Sorry for using 'work' table when I mean an intermediate table. If I have process A that normally ran at 10 PM and it created a intermediate table work_db.dbo.policy_list,...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 8, 2013 at 9:32 am
My comment is centered around the use of tempdb over 'work' tables. What I mean is that in the very beginning of us using SQL server we wrote almost...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 8, 2013 at 8:40 am
Your varchar is to small for the data you are putting into it, so it is only taking the first 8 characters and then trying to convert that to a...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
July 31, 2013 at 8:26 am
Scott Arendt (7/15/2013)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
July 15, 2013 at 8:24 am
Viewing 15 posts - 811 through 825 (of 844 total)