Viewing 13 posts - 16 through 29 (of 29 total)
I have been using the template below and it has worked great for me. The article is really good too.
http://www.sqlservercentral.com/articles/Development/anerrorhandlingtemplatefor2005/2295/
Hope this helps.
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
May 22, 2009 at 12:35 pm
Jeff,
Thank you for the feedback. Here are a few things I tried:
- with recompile
- drop and re-created the procedure
- reindexed the entire database
- ran dbcc checkdb
Never heard at parameter sniffing...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
July 23, 2008 at 7:16 pm
Thanks a lot for the advice. I will run the sp_configure and split the amount of memory so that it adds up to 3GB. Our UAT server will probably get...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 30, 2008 at 1:34 pm
That is an interesting parallel Steve is making with sports. I used to play professional tennis back in my home country and college in the US. I stopped after college,...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 19, 2008 at 10:31 am
Like everyone else, the most difficult part to accomplish to get into a peaceful and focused mental state of mind is related to distractions from colleagues, emails, phone calls,... and...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 19, 2008 at 8:41 am
Ken, Thank you so much. I tired to reformat the script many times and it would keep giving me syntax errors. Thanks again.
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
June 4, 2008 at 9:22 am
Jeff' link is really thorough and provides a great explanation of the pros/cons. In the meantime, here is a simple way to solve it. Hope this helps.
declare @table table
(
salespid int
,salesamount...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
May 5, 2008 at 9:56 am
My bad. I did not see that the number needed to be appended. John's suggestion works great. I thought you only needed what was left of the ".". Sorry for...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
April 29, 2008 at 9:35 am
If the pattern is consistent, meaning there is only one instance of the "." in the string, you could use something like this.
DECLARE @String NVARCHAR(50)
SET @String = 'E955.0'
SELECT SUBSTRING(@String,0,CHARINDEX('.',@String))
Hope this...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
April 29, 2008 at 9:15 am
I would suggest the following checks:
1. make sure there is a line terminator after the last line of the BCP file.
2. make sure the columns of the BCP file match...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
April 29, 2008 at 9:07 am
I could not agree more with Steve. I am fairly young to the world of IT, under 10 years, and I have only worked for small companies, witnessed first hand...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
February 4, 2008 at 9:02 am
If you are trying to compare 2 tables that have the same fields, you could try using a FULL JOIN.
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
January 31, 2008 at 10:38 am
I just wanted to add the link to the appropriate resource. The paragraph giving the explanation was already posted by Jeff Deluca right above but if someone could replace the...
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
January 31, 2008 at 8:46 am
Viewing 13 posts - 16 through 29 (of 29 total)