November 23, 2015 at 6:47 am
Brandie Tarvin (11/23/2015)
Hey, guys, we have a language conversion question over here. Can anyone assist with this?
I'm sure this is just a typical PEBKAC. 😀
November 23, 2015 at 6:51 am
Luis Cazares (11/23/2015)
Brandie Tarvin (11/23/2015)
Hey, guys, we have a language conversion question over here. Can anyone assist with this?I'm sure this is just a typical PEBKAC. 😀
Or there are mitigating factors that the OP forgot to post about (or didn't realize mattered).
November 23, 2015 at 8:24 am
Luis, you are a better person than I am. I have no desire to keep encouraging the OP to ask for the query, so I am not answering at the moment.
November 23, 2015 at 8:55 am
Brandie Tarvin (11/23/2015)
Luis, you are a better person than I am. I have no desire to keep encouraging the OP to ask for the query, so I am not answering at the moment.
It's just that (s)he's so close that it might be frustrating. It's like when you're getting an error because of a missing parenthesis or semicolon. Then, I just got carried over.
November 23, 2015 at 9:01 am
Is it me or many people don't really understand error handling or why and how to use try...catch...?
November 23, 2015 at 9:05 am
Luis Cazares (11/23/2015)
Is it me or many people don't really understand error handling or why and how to use try...catch...?
It's not just you. Though, to be fair, Try...Catch probably caught a lot of people off guard because they don't use other programming languages and only know as much T-SQL as they can get away with knowing to do their job.
November 23, 2015 at 9:05 am
Many people don't understand error handling or transactions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2015 at 9:13 am
Brandie Tarvin (11/23/2015)
Luis Cazares (11/23/2015)
Is it me or many people don't really understand error handling or why and how to use try...catch...?It's not just you. Though, to be fair, Try...Catch probably caught a lot of people off guard because they don't use other programming languages and only know as much T-SQL as they can get away with knowing to do their job.
I agree but it isn't limited to t-sql. The schocking inability to understand that a catch with nothing other than writing a line to the debug console is horribly overwhelming. I can't tell you how many times I have seen something like that and the person can't figure out the problem because "nothing happens" with their code. Far too many people like to catch errors but fumble horribly because they don't know how to actually handle them.
The try/squelch anti-pattern is just as common in most programming languages as it is in t-sql. :sick:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 23, 2015 at 9:15 am
I have the simplest error-handling method in the universe:
Is there an error?
DROP DATABASE <problemDB>;
Done.
November 23, 2015 at 9:16 am
Brandie Tarvin (11/23/2015)
Luis Cazares (11/23/2015)
Is it me or many people don't really understand error handling or why and how to use try...catch...?It's not just you. Though, to be fair, Try...Catch probably caught a lot of people off guard because they don't use other programming languages and only know as much T-SQL as they can get away with knowing to do their job.
And they are still forced to use it in every single query because of "best practices" or "company standards" without appropriate training. That ends up just hiding errors and days/weeks/months later people wonder why the information is all wrong and no one can trace the errors.
I'm pretty sure that people who "only know as much T-SQL as they can get away with knowing to do their job" won't even want to use the try...catch blocks as it's only additional typing.
November 23, 2015 at 9:23 am
Brandie Tarvin (11/23/2015)
I have the simplest error-handling method in the universe:Is there an error?
DROP DATABASE <problemDB>;
Done.
I like that. Perhaps a more individualized approach would be to drop the login of the troublemaker. They wouldn't complain about the error. By the time they filled out the requisite stack of forms to get permission and approval for what they need, the developer might have the problem fixed for real. 😛
November 23, 2015 at 9:32 am
pietlinden (11/22/2015)
The spam this weekend is insane... is the filter taking the weekend off?
So, the filter is learning, though it misses some I don't understand.
However the filter scans post-post. This was the way in which our IT dev group implemented it. I'm trying to get it changed, but the majority of the time I get to reports, many have been deleted or filtered out.
I have raised this again with the boss, and I hope we'll get something more done.
November 23, 2015 at 10:01 am
Steve Jones - SSC Editor (11/23/2015)
pietlinden (11/22/2015)
The spam this weekend is insane... is the filter taking the weekend off?So, the filter is learning, though it misses some I don't understand.
However the filter scans post-post. This was the way in which our IT dev group implemented it. I'm trying to get it changed, but the majority of the time I get to reports, many have been deleted or filtered out.
I have raised this again with the boss, and I hope we'll get something more done.
Thanks, Steve. At least you're aware of it.
November 23, 2015 at 10:42 am
Ed Wagner (11/23/2015)
Steve Jones - SSC Editor (11/23/2015)
pietlinden (11/22/2015)
The spam this weekend is insane... is the filter taking the weekend off?So, the filter is learning, though it misses some I don't understand.
However the filter scans post-post. This was the way in which our IT dev group implemented it. I'm trying to get it changed, but the majority of the time I get to reports, many have been deleted or filtered out.
I have raised this again with the boss, and I hope we'll get something more done.
Thanks, Steve. At least you're aware of it.
Aware, and annoyed. The cleanup mostly falls to me on weekends. I am pushing for something to happen.
November 24, 2015 at 1:22 am
Ed Wagner (11/23/2015)
Brandie Tarvin (11/23/2015)
I have the simplest error-handling method in the universe:Is there an error?
DROP DATABASE <problemDB>;
Done.
I like that. Perhaps a more individualized approach would be to drop the login of the troublemaker. They wouldn't complain about the error. By the time they filled out the requisite stack of forms to get permission and approval for what they need, the developer might have the problem fixed for real. 😛
Me, I'm heading down the path of nuking the server completely. But I'm in the wonderful world of being able to rebuild and redeploy a server with just a couple of Powershell scripts. 🙂
Thomas Rushton
blog: https://thelonedba.wordpress.com
Viewing 15 posts - 51,571 through 51,585 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply