Profile Activity

TheGameiswar

Meta user

Network profile

Reputation

2,851

2.9k
1.9k
793

2017
2018
2019
2020

Top tag

sql-server

Next privilege

3,000 Rep.

Cast close & reopen votes

Badges

Newest

Yearling

Next badge

27/30

Impact

20 posts edited

4 helpful flags

950 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

32 Questions

Views Newest Activity Votes

votes

answer

views

Hash keys probe and residual

Mar 18 '19 at 22:29 Community♦ 1

votes

answers

views

Wrapping query in IF EXISTS makes it very slow

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

Jul 3 at 16:57 Community♦ 1

votes

answers

842

views

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

sql-server performance execution-plan

Jan 15 '18 at 18:37 Aaron Bertrand♦ 164k

votes

answer

744

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 9♦ 51.3k

votes

answer

views

What is BMK Operator in SQLServer

sql-server execution-plan operator

Jul 26 '16 at 15:10 Community♦ 1

votes

answers

72k

views

Transaction log full due to log_backup

sql-server transaction-log

Aug 14 at 9:17 Mr.Brownstone 11.4k

votes

answers

12k

views

SQL Server thread status

sql-server

Sep 20 '17 at 5:12 Balu 1

votes

answers

18k

views

Restore .Bak file to different Server

sql-server backup

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

votes

answers

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 2,867

votes

answer

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

votes

answer

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

votes

answer

643

views

Understanding below execution plan

sql-server execution-plan

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

votes

answer

views

SQLAZURE Resource limitations-Max concurrent sessions

sql-server azure-sql-database

Apr 11 '18 at 1:38 Community♦ 1

votes

answer

507

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 9♦ 51.3k

votes

answers

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,851

votes

answer

724

views

SQL server Memory components

sql-server-2012 memory

Sep 22 '15 at 18:26 Community♦ 1

votes

answer

views

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

sql-server powershell sqlcmd

Jul 30 '14 at 14:59 Community♦ 1

votes

answer

338

views

session id null in sys.dm_os_tasks

sql-server

Apr 19 '17 at 20:58 user1707012 21

votes

answer

165

views

Object_name(object_id) returning incorrect results

sql-server t-sql

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

votes

answer

views

Index fragementation ? is it unavoidable

sql-server index fragmentation

May 26 '15 at 3:23 Community♦ 1

votes

answer

513

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

votes

answer

views

Index rebuild log growth

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

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

votes

answers

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,644

vote

answers

views

Can not run Sys.dm_exec_requests during backup restore

sql-server backup restore dmv

Feb 11 at 13:37 TheGameiswar 2,851

vote

answer

views

Changing Schema ownership and side effects

sql-server schema role

Oct 10 at 22:03 Community♦ 1

vote

answers

views

Random MSDTC errors

sql-server

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

vote

answer

328

views

Strange Issue with Linked server and using IF exists

sql-server

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

vote

answer

681

views

Delete from table with(snapshot)

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

Jan 6 '17 at 13:50 Paul White 9♦ 51.3k

vote

answer

views

Read transaction log records

t-sql transaction-log transaction

Mar 9 '15 at 14:11 Shanky 16.2k

votes

answers

views

Restore database stuck at 100% progress

sql-server backup restore

Feb 12 at 5:23 Priyanka 112

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

32 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

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

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)

Read transaction log records

Restore database stuck at 100% progress