Skip to main content
crokusek's user avatar
crokusek's user avatar
crokusek's user avatar
crokusek
  • Member for 12 years
  • Last seen more than a month ago
8 votes

Best practice between using LEFT JOIN or NOT EXISTS

8 votes
Accepted

Read system_health event_file instead of ring_buffer for deadlocks extended events

5 votes

Deadlock error isn't returning the deadlock SQL

5 votes

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

4 votes

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

4 votes

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

3 votes

SQL NULL Value to = A Sequential Number, Help!

3 votes

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

2 votes

When should a primary key be declared non-clustered?

2 votes

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

2 votes

Insert Into table Exec SP with bad performance

2 votes

Greyed out menu options, broken activity monitor

1 vote

Bulk Insert Through Network

1 vote

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

1 vote

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

1 vote

Effiiency of multiple OR predicates versus a single range

1 vote

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

1 vote

Slow Performance Inserting Few Rows Into Huge Table

0 votes
Accepted

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

0 votes

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

0 votes

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

0 votes

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

-1 votes

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

-2 votes

Why does ORDER BY not belong in a View?

-7 votes

How to optimise T-SQL query using Execution Plan