Viewing 15 posts - 9,556 through 9,570 (of 59,078 total)
At this point, I'm going to suggest that you ask the 3rd party vendor that uses the query.
Also, change the WHERE clause to NOT use "<>". Instead, use...
March 27, 2019 at 9:43 pm
I am working on a system that has Business units and a Parent\Child relationship.
I...
March 27, 2019 at 2:52 pm
March 27, 2019 at 2:50 pm
March 27, 2019 at 1:36 pm
March 27, 2019 at 1:33 pm
Michael L John - Wednesday, March 27, 2019 12:40 PMMake sure you have plenty of fresh air available afterwards.
You get much...
March 27, 2019 at 1:31 pm
btw... the execution plan isn't showing "100K" rows... it's show 1.2 MILLION rows! Are you sure that you don't have an accidental many-to-many join going on here in the form...
March 27, 2019 at 1:28 pm
I'm also going to be in Colorado Springs for the SQLSaturday on April 6th. It's been on my bucket list but couldn't afford the flight money or time-wise. Figured out...
March 27, 2019 at 11:49 am
March 27, 2019 at 11:45 am
I'm thinking that there's no need to change this table despite the angst that some folks have with a heap this size. As was stated, this is an "insert only"...
March 26, 2019 at 5:53 pm
March 26, 2019 at 5:34 pm
I agree that even if you could easily limit the size of tables, you shouldn't. And looking for things after the event won't necessarily help a thing and manually monitoring...
March 26, 2019 at 4:45 pm
March 26, 2019 at 4:26 pm
Dear Communitiy,
hope you can help me solving this issue:
I have to group continuous...
March 25, 2019 at 10:21 pm
March 25, 2019 at 7:14 pm
Viewing 15 posts - 9,556 through 9,570 (of 59,078 total)