User user9516827

8

14

votes

4

answers

60k

views

Memory Usage by SQL Server

Mar 8 at 9:25 Shanky 17.5k

4

votes

1

answer

5k

views

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

sql-server sql-server-agent jobs

Aug 28 '18 at 21:39 Erik Darling 31k

3

votes

1

answer

3k

views

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

performance query-performance sql-server-2016 parallelism

Oct 28 at 17:25 Hannah Vernon♦ 64.3k

0

votes

1

answer

2k

views

Cannot open database “dbname” requested by login.The login failed.Login failed for user 'DOMAIN\Windowsusername'

sql-server sql-server-2016 users logins

Apr 7 '19 at 1:28 user9516827 1,227

2

votes

1

answer

2k

views

Connection pool Error

sql-server transaction connection-pooling timeout

Oct 3 '18 at 13:13 David Browne - Microsoft 32.4k

1

0

votes

1

answer

1k

views

Costly HASH MATCH Aggregate

sql-server performance join optimization execution-plan query-performance

Apr 17 at 9:39 Community♦ 1

3

votes

1

answer

1k

views

Memory Pressure in SQL Server - Enable LPIM or not?

sql-server sql-server-2016 memory performance performance-tuning

Nov 5 '18 at 7:59 Community♦ 1

-1

votes

1

answer

1k

views

Reducing .mdf file size

sql-server configuration disk-space shrink filegroups

Dec 29 at 4:14 Ariwibawa 101

1

5

votes

2

answers

977

views

DBCC SHRINKFILE on the distribution database

sql-server replication transactional-replication shrink

Jun 12 '19 at 14:56 Ramakant Dadhichi 2,138

0

votes

1

answer

924

views

Unable to Create new Maintenance plan in SSMS 2017

sql-server ssms installation maintenance-plans

Nov 20 at 7:03 Community♦ 1

3

votes

1

answer

921

views

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

sql-server performance execution-plan memory-grant query-performance

Sep 18 '19 at 18:49 Community♦ 1

1

4

votes

1

answer

911

views

Execution time high for Query in sp_executesql

sql-server performance execution-plan dynamic-sql query-performance

Jun 21 '18 at 14:33 Community♦ 1

0

votes

1

answer

785

views

DBCC INPUTBUFFER shows Event Type as Language Event for an unused Database

sql-server sql-server-2016 dbcc session

Apr 5 '19 at 20:16 Aaron Bertrand 171k

0

votes

3

answers

758

views

Delete queries blocks other concurrent transactions

sql-server sql-server-2016 locking deadlock delete

Jul 4 '19 at 4:17 Dale Anderson 101

1

vote

3

answers

710

views

Create Synonym error for a user-SQL Server

sql-server permissions schema synonyms

Aug 10 '19 at 12:17 Dan Guzman 21.4k

1

vote

1

answer

668

views

Debug Connection Pool Error

sql-server performance connection-pooling performance-tuning query-performance

Feb 7 '19 at 21:09 Community♦ 1

1

vote

1

answer

665

views

Slow Query with RESOURCE_SEMAPHORE wait info [closed]

sql-server memory wait-types plan-cache

Oct 23 '18 at 15:12 user9516827 1,227

2

votes

0

answers

646

views

SQL Buffer Pool and Plan cache

sql-server-2016 dynamic-sql plan-cache buffer-pool

Jul 24 '18 at 20:59 user9516827 1,227

3

votes

1

answer

618

views

Identify Query Waiting on resources

sql-server performance parallelism blocking waits performance-tuning

Mar 8 '19 at 16:51 Community♦ 1

0

votes

1

answer

615

views

Same session ID(with same SQL text) but 3 different connection ids

sql-server query-performance performance-tuning connections session

Jan 8 '20 at 21:00 Josh Darnell 24.6k

0

votes

0

answers

580

views

Transactional Replication : Issues with Identity Column in Subscriber

sql-server replication insert transactional-replication identity

Aug 3 '19 at 13:05 user9516827 1,227

10

votes

3

answers

526

views

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

sql-server performance parallelism functions performance-tuning query-performance

Apr 19 '19 at 18:33 Community♦ 1

1

vote

0

answers

501

views

Scalar function with while loop to TVF

sql-server performance set-returning-functions query-performance

Jun 27 '18 at 21:58 Community♦ 1

1

vote

2

answers

448

views

Transaction Replication:Intialize from Backup

sql-server replication transactional-replication

Aug 1 '18 at 17:44 user9516827 1,227

1

vote

1

answer

431

views

Poor performance by LINQ to SQL generated query execution plan

sql-server execution-plan performance sort-operator performance-tuning query-performance

Jun 14 '18 at 22:07 Community♦ 1

1

7

votes

1

answer

428

views

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

sql-server ola-hallengren fragmentation index-maintenance

Aug 6 '19 at 13:58 vijayakumar P 1

2

votes

3

answers

411

views

Serial Plan in plan cache

sql-server performance optimization parallelism plan-cache query-performance

Jul 18 '18 at 10:36 Community♦ 1

1

vote

1

answer

410

views

SQL Queries Slow in the Upgraded environment

sql-server execution-plan index-tuning performance performance-tuning query-performance

Jun 11 '18 at 14:58 Community♦ 1

1

vote

2

answers

381

views

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

sql-server backup dbcc-checkdb process

Jun 21 '18 at 18:32 Shaulinator 2,876

2

1

vote

1

answer

374

views

Inserting few millions of rows: Does indexing happens along with the insert operation

sql-server index update bulk-insert

Jul 20 '19 at 11:38 Chessbrain 729

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

75 Questions

Memory Usage by SQL Server

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

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

Cannot open database “dbname” requested by login.The login failed.Login failed for user 'DOMAIN\Windowsusername'

Connection pool Error

Costly HASH MATCH Aggregate

Memory Pressure in SQL Server - Enable LPIM or not?

Reducing .mdf file size

DBCC SHRINKFILE on the distribution database

Unable to Create new Maintenance plan in SSMS 2017

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

Execution time high for Query in sp_executesql

DBCC INPUTBUFFER shows Event Type as Language Event for an unused Database

Delete queries blocks other concurrent transactions

Create Synonym error for a user-SQL Server

Debug Connection Pool Error

Slow Query with RESOURCE_SEMAPHORE wait info [closed]

SQL Buffer Pool and Plan cache

Identify Query Waiting on resources

Same session ID(with same SQL text) but 3 different connection ids

Transactional Replication : Issues with Identity Column in Subscriber

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

Scalar function with while loop to TVF

Transaction Replication:Intialize from Backup

Poor performance by LINQ to SQL generated query execution plan

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

Serial Plan in plan cache

SQL Queries Slow in the Upgraded environment

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

Inserting few millions of rows: Does indexing happens along with the insert operation