User crokusek

8 votes

Best practice between using LEFT JOIN or NOT EXISTS

answered Nov 14, 2015 at 1:46

8 votes

Accepted

Read system_health event_file instead of ring_buffer for deadlocks extended events

answered Jul 31, 2017 at 21:38

5 votes

Deadlock error isn't returning the deadlock SQL

answered Jul 31, 2017 at 21:58

5 votes

How can row estimates be improved in order to reduce chances of spills to tempdb

answered Nov 7, 2013 at 5:27

4 votes

Documenting a giant web of inter-related stored procedures in an MS SQL database: What tool or format?

answered Aug 4, 2012 at 7:37

4 votes

FOR XML could not serialize the data because it contains character (0x0000)

answered Jul 1, 2019 at 18:11

3 votes

Primary key vs. unique index: performance difference with foreign keys?

answered Jul 7, 2012 at 2:19

2 votes

When should a primary key be declared non-clustered?

answered Apr 16, 2013 at 22:44

2 votes

Are SQL Server in-place upgrades as ill advised as they used to be?

answered Dec 18, 2015 at 4:25

2 votes

Greyed out menu options, broken activity monitor

answered Jan 5, 2017 at 0:02

2 votes

SQL NULL Value to = A Sequential Number, Help!

answered Jun 16, 2012 at 7:55

2 votes

Insert Into table Exec SP with bad performance

answered Aug 30, 2021 at 23:00

1 vote

Bulk Insert Through Network

answered Apr 16 at 1:04

1 vote

Effiiency of multiple OR predicates versus a single range

answered Aug 1, 2015 at 3:24

1 vote

How to improve row estimate of 1 row in join for newly inserted data

answered Apr 28, 2014 at 22:53

1 vote

best practice for 'staging' relation in stored procedure: use temp table, or view?

answered Apr 30, 2014 at 21:56

1 vote

How to improve estimate of 1 row in a View constrained by DateAdd() against an index

answered Apr 9, 2016 at 0:23

1 vote

Slow Performance Inserting Few Rows Into Huge Table

answered Jul 31, 2012 at 5:47

0 votes

Accepted

c# Backup sql server database, error Operating system error 5(Access is denied.)

answered Jan 27, 2014 at 21:39

0 votes

How to improve TempDb on RAMDisk showing performance on par with physical hard drive

answered Aug 3, 2013 at 2:23

0 votes

Map a Login to a User that was Created Without Mapping to a Login

answered Apr 5, 2016 at 1:24

0 votes

Faster alternative to scalar UDF with recursion to walk tree hierarchy?

answered Oct 13, 2018 at 0:15

-1 votes

If a Parallelism Exchange Event deadlock is victim-less, is it a problem?

answered Sep 24, 2018 at 19:27

-2 votes

Why does ORDER BY not belong in a View?

answered Jul 23, 2014 at 23:15

-7 votes

How to optimise T-SQL query using Execution Plan

answered Aug 3, 2013 at 6:11

Stack Exchange Network

25 Answers

Best practice between using LEFT JOIN or NOT EXISTS

Read system_health event_file instead of ring_buffer for deadlocks extended events

Deadlock error isn't returning the deadlock SQL

How can row estimates be improved in order to reduce chances of spills to tempdb

Documenting a giant web of inter-related stored procedures in an MS SQL database: What tool or format?

FOR XML could not serialize the data because it contains character (0x0000)

Primary key vs. unique index: performance difference with foreign keys?

When should a primary key be declared non-clustered?

Are SQL Server in-place upgrades as ill advised as they used to be?

Greyed out menu options, broken activity monitor

SQL NULL Value to = A Sequential Number, Help!

Insert Into table Exec SP with bad performance

Bulk Insert Through Network

Effiiency of multiple OR predicates versus a single range

How to improve row estimate of 1 row in join for newly inserted data

best practice for 'staging' relation in stored procedure: use temp table, or view?

How to improve estimate of 1 row in a View constrained by DateAdd() against an index

Slow Performance Inserting Few Rows Into Huge Table

c# Backup sql server database, error Operating system error 5(Access is denied.)

How to improve TempDb on RAMDisk showing performance on par with physical hard drive

Map a Login to a User that was Created Without Mapping to a Login

Faster alternative to scalar UDF with recursion to walk tree hierarchy?

If a Parallelism Exchange Event deadlock is victim-less, is it a problem?

Why does ORDER BY not belong in a View?

How to optimise T-SQL query using Execution Plan