User TheGameiswar

21 votes

1 answer

5k views

Hash keys probe and residual

asked Aug 8, 2017 at 6:02

19 votes

3 answers

11k views

Wrapping query in IF EXISTS makes it very slow

sql-server sql-server-2012 performance exists query-performance

asked Dec 6, 2016 at 14:58

11 votes

3 answers

891 views

How to answer why suddenly we need indexes or query needs to be changed

sql-server performance execution-plan

asked Aug 17, 2015 at 21:54

10 votes

1 answer

3k views

What is BMK Operator in SQLServer

sql-server execution-plan operator

asked Jul 26, 2016 at 11:36

8 votes

1 answer

1k views

Set statistics I/O for nested loops

sql-server execution-plan database-internals sql-server-2016

asked Apr 2, 2016 at 14:00

8 votes

2 answers

108k views

Transaction log full due to log_backup

sql-server transaction-log

asked Aug 7, 2014 at 18:36

6 votes

2 answers

19k views

Restore .Bak file to different Server

sql-server backup

asked Feb 18, 2014 at 12:37

6 votes

2 answers

17k views

SQL Server thread status

sql-server

asked Sep 8, 2015 at 12:03

6 votes

1 answer

8k views

Can SQL Server use multiple indexes for the same query?

sql-server index performance query-performance

asked Oct 5, 2017 at 12:22

5 votes

3 answers

2k views

Invoke SQLCMD doesn't work when used with xp_cmdshell

sql-server sql-server-2012 powershell xp-cmdshell

asked May 14, 2018 at 15:07

5 votes

1 answer

4k views

Query shows sort cost,even when required index is available

sql-server performance optimization query-performance

asked Apr 20, 2017 at 3:49

5 votes

1 answer

744 views

Understanding below execution plan

sql-server execution-plan

asked Apr 9, 2015 at 8:12

4 votes

1 answer

2k views

SQLAZURE Resource limitations-Max concurrent sessions

sql-server azure-sql-database

asked Jul 25, 2017 at 10:19

3 votes

1 answer

544 views

Why do I have THREADPOOL waits even though I have threads available?

sql-server wait-types

asked Aug 15, 2020 at 16:58

3 votes

0 answers

49 views

Invoke SQLCMD doesn't work when used with xp_cmdshell [duplicate]

sql-server powershell sql-server-2012

asked May 14, 2018 at 13:42

3 votes

1 answer

831 views

SQL server Memory components

sql-server-2012 memory

asked May 9, 2015 at 16:09

3 votes

1 answer

678 views

Having hard time understanding expressions in below query plan

sql-server execution-plan sql-server-2016

asked Feb 7, 2016 at 17:51

3 votes

1 answer

4k views

How to get server cpu, memory, network usage from SQL Server

sql-server powershell sqlcmd

asked Jun 27, 2014 at 19:42

2 votes

2 answers

3k views

SQL Server Replication breaks up after doing DBCC CheckDB with Allow data loss on Primary

sql-server transactional-replication dbcc

asked Jan 7, 2014 at 14:27

2 votes

1 answer

598 views

Sql job fails when connection string is updated with port number,where as it succeeds without port number

sql-server ssis-2012

asked Jun 9, 2014 at 14:46

2 votes

1 answer

3k views

Changing Schema ownership and side effects

sql-server schema role

asked Sep 17, 2014 at 13:26

2 votes

1 answer

2k views

Index rebuild log growth

sql-server index transaction-log azure-sql-database

asked Dec 30, 2014 at 4:30

2 votes

1 answer

173 views

Object_name(object_id) returning incorrect results

sql-server t-sql

asked Jul 11, 2016 at 8:52

2 votes

1 answer

80 views

Index fragementation ? is it unavoidable

sql-server index fragmentation

asked May 26, 2015 at 2:18

2 votes

1 answer

504 views

session id null in sys.dm_os_tasks

sql-server

asked Sep 22, 2015 at 8:39

2 votes

2 answers

621 views

Can we reduce row lock contention on an index

sql-server locking blocking

asked Jun 25, 2020 at 17:13

1 vote

1 answer

1k views

Delete from table with(snapshot)

sql-server sql-server-2016 memory-optimized-tables query-store

asked Jan 3, 2017 at 13:45

1 vote

1 answer

615 views

Strange Issue with Linked server and using IF exists

sql-server

asked Jun 10, 2018 at 10:26

1 vote

0 answers

189 views

Random MSDTC errors

sql-server

asked Jan 10, 2019 at 17:34

1 vote

0 answers

214 views

Can not run Sys.dm_exec_requests during backup restore

sql-server backup restore dmv

asked Jan 19, 2020 at 7:43

Stack Exchange Network

current community

your communities

more stack exchange communities

34 Questions

Hash keys probe and residual

Wrapping query in IF EXISTS makes it very slow

How to answer why suddenly we need indexes or query needs to be changed

What is BMK Operator in SQLServer

Set statistics I/O for nested loops

Transaction log full due to log_backup

Restore .Bak file to different Server

SQL Server thread status

Can SQL Server use multiple indexes for the same query?

Invoke SQLCMD doesn't work when used with xp_cmdshell

Query shows sort cost,even when required index is available

Understanding below execution plan

SQLAZURE Resource limitations-Max concurrent sessions

Why do I have THREADPOOL waits even though I have threads available?

Invoke SQLCMD doesn't work when used with xp_cmdshell [duplicate]

SQL server Memory components

Having hard time understanding expressions in below query plan

How to get server cpu, memory, network usage from SQL Server

SQL Server Replication breaks up after doing DBCC CheckDB with Allow data loss on Primary

Sql job fails when connection string is updated with port number,where as it succeeds without port number

Changing Schema ownership and side effects

Index rebuild log growth

Object_name(object_id) returning incorrect results

Index fragementation ? is it unavoidable

session id null in sys.dm_os_tasks

Can we reduce row lock contention on an index

Delete from table with(snapshot)

Strange Issue with Linked server and using IF exists

Random MSDTC errors

Can not run Sys.dm_exec_requests during backup restore