All Questions
3 questions
0
votes
1
answer
206
views
Different performance of SQL Server instances on same server
I have 4 development SQL Server 2016 instances on a virtual server (128 GB, 12 virtual processors). Each instance is configured the same (16 GB memory, automatic processor and I/O affinity masks). ...
- 63
13
votes
2
answers
2k
views
SELECT TOP 1 harms query performance; is there a dba-accessible way to overcome this?
In a production application (C# talking to SQL Server 2014 Standard) there's a query that looks like this, below. Most of the time it runs in milliseconds. But occasionally (for certain values of @Id),...
- 583
4
votes
1
answer
1k
views
Need help with long running query
UPDATE: Adding a clustered index to each work table covering all fields reduced the query run times to su-bsecond. I consider this question closed.
Thanks for taking the time to read this post - it'...
- 387