Joe Obbish's user avatar
Joe Obbish's user avatar
Joe Obbish's user avatar
Joe Obbish
  • Member for 7 years, 6 months
  • Last seen this week
30 votes

Why does my SELECT DISTINCT TOP N query scan the entire table?

30 votes

Benefits of using WITH TABLOCK on an INSERT

29 votes
Accepted

Why is "select *" faster than "select top 500 *" in SQL Server?

28 votes
Accepted

Difference between Seek Predicate and Predicate

25 votes

varchar(255) or varchar(256)?

24 votes

Why does a subquery reduce the row estimate to 1?

21 votes
Accepted

If a VARCHAR(MAX) column is included in an index, is the entire value always stored in the index page(s)?

19 votes

What are different ways to replace ISNULL() in a WHERE clause that uses only literal values?

19 votes

Why is query choosing horrible execution plan?

18 votes
Accepted

How can I force a scalar UDF to be evaluated just once in a query?

17 votes
Accepted

SQL Server cardinality hint

17 votes
Accepted

SQL Server 2016 Bad Query Plan locks up DB once a week

17 votes
Accepted

Poor performing subquery with date comparisons

17 votes
Accepted

How does one investigate the performance of a BULK INSERT statement?

17 votes
Accepted

How are the number of Histogram steps decided in Statistics

16 votes

Fast alter column NVARCHAR(4000) to NVARCHAR(260)

16 votes

Cardinality Estimate for LIKE operator (Local Variables)

16 votes
Accepted

SQL Relationship between Subtree Cost and Performance Time

15 votes

Is there any limit for IN results in SQL Server?

15 votes
Accepted

Add columns to all tables in a database if the columns don't exist

14 votes

What happens to a query that is performed on a view?

13 votes

Why does SQL Server use a better execution plan when I inline the variable?

13 votes
Accepted

Quickest way to NULL or wipe a column

13 votes
Accepted

Does SQL Server cache calculated values in a query?

12 votes
Accepted

Does SQL Server log record uncommited operations?

12 votes

Does SQL Server allow (make visible) DDL inside a transaction to the transaction prior to commit?

12 votes

Increase speed altering column on large table to NON NULL

12 votes
Accepted

Which costing factors go into the optimizer choosing different types of spools?

12 votes

What is a scalable way to simulate HASHBYTES using a SQL CLR scalar function?

12 votes
Accepted

Adding a ROW_NUMBER() with no column to ORDER BY?

1
2 3 4 5
15