Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
SE1986's user avatar
SE1986's user avatar
SE1986's user avatar
SE1986
  • Member for 6 years, 8 months
  • Last seen this week
  • UK
13 votes
2 answers
983 views

Creating an Index that is not used by a (SELECT) query reduces performance of that query

10 votes
0 answers
370 views

Has SQL Server not Killed a Deadlock? [closed]

10 votes
1 answer
3k views

Is it possible for SQL Server to grant more memory to a query than is available to the instance

9 votes
1 answer
1k views

What Happens to dirty pages if the system fails before the next checkpoint?

9 votes
1 answer
10k views

SQL Server Service does not start automatically after system restart

8 votes
3 answers
2k views

sp_msforeach db - Why do we need to use the USE keyword

8 votes
1 answer
7k views

Purpose of SQL Server Application Roles

8 votes
1 answer
2k views

Unfamiliar syntax - Query with Parameters in Braces at the beggining

8 votes
4 answers
31k views

Why Can't I shrink log file in full recovery mode [duplicate]

7 votes
1 answer
2k views

When do _WA_Sys_ statistics Get Updated?

7 votes
2 answers
8k views

Run Powershell Script From Agent As Administrator

7 votes
1 answer
186 views

SQL Server Primary Key Column Statistics Histogram Suggests Duplicate Values

7 votes
1 answer
400 views

Why does an inequality search on an indexed column give constant scans

6 votes
1 answer
298 views

Query Store plan force fails with NO_PLAN dependent on where filter operator is in plan

6 votes
1 answer
664 views

Deadlock Graph - Surviving Statement inputbuf does not show the object that was locked

6 votes
1 answer
3k views

Bitmap Creation in Execution Plan Causes bad Estimate on Clustered Index Scan

6 votes
1 answer
1k views

View with SentryOne Plan Explorer from SSMS context menu doesn't work if Plan Explorer is already open

6 votes
1 answer
1k views

sp_WhoIsActive vs sp_BlitzFirst @ExpertMode = 1

5 votes
1 answer
206 views

Single Predicate Check Constraint Gives Constant Scan but Two Predicate Constraint does not

4 votes
1 answer
269 views

How does SQL estimate the number of rows in a less than < Predicate

4 votes
1 answer
2k views

How to determine the cost of index creation?

4 votes
1 answer
5k views

Implicit Conversion of VARCHAR Column to NVARCHAR does not cause expected table scan

4 votes
1 answer
852 views

SET SINGLE_USER WITH ROLLBACK IMMEDIATE only disconnects sessions when account is a database user

4 votes
1 answer
508 views

Changing SET options within cursor - Different behavior based on compatibility level

4 votes
4 answers
2k views

Why are [Seemingly] suitable indexes not used on a LEFT JOIN with OR

4 votes
1 answer
662 views

Cursoring over sys.databases skips databases

3 votes
1 answer
523 views

Powershell SMO changing database context from master when setting database to SINGLE_USER

3 votes
1 answer
304 views

What Method / Formula does a Nested Loops Operator use for row estimation?

3 votes
3 answers
3k views

Slow Parallel SQL Server query, almost instant in serial

3 votes
1 answer
412 views

Troubleshooting a slow performing encrypted stored procedure