User Erik Darling

0 votes

MS SQL Server shared hosting resources

answered 8 mins ago

2 votes

Why can SQL Server not perform a TOP N SORT between an Index Seek and the Key Lookup?

answered yesterday

4 votes

In SQL Server, if I have two otherwise identical stored procedures with different names, will they use the same execution plan?

answered Sep 25 at 21:07

2 votes

Capturing Blocked Process Report via Extended Events

answered Sep 25 at 19:38

2 votes

Accepted

Performance tuning of SQL Server query, with LEFT OUTER JOIN vs INNER JOIN

answered Sep 18 at 15:47

5 votes

Getting a SORT operator when I have an index

answered Sep 11 at 17:53

2 votes

Accepted

Calculate total_worker_time in minutes

answered Aug 28 at 18:30

1 vote

How to optimise a query with inner join and order by

answered Aug 23 at 18:59

0 votes

needle in a stored procedure haystack

answered Aug 18 at 18:03

3 votes

How to improve shrinking process for 1.5TB in SQL server

answered Aug 12 at 14:22

7 votes

Accepted

Optimizing SQL Server Query When Joining Tables on DATETIME column

answered Aug 8 at 13:45

3 votes

What is the optimal way to handle literals that are referenced in NOT IN clauses of many queries within a Stored Procedure?

answered Jul 10 at 20:07

3 votes

Accepted

How to cause a SQL Server database integrity error

answered Jun 30 at 13:20

3 votes

Help with SQL Schedulers Offline

answered Jun 30 at 13:17

3 votes

Joining two SELECT queries are not joining into a new table

answered Jun 3 at 22:43

2 votes

sys.indexes contains a row per index or heap of a tabular object - what does it mean?

answered Jun 3 at 17:42

3 votes

Accepted

How to remove or disable SQL Telemetry (sqlceip)

answered Jun 3 at 16:06

4 votes

Accepted

Is there any assessment tool for SQL Server, something like orachk for Oracle Database?

answered May 29 at 16:54

4 votes

Accepted

SQL server chooses hash match over merge join but the input fields to join should be sorted

answered May 23 at 16:43

3 votes

Accepted

Find how much memory is actually used by a stored procedure

answered May 4 at 19:35

6 votes

Accepted

How to gather Index usage information

answered Apr 26 at 16:32

4 votes

How can I trace unknown high CPU usage on SQL Server?

answered Apr 22 at 14:02

6 votes

How can I optimize the stored procedure and reduce table scans?

answered Apr 18 at 14:32

4 votes

Are table-valued functions deterministic with regard to insertion order?

answered Apr 17 at 22:37

2 votes

Issue with displaying Results to Grid, despite selecting the option

answered Apr 8 at 18:12

7 votes

Accepted

Is there a way to disable logging / backups for view indexes?

answered Apr 4 at 0:50

4 votes

Significance of Historical waits report in SQL server Performance dashboard

answered Apr 1 at 13:33

8 votes

What is the stride of a GAM interval

answered Mar 30 at 17:48

3 votes

merge or delete then insert or delete then append when the database is unstable

answered Mar 26 at 20:41

0 votes

How to define text qualifier in BCP in

answered Mar 24 at 15:10

Stack Exchange Network

553 Answers

MS SQL Server shared hosting resources

Why can SQL Server not perform a TOP N SORT between an Index Seek and the Key Lookup?

In SQL Server, if I have two otherwise identical stored procedures with different names, will they use the same execution plan?

Capturing Blocked Process Report via Extended Events

Performance tuning of SQL Server query, with LEFT OUTER JOIN vs INNER JOIN

Getting a SORT operator when I have an index

Calculate total_worker_time in minutes

How to optimise a query with inner join and order by

needle in a stored procedure haystack

How to improve shrinking process for 1.5TB in SQL server

Optimizing SQL Server Query When Joining Tables on DATETIME column

What is the optimal way to handle literals that are referenced in NOT IN clauses of many queries within a Stored Procedure?

How to cause a SQL Server database integrity error

Help with SQL Schedulers Offline

Joining two SELECT queries are not joining into a new table

sys.indexes contains a row per index or heap of a tabular object - what does it mean?

How to remove or disable SQL Telemetry (sqlceip)

Is there any assessment tool for SQL Server, something like orachk for Oracle Database?

SQL server chooses hash match over merge join but the input fields to join should be sorted

Find how much memory is actually used by a stored procedure

How to gather Index usage information

How can I trace unknown high CPU usage on SQL Server?

How can I optimize the stored procedure and reduce table scans?

Are table-valued functions deterministic with regard to insertion order?

Issue with displaying Results to Grid, despite selecting the option

Is there a way to disable logging / backups for view indexes?

Significance of Historical waits report in SQL server Performance dashboard

What is the stride of a GAM interval

merge or delete then insert or delete then append when the database is unstable

How to define text qualifier in BCP in