July 10, 2014 at 8:03 am
Grant Fritchey (7/10/2014)
I get it. I'm not the brightest bulb in the box, but I can usually understand the logic of processing data most of the time. I'm utterly at a loss over here. Maybe this guy is making sense and I'm just too dense to understand. Maybe it's gibberish like it feels like. Maybe I'm tired. Could someone, nicely, try to help here?
Erm, I have seen that setup before as a part of HW.
the op is missing a lot of information on it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 10, 2014 at 10:54 am
SQLRNNR (7/10/2014)
Grant Fritchey (7/10/2014)
I get it. I'm not the brightest bulb in the box, but I can usually understand the logic of processing data most of the time. I'm utterly at a loss over here. Maybe this guy is making sense and I'm just too dense to understand. Maybe it's gibberish like it feels like. Maybe I'm tired. Could someone, nicely, try to help here?Erm, I have seen that setup before as a part of HW.
the op is missing a lot of information on it.
Well if you can give them some insight, I'm pretty sure they're in a total flounder.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 10, 2014 at 11:07 am
Grant Fritchey (7/10/2014)
SQLRNNR (7/10/2014)
Grant Fritchey (7/10/2014)
I get it. I'm not the brightest bulb in the box, but I can usually understand the logic of processing data most of the time. I'm utterly at a loss over here. Maybe this guy is making sense and I'm just too dense to understand. Maybe it's gibberish like it feels like. Maybe I'm tired. Could someone, nicely, try to help here?Erm, I have seen that setup before as a part of HW.
the op is missing a lot of information on it.
Well if you can give them some insight, I'm pretty sure they're in a total flounder.
My insight would be to go back to the prof.
Certain things like HW and exams causes pause for me.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 10, 2014 at 5:19 pm
ChrisM@Work (7/10/2014)
Koen Verbeeck (7/10/2014)
Jack Corbett (7/10/2014)
Koen Verbeeck (7/10/2014)
So I tried to endorse Jeff on LinkedIn for BCP, but somehow it doesn't work.I saw Jeff was endorsed 9 times for SSIS. That was cruel. 😀
I don't know, I bet Jeff would write better SSIS packages than a lot of people who do it full-time.:w00t:
I guess he would have just one Execute SQL Task that calls a stored procedure 😀
So would I - you wouldn't believe the cr@p SSIS tasks I've seen in the last couple of years. Gazillions of DCT's just because some oaf couldn't write decent TSQL.
There is value in that, as it's faster (usually) to transform the stream than it is to double (or more) pass on the data in the staging table doing writes. Depends on the environment and the chagne, though.
However, and this is knowing Jeff's adoration for the SSIS product, I WOULD trust him more than most I've seen code up some utter trash in SSIS. At least Jeff knows he doesn't know.
And yes, Jeff, I remember your challenge. 😀 Every example I have is tied up in NDAs and I'm still trying to find enough time to obfuscate them. The algorithm isn't NDA, it's just everything they're hooked to (multiple vendor systems).
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 10, 2014 at 6:35 pm
Ed Wagner (7/9/2014)
The part I don't get about people asking for help and then using solutions they don't understand is about support. What if something goes wrong? What happens in 2 months when a new situation comes up and they have to modify the code? What are they going to tell their boss? "Uhhh...I can't fix it. It's not my fault. Some guy on the internet did it."Granted, there are plenty of things I don't know. But I certainly wouldn't put anything I don't understand into production. After all, I'm the one who's going to be supporting it.
Trouble with that is that once one of things I didn't know was that I didn't actually understand the code I'd just written, tested, put through desk-check by a colleague and then code review, then system test, then QA tests, and then into service in-house, and then into further in-house systems and a large number of customer systems. So much so that when it started failing (after more than a year's exposure on that large number of customer sites and continuing exposure on several in-house systems, and on every system on which it had been installed it had been called many times per minute, 24 hours per day, and worked every time) and the bug report came in neither I nor anyone else could work out how that code had ever worked. Of course I fixed it - that wasn't a problem - but we never did work out how it had ever worked.
Tom
July 10, 2014 at 6:59 pm
Koen Verbeeck (7/10/2014)
Jack Corbett (7/10/2014)
Koen Verbeeck (7/10/2014)
So I tried to endorse Jeff on LinkedIn for BCP, but somehow it doesn't work.I saw Jeff was endorsed 9 times for SSIS. That was cruel. 😀
I don't know, I bet Jeff would write better SSIS packages than a lot of people who do it full-time.:w00t:
I guess he would have just one Execute SQL Task that calls a stored procedure 😀
You mean there's some other way of doing an SSIS task? :satisfied:
Tom
July 10, 2014 at 8:42 pm
Okay. Curious if the OP on anther thread is ever going to say anything. Asks for help and doesn't quite provide enough to help. Posts data and ddl after being asked. Post didn't quite look right mentioned that to the OP asking if the code had been tested. OP reposts after testing and making a change.
I don't get to work on it, but later the OP posts an answer and marks it works for op. In the same post complains about performance.
I post a new solution (outer apply) along with execution plan. Nothing.
I post another solution (left outer join) along with execution plans and creating an index after conforming data type between two columns. Nothing.
Wondering if the OP will ever say anything at this point. Also, no one (OP included) has looked at the execution plans at this time.
July 11, 2014 at 2:14 am
TomThomson (7/10/2014)Of course I fixed it - that wasn't a problem - but we never did work out how it had ever worked.
Yes, I've seen (and written) code like that before...in my case, it's usually that I come back to it and spot a glaring error which really should have broken the thing in half, but somehow it worked anyway. It's like there are reverse gremlins in the system making bad code somehow work! 😀
July 11, 2014 at 3:07 am
SQLRNNR (7/10/2014)
Grant Fritchey (7/10/2014)
SQLRNNR (7/10/2014)
Grant Fritchey (7/10/2014)
I get it. I'm not the brightest bulb in the box, but I can usually understand the logic of processing data most of the time. I'm utterly at a loss over here. Maybe this guy is making sense and I'm just too dense to understand. Maybe it's gibberish like it feels like. Maybe I'm tired. Could someone, nicely, try to help here?Erm, I have seen that setup before as a part of HW.
the op is missing a lot of information on it.
Well if you can give them some insight, I'm pretty sure they're in a total flounder.
My insight would be to go back to the prof.
Certain things like HW and exams causes pause for me.
Oh, I misunderstood. I didn't realize what HW meant. Never mind.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 11, 2014 at 6:34 am
Lynn Pettis (7/10/2014)
Okay. Curious if the OP on anther thread is ever going to say anything. Asks for help and doesn't quite provide enough to help. Posts data and ddl after being asked. Post didn't quite look right mentioned that to the OP asking if the code had been tested. OP reposts after testing and making a change.I don't get to work on it, but later the OP posts an answer and marks it works for op. In the same post complains about performance.
I post a new solution (outer apply) along with execution plan. Nothing.
I post another solution (left outer join) along with execution plans and creating an index after conforming data type between two columns. Nothing.
Wondering if the OP will ever say anything at this point. Also, no one (OP included) has looked at the execution plans at this time.
You were too slow to respond. They will cure performance by upgrading the server. :hehe:
Hope they at least look at what you suggested, and comment.
And that the next question you help with gives more personal satisfaction.
At least someone else stumbling across the thread can see there are a couple of better ways to solve a similar problem, so you are still helping others.
July 11, 2014 at 6:50 am
Oooh, vague questions for a Friday afternoon.......
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
July 11, 2014 at 8:08 am
What a way to come back from a long(-long) weekend...
The other DBA (more a developer with DBA knowledge) in trying to get a bunch of Sharepoint DBs backed up to file with the current production versions, had the backup Admin (3rd party product) restore the DBs from Prod to QA. Problem is, he (and the backup admin) both thought it would just restore the files...
So, I've spent most of yesterday and today getting the MDFs and LDFs back in the proper homes on the server. On top of that, last week we lost our Oracle DBA, so now (again) I get to pretend to be an Oracle DBA for the next couple weeks...
🙁
Even more fun, one of the DBs that was restored (not sure how this got added to the list, might've been a mis-click in the backup software) MSDB (again in QA, thankfully) was *also* restored, and to the wrong location...
So I'm holding off on moving the files for MSDB until everything else is fixed, but it needs to be done as it's now living on some temp storage that was added for a migration project...
July 11, 2014 at 8:58 am
jasona.work (7/11/2014)
What a way to come back from a long(-long) weekend...The other DBA (more a developer with DBA knowledge) in trying to get a bunch of Sharepoint DBs backed up to file with the current production versions, had the backup Admin (3rd party product) restore the DBs from Prod to QA. Problem is, he (and the backup admin) both thought it would just restore the files...
So, I've spent most of yesterday and today getting the MDFs and LDFs back in the proper homes on the server. On top of that, last week we lost our Oracle DBA, so now (again) I get to pretend to be an Oracle DBA for the next couple weeks...
🙁
Even more fun, one of the DBs that was restored (not sure how this got added to the list, might've been a mis-click in the backup software) MSDB (again in QA, thankfully) was *also* restored, and to the wrong location...
So I'm holding off on moving the files for MSDB until everything else is fixed, but it needs to be done as it's now living on some temp storage that was added for a migration project...
As yes...welcome back, Jason. I just got back from a vacation this past Monday and stepped into a really rare and insane week. Thankfully, it's Friday and almost everything is done. Hang in there...it'll get done eventually.
July 11, 2014 at 10:43 am
*sigh* Why do people post questions in the forums and then send me PMs, occasionally multiple ones notifying me of that fact?
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
July 11, 2014 at 11:14 am
GilaMonster (7/11/2014)
*sigh* Why do people post questions in the forums and then send me PMs, occasionally multiple ones notifying me of that fact?
Maybe by doing that they feel that you'll think they're special. 😉 The alternative is that they're just being rude.
Viewing 15 posts - 44,581 through 44,595 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply