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
Evan Carroll

Reputation

49,315
  • 49.3k
  • 29.7k
  • 10.1k
  • 2018
  • 2019
  • 2020
  • 2021

Next tag badge

spatial
150/400 score
79/80 answers

Badges

29
171
362

Newest

 Popular Question

Next badge

204/500
Marshal

Impact

~6.0m
people reached
963 posts edited
204 helpful flags
2,005 votes cast
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

259 Questions

Votes Activity Newest Views
6
37
votes
4
answers
43k
views

How do I identify the column(s) responsible for “String or binary data would be truncated.”

sql-server sql-server-2008
Mar 2 '20 at 12:40 Community♦ 1
6
36
votes
3
answers
12k
views

What does the word “SARGable” really mean?

terminology
Dec 3 '19 at 8:54 Community♦ 1
7
28
votes
6
answers
46k
views

Does SQL Server support GREATEST and LEAST, if not what is the common workaround?

sql-server t-sql feature-comparison
Jul 2 at 16:06 Ed Avis 147
3
27
votes
4
answers
2k
views

Where can I find the first standardization of SQL, SQL-86?

sql-standard
Aug 28 at 3:50 Evan Carroll 49.3k
4
27
votes
2
answers
89k
views

SQL Server returns “Arithmetic overflow error converting expression to data type int.”

sql-server aggregate datatypes sql-server-2017
Sep 19 '19 at 2:25 MrTariqJamil 1
10
20
votes
3
answers
36k
views

How do I resolve this error, “ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'”?

mysql mariadb errors odbc timezone
Dec 12 at 8:09 Bitopan sarma baruah 1
4
20
votes
2
answers
11k
views

CREATE TABLE AS vs SELECT INTO

postgresql ctas
Aug 18 '19 at 19:25 shrumm 11
8
18
votes
4
answers
6k
views

How do I generate a pivoted CROSS JOIN where the resulting table definition is unknown?

postgresql pivot dynamic-sql
Sep 2 '18 at 13:49 Community♦ 1
1
17
votes
2
answers
1k
views

Why is there a PostgreSQL Turtle?

postgresql
Nov 30 at 21:57 Peter Vandivier 3,509
6
17
votes
1
answer
19k
views

How do I store phone numbers in PostgreSQL?

postgresql datatypes data-integrity data-validation
Feb 18 '17 at 16:25 Evan Carroll 49.3k
5
15
votes
2
answers
9k
views

Why is array_agg() slower than the non-aggregate ARRAY() constructor?

postgresql aggregate array benchmark
Feb 25 '20 at 11:51 Erwin Brandstetter 130k
4
13
votes
1
answer
16k
views

How do I totally remove SQL Server 2017 on Ubuntu?

sql-server linux installation ubuntu sql-server-2017
Dec 22 '17 at 20:41 Evan Carroll 49.3k
5
12
votes
4
answers
10k
views

How do I generate a time series in PostgreSQL?

postgresql time
Sep 30 '17 at 23:34 Erwin Brandstetter 130k
3
11
votes
1
answer
1k
views

What function quotes an identifier in dynamic-sql with SQL Server?

sql-server security sql-injection
Sep 4 '18 at 7:25 Evan Carroll 49.3k
 
11
votes
3
answers
7k
views

What are Identity Columns?

postgresql identity postgresql-10
Apr 30 '18 at 20:09 Evan Carroll 49.3k
5
11
votes
1
answer
22k
views

How do I generate a date series in PostgreSQL?

postgresql datetime timestamp date timezone
Nov 9 '17 at 23:46 Evan Carroll 49.3k
1
11
votes
1
answer
2k
views

Does the SQL Spec require a GROUP BY in EXISTS ()

sql-server postgresql group-by sql-standard exists
Mar 24 '17 at 2:16 Evan Carroll 49.3k
1
9
votes
3
answers
933
views

Where can I find the SQL-89 standard?

sql-standard
Nov 30 at 23:05 Peter Vandivier 3,509
1
9
votes
3
answers
807
views

Does SQL Server allow (make visible) DDL inside a transaction to the transaction prior to commit?

sql-server transaction sql-server-2017 ddl
May 13 '19 at 14:23 Community♦ 1
1
9
votes
2
answers
2k
views

How exactly does the one-byte “char” type work in PostgreSQL?

postgresql datatypes storage cast
Dec 5 '18 at 23:33 Erwin Brandstetter 130k
 
9
votes
3
answers
4k
views

SQL Server Error, “Invalid usage of the option FIRST in the FETCH statement.”

sql-server sql-server-2017 offset-fetch
Aug 8 '18 at 8:21 Community♦ 1
2
9
votes
1
answer
2k
views

Internally, how does OpenRowset(TABLE …) work?

sql-server database-internals
Feb 21 '18 at 16:19 John K. N. 13.1k
3
9
votes
1
answer
8k
views

Solving “Gaps and Islands” with row_number() and dense_rank()?

postgresql window-functions gaps-and-islands rank
Mar 14 '17 at 19:17 Community♦ 1
 
8
votes
1
answer
16k
views

Getting “sqlcmd sqlcmd: command not found” in Linux?

sql-server ubuntu sql-server-2017
Feb 18 at 4:13 Paul Gear 103
1
8
votes
2
answers
12k
views

How can I get a unique array in PostgreSQL?

postgresql array
Jun 1 at 17:44 potstone 1
1
8
votes
2
answers
14k
views

How do I disable MySQL on Linux from starting on boot or statup?

mysql mariadb linux ubuntu
Mar 10 '19 at 19:05 Yossarian42 141
 
8
votes
2
answers
2k
views

PostgreSQL network compression for result set?

postgresql network compression
Jul 6 '18 at 17:27 Evan Carroll 49.3k
1
8
votes
1
answer
967
views

What is the fate of VODKA Indexing, is it dead?

postgresql index
Jul 5 '18 at 15:32 Arkhena 1,176
1
8
votes
1
answer
448
views

Why does a Set Returning Function (SRF) run slower in a FROM clause?

postgresql performance functions database-internals set-returning-functions
Jun 25 '18 at 0:54 Erwin Brandstetter 130k
 
8
votes
1
answer
20k
views

How do you index a text column in MySQL?

mysql index mariadb datatypes
Jun 22 '18 at 20:44 Evan Carroll 49.3k
1
2 3 4 5
…
9 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.9.39043

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.