user avatar
user avatar
user avatar
TheGameiswar
  • Member for 8 years, 8 months
  • Last seen this week
21 votes
1 answer
5k views

Hash keys probe and residual

19 votes
3 answers
11k views

Wrapping query in IF EXISTS makes it very slow

11 votes
3 answers
891 views

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

10 votes
1 answer
3k views

What is BMK Operator in SQLServer

8 votes
1 answer
1k views

Set statistics I/O for nested loops

8 votes
2 answers
108k views

Transaction log full due to log_backup

6 votes
2 answers
19k views

Restore .Bak file to different Server

6 votes
2 answers
17k views

SQL Server thread status

6 votes
1 answer
8k views

Can SQL Server use multiple indexes for the same query?

5 votes
3 answers
2k views

Invoke SQLCMD doesn't work when used with xp_cmdshell

5 votes
1 answer
4k views

Query shows sort cost,even when required index is available

5 votes
1 answer
744 views

Understanding below execution plan

4 votes
1 answer
2k views

SQLAZURE Resource limitations-Max concurrent sessions

3 votes
1 answer
544 views

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

3 votes
0 answers
49 views

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

3 votes
1 answer
831 views

SQL server Memory components

3 votes
1 answer
678 views

Having hard time understanding expressions in below query plan

3 votes
1 answer
4k views

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

2 votes
2 answers
3k views

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

2 votes
1 answer
598 views

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

2 votes
1 answer
3k views

Changing Schema ownership and side effects

2 votes
1 answer
2k views

Index rebuild log growth

2 votes
1 answer
173 views

Object_name(object_id) returning incorrect results

2 votes
1 answer
80 views

Index fragementation ? is it unavoidable

2 votes
1 answer
504 views

session id null in sys.dm_os_tasks

2 votes
2 answers
621 views

Can we reduce row lock contention on an index

1 vote
1 answer
1k views

Delete from table with(snapshot)

1 vote
1 answer
615 views

Strange Issue with Linked server and using IF exists

1 vote
0 answers
189 views

Random MSDTC errors

1 vote
0 answers
214 views

Can not run Sys.dm_exec_requests during backup restore