Profile Activity

Alexei

Meta user

Network profile

Reputation

1,207

1.2k
654
101

2016
2017
2018
2019

Top tag

sql-server

Next privilege

2,000 Rep.

Edit questions and answers

Badges

Newest

Yearling

Next badge

198/300

Impact

32 posts edited

27 helpful flags

198 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

16 Questions

Views Newest Activity Votes

votes

answers

views

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

May 26 '17 at 0:47 Evan Carroll 41.5k

votes

answers

838

views

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

sql-server sql-server-2017 string truncation

Oct 25 '18 at 19:11 Alexei 1,207

votes

answers

views

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

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

Dec 5 at 15:21 John Zabroski 241

votes

answers

993

views

How to reduce identity values to avoid integer overflow?

sql-server sql-server-2014 identity

Apr 6 '17 at 2:50 Community♦ 1

votes

answer

316

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

votes

answer

472

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

votes

answers

views

Injecting connection context information using a persistent table

sql-server connections

Apr 11 '16 at 5:46 Community♦ 1

votes

answers

324

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,207

votes

answers

261

views

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

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

Jul 17 at 18:39 Paul White says GoFundMonica♦ 50.3k

votes

answers

views

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

sql-server sql-server-2014

Jan 11 '18 at 15:04 Alexei 1,207

vote

answers

589

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 163

vote

answers

158

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,207

vote

answer

views

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

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

Mar 9 '17 at 11:44 Community♦ 1

vote

answer

views

Scalability assessment for a simple auditing system based on an ORM

query-performance sql-server-2014 scalability orm

Jan 30 '17 at 15:47 Max Vernon 59.8k

vote

answers

523

views

Database logging optimization and maintenance in SQL Server

sql-server sql-server-2012 performance logging

Apr 25 '16 at 11:41 Paul White says GoFundMonica♦ 50.3k

votes

answer

532

views

Generic stored procedure for results sets comparison

sql-server sql-server-2012 performance-testing

Jan 30 '16 at 7:27 Paul White says GoFundMonica♦ 50.3k

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

16 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?

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

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?

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

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?

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

Scalability assessment for a simple auditing system based on an ORM

Database logging optimization and maintenance in SQL Server

Generic stored procedure for results sets comparison