User TheGameiswar

21

votes

1

answer

4k

views

Hash keys probe and residual

Mar 18 '19 at 22:29 Community♦ 1

3

17

votes

3

answers

7k

views

Wrapping query in IF EXISTS makes it very slow

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

Jul 3 '19 at 16:57 Community♦ 1

2

11

votes

3

answers

870

views

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

sql-server performance execution-plan

May 7 at 20:22 Aaron Bertrand 170k

1

8

votes

1

answer

870

views

Set statistics I/O for nested loops

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

Jul 24 '18 at 9:19 Paul White♦ 58.5k

2

8

votes

1

answer

2k

views

What is BMK Operator in SQLServer

sql-server execution-plan operator

Jul 26 '16 at 15:10 Community♦ 1

2

7

votes

2

answers

91k

views

Transaction log full due to log_backup

sql-server transaction-log

Apr 20 at 4:35 Community♦ 1

3

6

votes

2

answers

14k

views

SQL Server thread status

sql-server

Sep 20 '17 at 5:12 Balu 1

5

6

votes

2

answers

18k

views

Restore .Bak file to different Server

sql-server backup

Mar 7 '16 at 16:56 Kin Shah 59.4k

5

votes

3

answers

2k

views

Invoke SQLCMD doesn't work when used with xp_cmdshell

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

May 31 '18 at 19:47 Peter Vandivier 3,474

5

votes

1

answer

7k

views

Can SQL Server use multiple indexes for the same query?

sql-server index performance query-performance

Oct 5 '17 at 13:05 Community♦ 1

5

votes

1

answer

2k

views

Query shows sort cost,even when required index is available

sql-server performance optimization query-performance

Apr 20 '17 at 5:01 Community♦ 1

2

5

votes

1

answer

693

views

Understanding below execution plan

sql-server execution-plan

Apr 20 '15 at 7:41 Paul White♦ 58.5k

2

4

votes

1

answer

1k

views

SQLAZURE Resource limitations-Max concurrent sessions

sql-server azure-sql-database

Apr 11 '18 at 1:38 Community♦ 1

3

votes

1

answer

115

views

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

sql-server wait-types

Aug 28 at 10:52 TheGameiswar 2,779

3

votes

1

answer

566

views

Having hard time understanding expressions in below query plan

sql-server execution-plan sql-server-2016

Nov 19 '18 at 13:48 Paul White♦ 58.5k

3

votes

0

answers

29

views

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

sql-server powershell sql-server-2012

May 16 '18 at 13:30 TheGameiswar 2,779

3

votes

1

answer

760

views

SQL server Memory components

sql-server-2012 memory

Sep 22 '15 at 18:26 Community♦ 1

1

3

votes

1

answer

4k

views

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

sql-server powershell sqlcmd

Jul 30 '14 at 14:59 Community♦ 1

2

votes

2

answers

246

views

Can we reduce row lock contention on an index

sql-server locking blocking

Jul 1 at 21:01 Mo64 1,120

2

votes

1

answer

394

views

session id null in sys.dm_os_tasks

sql-server

Apr 19 '17 at 20:58 user1707012 21

2

votes

1

answer

168

views

Object_name(object_id) returning incorrect results

sql-server t-sql

Jul 11 '16 at 9:00 Philᵀᴹ 29.5k

2

votes

1

answer

74

views

Index fragementation ? is it unavoidable

sql-server index fragmentation

May 26 '15 at 3:23 Community♦ 1

1

2

votes

1

answer

528

views

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

sql-server ssis-2012

Mar 21 '15 at 3:07 Community♦ 1

2

votes

1

answer

2k

views

Index rebuild log growth

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

Jan 3 '15 at 6:03 Paul White♦ 58.5k

2

votes

2

answers

2k

views

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

sql-server transactional-replication dbcc

Jan 8 '14 at 9:24 Edward Dortland 2,685

1

vote

0

answers

127

views

Can not run Sys.dm_exec_requests during backup restore

sql-server backup restore dmv

Feb 11 '20 at 13:37 TheGameiswar 2,779

1

vote

1

answer

2k

views

Changing Schema ownership and side effects

sql-server schema role

Oct 10 '19 at 22:03 Community♦ 1

1

vote

0

answers

138

views

Random MSDTC errors

sql-server

Jan 10 '19 at 17:34 TheGameiswar 2,779

1

vote

1

answer

437

views

Strange Issue with Linked server and using IF exists

sql-server

Jun 10 '18 at 14:41 TheGameiswar 2,779

1

vote

1

answer

845

views

Delete from table with(snapshot)

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

Jan 6 '17 at 13:50 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

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

Set statistics I/O for nested loops

What is BMK Operator in SQLServer

Transaction log full due to log_backup

SQL Server thread status

Restore .Bak file to different Server

Invoke SQLCMD doesn't work when used with xp_cmdshell

Can SQL Server use multiple indexes for the same query?

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?

Having hard time understanding expressions in below query plan

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

SQL server Memory components

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

Can we reduce row lock contention on an index

session id null in sys.dm_os_tasks

Object_name(object_id) returning incorrect results

Index fragementation ? is it unavoidable

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

Index rebuild log growth

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

Can not run Sys.dm_exec_requests during backup restore

Changing Schema ownership and side effects

Random MSDTC errors

Strange Issue with Linked server and using IF exists

Delete from table with(snapshot)