Stack Exchange Network

Stack Exchange network consists of 175 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

By using our site, you acknowledge that you have read and understand our Cookie Policy, Privacy Policy, and our Terms of Service.

Database Administrators
  1. Home
    1. Questions
    2. Tags
    3. Users
    4. Unanswered
Profile Activity
Evan Carroll
Meta user
Network profile

Reputation

41,414
  • 41.4k
  • 21.1k
  • 731
  • 2016
  • 2017
  • 2018
  • 2019

Next tag badge

spatial
121/400 score
78/80 answers

Badges

15
104
286

Newest

 Popular Question

Next badge

201/500
Marshal

Impact

~3.6m
people reached
958 posts edited
201 helpful flags
1,994 votes cast
Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

256 Questions

Views Newest Activity Votes
3
31
votes
4
answers
31k
views

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

sql-server sql-server-2008
Apr 29 at 15:09 Aaron Bertrand♦ 163k
3
23
votes
3
answers
6k
views

What does the word “SARGable” really mean?

terminology
Dec 3 at 8:54 Peter Vandivier 2,802
1
22
votes
2
answers
1k
views

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

sql-standard
May 1 '18 at 20:41 Evan Carroll 41.4k
3
19
votes
2
answers
48k
views

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

sql-server aggregate datatypes sql-server-2017
Sep 19 at 2:25 MrTariqJamil 1
1
17
votes
2
answers
1k
views

Why is there a PostgreSQL Turtle?

postgresql
Sep 17 at 10:27 Peter Vandivier 2,802
6
17
votes
4
answers
5k
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 Erwin Brandstetter 108k
2
16
votes
2
answers
6k
views

CREATE TABLE AS vs SELECT INTO

postgresql ctas
Aug 18 at 19:25 shrumm 11
6
15
votes
6
answers
22k
views

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

sql-server t-sql feature-comparison
Apr 22 at 9:11 Colin 't Hart 7,047
7
14
votes
2
answers
22k
views

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

mysql mariadb errors odbc timezone
Jun 8 at 15:42 Evan Carroll 41.4k
6
14
votes
1
answer
13k
views

How do I store phone numbers in PostgreSQL?

postgresql datatypes data-integrity data-validation
Feb 18 '17 at 16:25 Evan Carroll 41.4k
4
13
votes
2
answers
6k
views

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

postgresql aggregate array benchmark
Jul 3 at 23:54 Erwin Brandstetter 108k
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 41.4k
4
11
votes
1
answer
13k
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 41.4k
1
11
votes
1
answer
1k
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 41.4k
1
9
votes
3
answers
547
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 at 14:23 clifton_h 637
1
9
votes
2
answers
1k
views

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

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

How do I generate a time series in PostgreSQL?

postgresql time
Sep 30 '17 at 23:34 Erwin Brandstetter 108k
 
8
votes
3
answers
2k
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 Evan Carroll 41.4k
 
8
votes
1
answer
347
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 108k
1
8
votes
2
answers
2k
views

How do I do factorials in SQL Server?

sql-server
Mar 17 '18 at 21:39 Martin Smith 71.3k
3
8
votes
3
answers
10k
views

In Microsoft SQL Server 2008, syntax generates the error “The Parallel Data Warehouse (PDW) features are not enabled.”

sql-server-2008-r2 window-functions
Jul 30 '13 at 21:08 Evan Carroll 41.4k
 
7
votes
2
answers
1k
views

PostgreSQL network compression for result set?

postgresql network compression
Jul 6 '18 at 17:27 Evan Carroll 41.4k
 
7
votes
2
answers
789
views

Does SQL Server support custom DOMAINs?

sql-server datatypes sql-clr sql-standard domain
Jun 2 '18 at 20:26 Evan Carroll 41.4k
 
7
votes
3
answers
4k
views

What are Identity Columns?

postgresql identity postgresql-10
Apr 30 '18 at 20:09 Evan Carroll 41.4k
1
7
votes
1
answer
1k
views

Internally, how does OpenRowset(TABLE …) work?

sql-server database-internals
Feb 21 '18 at 16:19 John aka hot2use 10.1k
 
7
votes
2
answers
4k
views

Is there a developer edition of Microsoft SQL Server 2017 for Linux? [closed]

sql-server ubuntu license sql-server-2017
Dec 26 '17 at 20:39 Brent Ozar 38k
 
7
votes
1
answer
10k
views

ORDER BY items must appear in the select list […]

sql-server sql-server-2008-r2 order-by case
Jul 30 '13 at 21:28 Martin Smith 71.3k
 
6
votes
2
answers
580
views

Does the spec permit column-count mismatch on INSERT?

sql-server postgresql mariadb insert sql-standard
Oct 28 at 21:53 Paul White says GoFundMonica♦ 50.1k
 
6
votes
2
answers
766
views

Flatten array with OPENJSON: OPENJSON on a value that may not be an array? [ [1] ], vs [1]

sql-server json
Jul 11 at 15:36 Peter Vandivier 2,802
 
6
votes
1
answer
551
views

When are COLUMN aliases in FROM clauses needed?

postgresql alias
Aug 17 '18 at 6:34 Evan Carroll 41.4k
1 2 3 4 5 … 9 next
Database Administrators
  • Tour
  • Help
  • Chat
  • Contact
  • Feedback
  • Mobile
Company
  • Stack Overflow
  • Stack Overflow Business
  • Developer Jobs
  • About
  • Press
  • Legal
  • Privacy 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 (27)
  • 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 (11)
  • 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 (8)
  • Meta Stack Exchange
  • Stack Apps
  • API
  • Data
  • Blog
  • Facebook
  • Twitter
  • LinkedIn

site design / logo © 2019 Stack Exchange Inc; user contributions licensed under cc by-sa 4.0 with attribution required. rev 2019.12.6.35579