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...
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...
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...
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...
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,...
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....
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...
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...
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...
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...
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...
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,...
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...
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...
July 31, 2013 at 8:26 am
Scott Arendt (7/15/2013)
July 15, 2013 at 8:24 am
Viewing 15 posts - 811 through 825 (of 844 total)