User Alexei

7

18

votes

6

answers

3k

views

What can be the downside of always having a single integer column as primary key?

May 7 at 19:20 Aaron Bertrand 170k

13

votes

2

answers

1k

views

Is there an efficient way to see the cause for “String or binary data would be truncated”?

sql-server sql-server-2017 string

Jan 28 '20 at 12:18 Tom V 15.3k

4

12

votes

3

answers

8k

views

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

sql-server sql-server-2014 execution-plan bulk-insert

May 8 at 4:45 Community♦ 1

6

votes

1

answer

188

views

Is there any side effect if select statements are wrapped in BEGIN TRAN … COMMIT?

sql-server sql-server-2016 select transaction

Aug 7 at 16:08 Josh Darnell 23.4k

5

votes

3

answers

1k

views

How to reduce identity values to avoid integer overflow?

sql-server sql-server-2014 identity

Apr 6 '17 at 2:50 Community♦ 1

4

votes

1

answer

396

views

Is there a way to catch a dbcc checkident command

sql-server sql-server-2012 identity dbcc

Feb 22 '17 at 10:41 Community♦ 1

1

4

votes

1

answer

636

views

How to handle uniqueness of many large columns in SQL Server?

sql-server sql-server-2014 unique-constraint

Feb 13 '17 at 20:34 Community♦ 1

1

4

votes

3

answers

3k

views

Injecting connection context information using a persistent table

sql-server connections

Apr 11 '16 at 5:46 Community♦ 1

1

3

votes

2

answers

4k

views

Can SQL Server be configured to not silently truncate VARCHAR values?

sql-server sql-server-2014

Jan 11 '18 at 15:04 Community♦ 1

3

votes

2

answers

344

views

Database file …_log has a max file size set to x MB. If it runs out of space, the database will stop working

sql-server sql-server-2014 transaction-log sp-blitz

Dec 29 '17 at 14:00 Alexei 1,233

2

votes

3

answers

510

views

Why does my DELETE command require huge amount of temporary run storage?

sql-server sql-server-2014 delete disk-space

Jul 17 '19 at 18:39 Paul White♦ 58.5k

1

vote

0

answers

64

views

Why SQL Server's MERGE has such a huge Excessive grant when compared to INSERT + DELETE?

sql-server performance query-performance sql-server-2017 merge

Dec 30 at 16:50 Alexei 1,233

1

vote

1

answer

84

views

Is there another source for untrusted foreign keys beside FK disable and BULK inserts?

sql-server sql-server-2014 foreign-key referential-integrity

May 7 at 21:24 Aaron Bertrand 170k

1

vote

1

answer

74

views

What is the rationale of dropping all indexes for an altered view in SQL Server?

sql-server index view materialized-view

Mar 3 at 14:58 Josh Darnell 23.4k

1

vote

2

answers

971

views

Is it bad to shrink + reindex after removing a significant part of data?

sql-server index shrink sql-server-2017

May 29 '18 at 18:19 Del Lee 173

1

vote

2

answers

164

views

Is there a way to limit log file usage for a transaction in SQL Server?

sql-server sql-server-2014 logs

Feb 2 '18 at 15:17 Alexei 1,233

1

vote

1

answer

57

views

Scalability assessment for a simple auditing system based on an ORM

performance sql-server-2014 scalability orm query-performance

Jan 30 '17 at 15:47 Community♦ 1

1

vote

2

answers

685

views

Database logging optimization and maintenance in SQL Server

sql-server sql-server-2012 performance logging

Apr 25 '16 at 11:41 Paul White♦ 58.5k

0

votes

3

answers

142

views

How to efficiently recompute the data in a rather large X table?

sql-server performance database-design sql-server-2017

Oct 5 at 11:26 KumarHarsh 1,536

0

votes

0

answers

34

views

How to write a complex logic in SQL that should work two main cases (unfiltered and filtered by one dimension)?

sql-server performance stored-procedures sql-server-2017

Oct 3 at 12:12 Alexei 1,233

0

votes

1

answer

687

views

Generic stored procedure for results sets comparison

sql-server sql-server-2012 performance performance-testing

Jan 30 '16 at 7:27 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

21 Questions

What can be the downside of always having a single integer column as primary key?

Is there an efficient way to see the cause for “String or binary data would be truncated”?

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

Is there any side effect if select statements are wrapped in BEGIN TRAN … COMMIT?

How to reduce identity values to avoid integer overflow?

Is there a way to catch a dbcc checkident command

How to handle uniqueness of many large columns in SQL Server?

Injecting connection context information using a persistent table

Can SQL Server be configured to not silently truncate VARCHAR values?

Database file …_log has a max file size set to x MB. If it runs out of space, the database will stop working

Why does my DELETE command require huge amount of temporary run storage?

Why SQL Server's MERGE has such a huge Excessive grant when compared to INSERT + DELETE?

Is there another source for untrusted foreign keys beside FK disable and BULK inserts?

What is the rationale of dropping all indexes for an altered view in SQL Server?

Is it bad to shrink + reindex after removing a significant part of data?

Is there a way to limit log file usage for a transaction in SQL Server?

Scalability assessment for a simple auditing system based on an ORM

Database logging optimization and maintenance in SQL Server

How to efficiently recompute the data in a rather large X table?

How to write a complex logic in SQL that should work two main cases (unfiltered and filtered by one dimension)?

Generic stored procedure for results sets comparison