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
Jack Douglas

Reputation

35,267
  • 35.3k
  • 29.4k
  • 23.6k
  • 2018
  • 2019
  • 2020
  • 2021

Next tag badge

oracle
671/1000 score
144/200 answers

Badges

13
89
169

Newest

 Announcer

Next badge

307/500
Copy Editor

Impact

~6.4m
people reached
307 posts edited
95 helpful flags
5,090 votes cast
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

45 Bookmarks

Votes Activity Newest Views Added
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 487
83
votes
5
answers
31k
views

Working of indexes in PostgreSQL

postgresql index primary-key
Jul 13 at 12:55 Erwin Brandstetter 128k
38
votes
6
answers
70k
views

Error Code 1117 Too many columns; MySQL column-limit on table

mysql table
Aug 8 '18 at 19:55 Evan Carroll 48.6k
37
votes
4
answers
14k
views

I Need to Shrink My Database - I just freed a lot of space

sql-server shrink
May 31 '17 at 9:27 McNets 21.3k
35
votes
7
answers
67k
views

Is it possible to use SQLite as a client-server database? [closed]

sqlite
Jun 26 '15 at 21:53 Ruslan Zasukhin 149
31
votes
1
answer
1k
views

Why is the speed of executing statements dependent on the network connection?

sql-server t-sql
Nov 23 '19 at 9:38 Paul White♦ 58.8k
28
votes
4
answers
4k
views

Can spatial index help a “range - order by - limit” query

postgresql database-design index performance query-performance
Jan 21 '19 at 5:31 Community♦ 1
16
votes
3
answers
3k
views

Why are queries parsed in such a way that disallows the use of column aliases in most clauses?

sql-server alias
Jun 25 '15 at 20:18 Community♦ 1
14
votes
2
answers
5k
views

Streaming replication and failover on PostgreSQL

postgresql replication slony pgpool repmgr
Jul 29 '12 at 15:05 Erwin Brandstetter 128k
13
votes
3
answers
20k
views

Best way to design tournament database

mysql database-design
Jul 19 '16 at 22:07 Community♦ 1
12
votes
1
answer
47k
views

Difference between database dump (export) and database backup?

oracle backup export
Nov 10 '14 at 6:35 Ankit 1
12
votes
3
answers
30k
views

SQL to read XML from file into PostgreSQL database

postgresql xml
Jan 20 '18 at 9:22 Jack Douglas 35.3k
12
votes
2
answers
6k
views

Placing Transaction Log on Separate Volume [solid state]?

performance
Oct 19 '15 at 16:13 Community♦ 1
11
votes
2
answers
1k
views

Where to start with Oracle?

oracle plsql
Jul 23 '15 at 11:15 Community♦ 1
10
votes
3
answers
36k
views

How database size affects performance: Theory vs reality

mysql performance
Aug 23 '12 at 4:48 Community♦ 1
9
votes
3
answers
1k
views

Can I rely on functions being executed first in SQL

oracle
Jul 30 '12 at 13:33 StephenK 491
8
votes
3
answers
18k
views

Sort by match of LIKE

sql-server order-by pattern-matching
Aug 25 '18 at 5:07 peterh - Reinstate Monica 1,770
7
votes
1
answer
207
views

Gathering Read Routing information using SMO is inaccurate in SQL Server 2016

sql-server sql-server-2016 availability-groups metadata smo
Feb 13 '18 at 17:45 Sean Gallardy - Retired User 20.7k
7
votes
2
answers
254
views

Can I get the union of the a Postgres fulltext index?

postgresql full-text-search
Feb 23 '15 at 13:50 LowlyDBA - John McCall 10.4k
6
votes
3
answers
6k
views

How to configure replication from PostgreSQL (RDS) to vanilla PostgreSQL?

postgresql replication aws amazon-ec2
Oct 9 at 16:09 Community♦ 1
6
votes
2
answers
5k
views

Scaling Percona datacenters: setup and replication

mysql replication mysql-5.5 percona xtradb-cluster
Oct 22 '12 at 20:23 Community♦ 1
6
votes
4
answers
2k
views

Optimizing a compare query

oracle performance optimization query minus query-performance
Nov 29 '18 at 19:45 Community♦ 1
5
votes
1
answer
965
views

How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?

postgresql clustering postgresql-9.3
Dec 10 '14 at 19:16 Jack Douglas 35.3k
5
votes
2
answers
30k
views

Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage”

oracle windows enterprise-manager
Feb 10 '15 at 12:39 Community♦ 1
5
votes
2
answers
685
views

What are sensible/rational character limits in a database e.g. for a persons name

datatypes check-constraints
Aug 8 '18 at 19:57 Evan Carroll 48.6k
5
votes
2
answers
5k
views

Dynamic access to record column in plpgsql function

postgresql plpgsql dynamic-sql composite-types
Sep 11 '14 at 4:33 Erwin Brandstetter 128k
5
votes
4
answers
205
views

Getting the value of 'foo' for the closest previous row with higher 'bar'

oracle oracle-10g-r2
Mar 13 '12 at 15:54 Leigh Riffel 23.4k
5
votes
1
answer
684
views

Design for file based with many events

database-design sqlite c#
Jun 26 '12 at 13:35 Community♦ 1
4
votes
3
answers
2k
views

What should I consider when deciding between passing a comma-delimited string to a stored procedure instead of calling it individually per record?

sql-server-2005 performance stored-procedures entity-framework
Aug 22 '12 at 21:52 Delux 664
4
votes
2
answers
1k
views

Oracle build_plan_xml visualizer

oracle oracle-11g-r2 execution-plan
Mar 21 '12 at 14:26 Community♦ 1
1
2 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
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.2.26.38663

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.