user9516827's user avatar
user9516827's user avatar
user9516827's user avatar
user9516827
  • Member for 5 years, 6 months
  • Last seen more than 1 year ago
15 votes
4 answers
99k views

Memory Usage by SQL Server

10 votes
3 answers
1k views

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

8 votes
1 answer
827 views

Index fragmentation problem after disabling page-level locking for an Index

6 votes
1 answer
12k views

INSERT failed in SQL Job because of incorrect SET options 'QUOTED_IDENTIFIER'

5 votes
2 answers
2k views

DBCC SHRINKFILE on the distribution database

4 votes
1 answer
265 views

Huge Heap Table and table compression on SQL Server 2016

4 votes
1 answer
1k views

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

4 votes
1 answer
2k views

Execution time high for Query in sp_executesql

3 votes
1 answer
2k views

Memory Pressure in SQL Server - Enable LPIM or not?

3 votes
1 answer
1k views

Identify Query Waiting on resources

3 votes
1 answer
5k views

Query runs in parallel but it is showing as blocked by itself

2 votes
1 answer
1k views

User connections without a login

2 votes
1 answer
80 views

Does enabling LPIM work even if the memory pressure is coming from SQL Server itself

2 votes
2 answers
205 views

Failover strategy for SQL Server 2016 Standard Edition

2 votes
1 answer
449 views

Using Resource Governor and allocate more memory to satisfy high Memory Grant request by queries?

2 votes
1 answer
3k views

Connection pool Error

2 votes
0 answers
255 views

SORT(DISTINCT) :Is it because of Kitchen sink queries?

2 votes
0 answers
881 views

SQL Buffer Pool and Plan cache

2 votes
3 answers
506 views

Serial Plan in plan cache

2 votes
0 answers
415 views

Plan Guide for the LINQ-SQL Query

2 votes
2 answers
674 views

Does Query Plan cache gets cleared by itself?

2 votes
0 answers
133 views

Plan cache mystery

1 vote
0 answers
279 views

Cannot find query in plan cache and query execution times different for different paramters

1 vote
2 answers
498 views

Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server

1 vote
1 answer
666 views

Poor performance by LINQ to SQL generated query execution plan

1 vote
1 answer
974 views

Slow Query with RESOURCE_SEMAPHORE wait info [closed]

1 vote
0 answers
189 views

Used a CAST function ,still IMPLICIT Conversion warning in Execution Plan

1 vote
2 answers
101 views

Functions causing Serial plan.What to use instead? [closed]

1 vote
1 answer
749 views

SQL Queries Slow in the Upgraded environment

1 vote
0 answers
683 views

Scalar function with while loop to TVF