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. Public
    2. Questions
    3. Tags
    4. Users
    5. Unanswered
    6. Find a Job
    7. Jobs
    8. Companies
    1. Teams
      Stack Overflow for Teams – Collaborate and share knowledge with a private group. Create a free Team What is Teams?
    2. Teams
      What’s this?
    3. Create free Team

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more
Profile Activity
Meta user
Network profile
garik

Reputation

6,422
  • 6.4k
  • 5.8k
  • 5.1k
  • 2018
  • 2019
  • 2020
  • 2021

Top tag

sql-server

Next privilege

10,000 Rep.
Access moderator tools

Badges

10
39
56

Newest

 Yearling

Next badge

0/1
Excavator

Impact

~886k
people reached
8 posts edited
1 helpful flag
378 votes cast
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

143 Bookmarks

Votes Activity Newest Views Added
142
votes
12
answers
81k
views

Should binary files be stored in the database?

database-design blob
Jan 9 '19 at 6:20 Evan Carroll 49.6k
117
votes
7
answers
128k
views

How to determine if an Index is required or necessary

sql-server performance index optimization
Jan 4 at 10:45 jitbit 623
104
votes
9
answers
40k
views

Where are some useful SQL puzzles to teach SQL in a workplace?

learning
Dec 19 '19 at 21:52 testerab 477
78
votes
5
answers
75k
views

What risks are there if we enable read committed snapshot in sql-server?

sql-server sql-server-2005 transaction
Dec 11 '19 at 20:15 Anne Cao 1
71
votes
6
answers
43k
views

What are the differences between NoSQL and a traditional RDBMS?

nosql rdbms database-recommendation
May 17 '16 at 23:02 Community♦ 1
68
votes
5
answers
11k
views

How can a group track database schema changes?

mysql version-control schema
Aug 16 '17 at 9:08 mbx 103
67
votes
7
answers
65k
views

Writing a simple bank schema: How should I keep my balances in sync with their transaction history?

sql-server sql-server-2008 database-design aggregate materialized-view
Apr 4 '19 at 8:27 Paul White♦ 59.7k
59
votes
12
answers
258k
views

Passing array parameters to a stored procedure

sql-server sql-server-2008
Mar 23 at 19:42 Charlieface 906
59
votes
6
answers
83k
views

When should I rebuild indexes?

sql-server index-maintenance
Dec 15 '17 at 6:36 Community♦ 1
50
votes
4
answers
15k
views

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

sql-server sql-server-2008 sql-server-2008-r2 sql-server-2012
May 8 '20 at 2:19 Aaron Bertrand 171k
45
votes
9
answers
6k
views

How should deletions be handled in the database?

database-design delete audit
Aug 7 '19 at 12:58 David Spillett 28k
45
votes
11
answers
60k
views

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

sql-server sql-server-2005 identity
Sep 22 at 17:06 Viraj Sandaruwan 1
44
votes
5
answers
36k
views

Is nested view a good database design?

sql-server performance database-design view
Jul 23 '19 at 15:38 Erik Darling 31k
42
votes
3
answers
51k
views

Why is my database still fragmented after I rebuilt and reindexed everything?

sql-server-2008 index fragmentation
Sep 5 '11 at 10:45 Marian 14.5k
39
votes
4
answers
8k
views

On a dedicated database server, how much memory to reserve for the OS?

sql-server windows memory
Dec 29 '13 at 16:39 Troy 390
39
votes
6
answers
62k
views

How to execute SQL against all DBs on a Server

sql-server
Nov 20 '17 at 8:49 Paul 1,403
38
votes
4
answers
43k
views

Hard and Fast rule for include columns in index

sql-server sql-server-2005 sql-server-2008 index
May 27 '15 at 21:46 Community♦ 1
38
votes
5
answers
136k
views

Logical operators OR AND in condition and order of conditions in WHERE

sql-server sql-server-2008 t-sql optimization condition
Sep 4 '19 at 9:59 Community♦ 1
37
votes
10
answers
8k
views

How can I track database dependencies?

sql-server management
Sep 13 '13 at 11:04 Community♦ 1
37
votes
6
answers
6k
views

The smallest backup possible … with SQL Server

sql-server sql-server-2008 backup
Apr 7 '14 at 5:04 Community♦ 1
36
votes
2
answers
4k
views

Why are Denali sequences supposed to perform better than identity columns?

sql-server sql-server-2012 sequence
Apr 20 '16 at 12:40 Community♦ 1
31
votes
1
answer
14k
views

Designing a platform: one database or multiple databases?

database-design deployment
Oct 21 '11 at 18:56 Mark Storey-Smith 30.8k
31
votes
5
answers
2k
views

Is there a “best-practices” type process for developers to follow for database changes?

sql-server-2008 process source-control
May 15 '20 at 23:08 Oleksii Gubanov 1
30
votes
10
answers
1k
views

What is an effective way of labeling columns in a database?

database-design erd
Mar 27 '18 at 19:58 Evan Carroll 49.6k
29
votes
4
answers
105k
views

How to find out who deleted some data SQL Server

sql-server transaction delete audit
Aug 9 '19 at 19:00 Randi Vertongen 15.6k
27
votes
3
answers
35k
views

Code to simulate deadlock

sql-server deadlock
Dec 20 '16 at 15:51 Tom V 15.3k
27
votes
4
answers
16k
views

SQL Server “empty table” is slow after deleting all (12 million) records?

sql-server sql-server-2008
Mar 8 '12 at 2:33 Community♦ 1
26
votes
3
answers
16k
views

Mnesia: advantages and differences

feature-comparison
Nov 21 '13 at 13:58 Community♦ 1
26
votes
3
answers
18k
views

What are some best practices for using schemas in SQL Server?

sql-server sql-server-2008 schema
Jun 18 '18 at 14:03 Community♦ 1
25
votes
8
answers
26k
views

Tool to generate large datasets of test data [closed]

mysql tools performance performance-testing
Oct 3 '13 at 14:28 Community♦ 1
1
2 3 4 5 Next
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
  • Cookie Policy
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.4.22.39130

Your privacy

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