Viewing 15 posts - 1,711 through 1,725 (of 22,202 total)
Right. So.
You're very focused on that spill. You actually have a couple. However, they're not the core of the issue. There's a lot to unpack here. If i had to...
July 1, 2020 at 3:59 pm
Here's a formatted copy of the query for anyone who wants to look:
SELECT [Roles].[Role_ID] AS "legalRoleID",
[Roles].[UserID] AS MainUserID,
...
July 1, 2020 at 3:43 pm
As I said, why not JOIN to the original table? Embedding it as a function doesn't make sense.
July 1, 2020 at 3:39 pm
You're looking at two very different things. sql_batch_completed is for calls that come in as a batch command and have completed. rpc_starting is for calls that come in from a...
July 1, 2020 at 12:12 pm
And to see what indexes are being used and how they're being used, you want to look at the Execution Plans. The book in my link is available in digital...
July 1, 2020 at 12:06 pm
If you could zip the execution plan and post it instead of the picture, we might be able to help. All the good stuff on an execution plan is in...
July 1, 2020 at 12:05 pm
Your function is a table, not a value. You're trying to compare a value, e.ID, to a table. You can't do that. You can join to your table instead, but...
July 1, 2020 at 11:59 am
The actual plan shows the number of threads used. Counting worker threads you're seeing other artifacts from other processes, including system processes. MAXDOP limits the number of concurrent processors used...
July 1, 2020 at 11:55 am
Index use depends on the amount of data it's going to filter. Take a look at the estimated number of rows each time it's doing a scan. I'll bet you...
June 26, 2020 at 12:05 pm
Since a view is a definition of a query, but is not the actual query that is run when the view is accessed, tuning a view is quite difficult. For...
June 26, 2020 at 11:46 am
There is an Oracle specific forum. It might have people monitoring it who know more about Oracle.
June 26, 2020 at 11:39 am
So, you have 500 rows. You're adding them all with GETDATE(), then your filtering based on the todays date? Right? You realize that all 500 rows are going to have...
June 26, 2020 at 11:32 am
If you're running SQL Server 2017, Query Store is your bestest friend in the world. Enable Query Store, You'll be able to look at a given query and see how...
June 25, 2020 at 11:54 am
If you're by yourself on the server and you've recently had the database open in the Object Explorer in SSMS, say looking at tables or something, in addition to changing...
June 25, 2020 at 11:52 am
Without seeing the execution plan, the indexes and the statistics, I only have guesses.
Row estimates are off. That usually points to statistics. I know you've said you've updated them, but...
June 25, 2020 at 11:48 am
Viewing 15 posts - 1,711 through 1,725 (of 22,202 total)