Stack Exchange Network

Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Loading…
  1. 0
  2. +0
    • Tour Start here for a quick overview of the site
    • Help Center Detailed answers to any questions you might have
    • Meta Discuss the workings and policies of this site
    • About Us Learn more about Stack Overflow the company
    • Business Learn more about hiring developers or posting ads with us
  3. Log in Sign up
  4. current community

    • Database Administrators
      help chat
    • Database Administrators Meta

    your communities

    Sign up or log in to customize your list.

    more stack exchange communities

    company blog
Database Administrators
  1. Home
    1. Questions
    2. Tags
    3. Users
    4. Unanswered
    5. Jobs
Profile Activity
Meta user
Network profile
Alexei

Reputation

1,233
  • 1.3k
  • 776
  • 229
  • 2018
  • 2019
  • 2020
  • 2021

Top tag

sql-server

Next privilege

2,000 Rep.
Edit questions and answers

Badges

11
30

Newest

 Yearling

Next badge

228/300
Civic Duty

Impact

~99k
people reached
33 posts edited
28 helpful flags
228 votes cast
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

21 Questions

Votes Activity Newest Views
7
18
votes
6
answers
3k
views

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

sql-server database-design sql-server-2014 identity
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
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
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
Database Administrators
  • Tour
  • Help
  • Chat
  • Contact
  • Feedback
  • Mobile
Company
  • Stack Overflow
  • For Teams
  • Advertise With Us
  • Hire a Developer
  • Developer Jobs
  • About
  • Press
  • Legal
  • Privacy Policy
  • Terms of Service
  • Cookie Settings
Stack Exchange
Network
  • Technology
  • Life / Arts
  • Culture / Recreation
  • Science
  • Other
  • Stack Overflow
  • Server Fault
  • Super User
  • Web Applications
  • Ask Ubuntu
  • Webmasters
  • Game Development
  • TeX - LaTeX
  • Software Engineering
  • Unix & Linux
  • Ask Different (Apple)
  • WordPress Development
  • Geographic Information Systems
  • Electrical Engineering
  • Android Enthusiasts
  • Information Security
  • Database Administrators
  • Drupal Answers
  • SharePoint
  • User Experience
  • Mathematica
  • Salesforce
  • ExpressionEngine® Answers
  • Stack Overflow em Português
  • Blender
  • Network Engineering
  • Cryptography
  • Code Review
  • Magento
  • Software Recommendations
  • Signal Processing
  • Emacs
  • Raspberry Pi
  • Stack Overflow на русском
  • Code Golf
  • Stack Overflow en español
  • Ethereum
  • Data Science
  • Arduino
  • Bitcoin
  • Software Quality Assurance & Testing
  • Sound Design
  • Windows Phone
  • more (28)
  • Photography
  • Science Fiction & Fantasy
  • Graphic Design
  • Movies & TV
  • Music: Practice & Theory
  • Worldbuilding
  • Video Production
  • Seasoned Advice (cooking)
  • Home Improvement
  • Personal Finance & Money
  • Academia
  • Law
  • Physical Fitness
  • Gardening & Landscaping
  • Parenting
  • more (10)
  • English Language & Usage
  • Skeptics
  • Mi Yodeya (Judaism)
  • Travel
  • Christianity
  • English Language Learners
  • Japanese Language
  • Chinese Language
  • French Language
  • German Language
  • Biblical Hermeneutics
  • History
  • Spanish Language
  • Islam
  • Русский язык
  • Russian Language
  • Arqade (gaming)
  • Bicycles
  • Role-playing Games
  • Anime & Manga
  • Puzzling
  • Motor Vehicle Maintenance & Repair
  • Board & Card Games
  • Bricks
  • Homebrewing
  • Martial Arts
  • The Great Outdoors
  • Poker
  • Chess
  • Sports
  • more (16)
  • MathOverflow
  • Mathematics
  • Cross Validated (stats)
  • Theoretical Computer Science
  • Physics
  • Chemistry
  • Biology
  • Computer Science
  • Philosophy
  • Linguistics
  • Psychology & Neuroscience
  • Computational Science
  • more (10)
  • Meta Stack Exchange
  • Stack Apps
  • API
  • Data
  • Blog
  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev 2021.1.15.38327

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.