Viewing 15 posts - 2,371 through 2,385 (of 2,883 total)
July 20, 2017 at 10:38 am
One more thing that I don't understand is - if I remove the column
July 20, 2017 at 10:02 am
It is free and works for most things. Anybody who has worked with a 2012 SSIS catalog (possibly 2014 and 2016 as well... I did not test those) has probably...
July 20, 2017 at 9:10 am
July 19, 2017 at 2:36 pm
Not to be mean, but if you can't adjust the query and you can't de-duplicate the data, what do the developers think you can do?
The only other option...
July 19, 2017 at 11:10 am
Looking at the execution plan, the slowness appears to be caused by the sorting which is due to the DISTINCT.
It looks like you have a LOT of duplicate...
July 19, 2017 at 10:30 am
1 - My education is some university, no degree. Plus I got my MTA in database fundamentals. Experience is 7 years as a database administrator and current position database administrator
July 18, 2017 at 3:42 pm
Ok, if you need to sum those up, you would want something more like:SELECT TOP 1 passenger_name, fare + commission + gst AS total_cost
FROM ##invoice
WHERE...
July 18, 2017 at 2:55 pm
It might just be me, but I think you are making this more complicated than it needs to be.
The way I would do it would be to have...
July 18, 2017 at 2:35 pm
I can answer some questions too. I'm kind of like Danny_Dba though in that there are some questions I wont' be able to answer.
I have been a DBA...
July 18, 2017 at 12:02 pm
I had not read that, but it was a fun read. I do...
July 17, 2017 at 2:18 pm
July 17, 2017 at 11:22 am
Offhand, I am not entirely sure. Mark would be a better one to ask, but looking at his code, I'm not sure there is a nice way to match that...
July 17, 2017 at 8:38 am
Viewing 15 posts - 2,371 through 2,385 (of 2,883 total)