user9516827
  • Member for 3 years, 7 months
  • Last seen more than a month ago
4 answers
15 votes
73k views
8 bookmarks
Memory Usage by SQL Server
3 answers
10 votes
625 views
Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode
1 answers
7 votes
527 views
1 bookmarks
Index fragmentation problem after disabling page-level locking for an Index
2 answers
5 votes
1k views
1 bookmarks
DBCC SHRINKFILE on the distribution database
1 answers
5 votes
8k views
1 bookmarks
INSERT failed in SQL Job because of incorrect SET options 'QUOTED_IDENTIFIER'
1 answers
4 votes
1k views
Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries
1 answers
4 votes
1k views
1 bookmarks
Execution time high for Query in sp_executesql
1 answers
4 votes
178 views
1 bookmarks
Huge Heap Table and table compression on SQL Server 2016
1 answers
3 votes
1k views
Memory Pressure in SQL Server - Enable LPIM or not?
1 answers
3 votes
692 views
Identify Query Waiting on resources
1 answers
3 votes
3k views
Query runs in parallel but it is showing as blocked by itself
1 answers
2 votes
440 views
1 bookmarks
User connections without a login
1 answers
2 votes
65 views
Does enabling LPIM work even if the memory pressure is coming from SQL Server itself
2 answers
2 votes
163 views
Failover strategy for SQL Server 2016 Standard Edition
0 answers
2 votes
163 views
SORT(DISTINCT) :Is it because of Kitchen sink queries?
0 answers
2 votes
709 views
SQL Buffer Pool and Plan cache
3 answers
2 votes
431 views
Serial Plan in plan cache
0 answers
2 votes
256 views
Plan Guide for the LINQ-SQL Query
2 answers
2 votes
331 views
Does Query Plan cache gets cleared by itself?
0 answers
2 votes
124 views
Plan cache mystery
1 answers
2 votes
2k views
Connection pool Error
1 answers
2 votes
392 views
Using Resource Governor and allocate more memory to satisfy high Memory Grant request by queries?
0 answers
1 votes
109 views
Used a CAST function ,still IMPLICIT Conversion warning in Execution Plan
2 answers
1 votes
78 views
Functions causing Serial plan.What to use instead?
1 answers
1 votes
559 views
SQL Queries Slow in the Upgraded environment
0 answers
1 votes
540 views
Scalar function with while loop to TVF
2 answers
1 votes
516 views
Transaction Replication:Intialize from Backup
1 answers
1 votes
144 views
Finding Serial plan from Plan cache
0 answers
1 votes
157 views
Cannot find query in plan cache and query execution times different for different paramters
2 answers
1 votes
420 views
Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server