User Evan Carroll

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

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

256 Questions

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

What does the word “SARGable” really mean?

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

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

Why is there a PostgreSQL Turtle?

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

CREATE TABLE AS vs SELECT INTO

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

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

How do I store phone numbers in PostgreSQL?

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

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

How do I totally remove SQL Server 2017 on Ubuntu?

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

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

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

How do I generate a time series in PostgreSQL?

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

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

How do I do factorials in SQL Server?

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

PostgreSQL network compression for result set?

Does SQL Server support custom DOMAINs?

What are Identity Columns?

Internally, how does OpenRowset(TABLE …) work?

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

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

Does the spec permit column-count mismatch on INSERT?

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

When are COLUMN aliases in FROM clauses needed?