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
1 vote

Bulk Insert Through Network

2 votes

Insert Into table Exec SP with bad performance

4 votes

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

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?

5 votes

Deadlock error isn't returning the deadlock SQL

8 votes
Accepted

Read system_health event_file instead of ring_buffer for deadlocks extended events

2 votes

Greyed out menu options, broken activity monitor

1 vote

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

0 votes

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

2 votes

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

8 votes

Best practice between using LEFT JOIN or NOT EXISTS

1 vote

Effiiency of multiple OR predicates versus a single range

-2 votes

Why does ORDER BY not belong in a View?

1 vote

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

1 vote

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

0 votes
Accepted

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

5 votes

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

-7 votes

How to optimise T-SQL query using Execution Plan

0 votes

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

2 votes

When should a primary key be declared non-clustered?

4 votes

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

1 vote

Slow Performance Inserting Few Rows Into Huge Table

3 votes

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

3 votes

SQL NULL Value to = A Sequential Number, Help!