Viewing 15 posts - 1,681 through 1,695 (of 22,202 total)
The key here is the types of queries, not simply should I throw an index on. Columnstore indexes are meant for analytical, aggregation & large scan types of queries. That's...
July 23, 2020 at 12:12 pm
I assume you've tried and the error explained that your column names are not there. You can't create a view based on ad hoc queries because the view definition needs...
July 23, 2020 at 12:08 pm
All the cost is located here: [Excel_DK].[dbo].[Excel_DK].[pk_ID] [DUFP]
The predicate is: [Excel_DK].[dbo].[Excel_DK].[PartNumber] as [DUFP].[PartNumber]=[@partNumber]
Probably need an index on that with some INCLUDE for the other returned columns.
Also, you have three different...
July 22, 2020 at 12:53 pm
Then, ever so strongly, I recommend you pursue other approaches. Partitioning almost never succeeds in improving performance. By almost never, I mean, probably, a 99% failure rate. It's purpose is...
July 22, 2020 at 11:45 am
So, have you and the business worked out your Recovery Time Objective and Recovery Point Objective? If not, go do that first. If so, test this method on a restore....
July 21, 2020 at 11:47 am
Define a role. Put the users in that role. Then GRANT SELECT to the role for the schema in question. You can also grant additional functionality to the role....
July 21, 2020 at 11:43 am
Not really. You have to rebuild the structures. This means data movement. The more data you have to move, the longer it will take.
One possibility would be to snapshot a...
July 21, 2020 at 11:39 am
Yeah, I'm not at all surprised that it installed. I just doubt it did anything during that install. It found higher versions or the same versions on all the stuff...
July 17, 2020 at 12:22 pm
Way back in the day, Brad Macgeehee did a bunch of testing around reorganize and rebuild. What he found is that the majority of the time, reorganize almost didn't do...
July 17, 2020 at 11:38 am
I like to hope for the best, but plan for the worst.
This sums it up. You're taking a risk. It'll probably be OK. But it might not be.
July 17, 2020 at 11:31 am
In terms of function, yes. They're identical. In terms of supported hardware, etc., No, they're not identical. The developer version should function perfectly as a test system in non-production environments....
July 17, 2020 at 11:28 am
Look at the execution plan. It's possible that your data crossed a threshold that changed the row counts. Maybe it used to do an index seek and now it's doing...
July 17, 2020 at 11:26 am
People do this all the time. It's relatively standard. The only real issue with it is ensuring that your network doesn't become the bottleneck instead of I/O. That's just about...
July 15, 2020 at 12:10 pm
Yep. What John says. The cumulative update is just that, an accumulation of updates, security or not, up to that point. Can you add a newer security update created after...
July 15, 2020 at 12:08 pm
OK. Have you compared the execution plans as I suggested? Yes, it could be a system or database setting. However, it could be that the query is simply getting resolved...
July 14, 2020 at 10:42 am
Viewing 15 posts - 1,681 through 1,695 (of 22,202 total)