User user9516827

15 votes

4 answers

99k views

Memory Usage by SQL Server

asked Jul 23, 2018 at 22:01

10 votes

3 answers

1k views

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

asked Apr 18, 2019 at 21:26

8 votes

1 answer

827 views

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

asked Jul 12, 2019 at 14:22

6 votes

1 answer

12k views

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

asked Aug 28, 2018 at 20:51

5 votes

2 answers

2k views

DBCC SHRINKFILE on the distribution database

asked Jun 12, 2019 at 13:35

4 votes

1 answer

265 views

Huge Heap Table and table compression on SQL Server 2016

asked Jun 14, 2019 at 15:11

4 votes

1 answer

1k views

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

asked Oct 24, 2018 at 20:15

4 votes

1 answer

2k views

Execution time high for Query in sp_executesql

asked Jun 11, 2018 at 20:14

3 votes

1 answer

2k views

Memory Pressure in SQL Server - Enable LPIM or not?

asked Oct 23, 2018 at 17:19

3 votes

1 answer

1k views

Identify Query Waiting on resources

asked Jan 4, 2019 at 19:14

3 votes

1 answer

5k views

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

asked Jan 9, 2020 at 20:07

2 votes

1 answer

1k views

User connections without a login

asked Dec 5, 2019 at 15:15

2 votes

1 answer

80 views

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

asked Dec 6, 2019 at 15:44

2 votes

2 answers

205 views

Failover strategy for SQL Server 2016 Standard Edition

asked Aug 13, 2019 at 19:31

2 votes

1 answer

449 views

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

asked Oct 23, 2018 at 14:45

2 votes

1 answer

3k views

Connection pool Error

asked Oct 2, 2018 at 17:28

2 votes

0 answers

255 views

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

asked Jun 22, 2018 at 15:39

2 votes

0 answers

881 views

SQL Buffer Pool and Plan cache

asked Jul 24, 2018 at 19:51

2 votes

3 answers

506 views

Serial Plan in plan cache

asked Jul 16, 2018 at 21:23

2 votes

0 answers

415 views

Plan Guide for the LINQ-SQL Query

asked Jul 19, 2018 at 21:01

2 votes

2 answers

674 views

Does Query Plan cache gets cleared by itself?

asked Jul 20, 2018 at 15:31

2 votes

0 answers

133 views

Plan cache mystery

asked Jul 23, 2018 at 19:20

1 vote

0 answers

279 views

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

asked Jun 21, 2018 at 14:20

1 vote

2 answers

498 views

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

asked Jun 21, 2018 at 17:28

1 vote

1 answer

666 views

Poor performance by LINQ to SQL generated query execution plan

asked Jun 14, 2018 at 20:21

1 vote

1 answer

974 views

Slow Query with RESOURCE_SEMAPHORE wait info [closed]

asked Oct 18, 2018 at 16:29

1 vote

0 answers

189 views

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

asked Oct 22, 2018 at 16:16

1 vote

2 answers

101 views

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

asked Sep 28, 2018 at 19:12

1 vote

1 answer

749 views

SQL Queries Slow in the Upgraded environment

asked Jun 8, 2018 at 19:08

1 vote

0 answers

683 views

Scalar function with while loop to TVF

asked Jun 27, 2018 at 21:58

Stack Exchange Network

75 Questions

Memory Usage by SQL Server

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

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

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

DBCC SHRINKFILE on the distribution database

Huge Heap Table and table compression on SQL Server 2016

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

Execution time high for Query in sp_executesql

Memory Pressure in SQL Server - Enable LPIM or not?

Identify Query Waiting on resources

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

User connections without a login

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

Failover strategy for SQL Server 2016 Standard Edition

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

Connection pool Error

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

SQL Buffer Pool and Plan cache

Serial Plan in plan cache

Plan Guide for the LINQ-SQL Query

Does Query Plan cache gets cleared by itself?

Plan cache mystery

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

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

Poor performance by LINQ to SQL generated query execution plan

Slow Query with RESOURCE_SEMAPHORE wait info [closed]

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

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

SQL Queries Slow in the Upgraded environment

Scalar function with while loop to TVF