User Evan Carroll

4

34

votes

4

answers

38k

views

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

sql-server sql-server-2008

Mar 2 at 12:40 Community♦ 1

5

31

votes

3

answers

10k

views

What does the word “SARGable” really mean?

terminology

Dec 3 at 8:54 Community♦ 1

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 46.3k

7

25

votes

6

answers

37k

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 137

4

25

votes

2

answers

78k

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

2

18

votes

2

answers

9k

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

7

17

votes

3

answers

32k

views

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

mysql mariadb errors odbc timezone

Sep 15 at 4:50 Paul White♦ 57.6k

1

17

votes

2

answers

1k

views

Why is there a PostgreSQL Turtle?

postgresql

Sep 17 '19 at 10:27 Peter Vandivier 3,388

6

17

votes

1

answer

18k

views

How do I store phone numbers in PostgreSQL?

postgresql datatypes data-integrity data-validation

Feb 18 '17 at 16:25 Evan Carroll 46.3k

5

15

votes

2

answers

8k

views

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

postgresql aggregate array benchmark

Feb 25 at 11:51 Erwin Brandstetter 122k

4

13

votes

1

answer

15k

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 46.3k

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 46.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 46.3k

4

10

votes

1

answer

19k

views

How do I generate a date series in PostgreSQL?

postgresql datetime timestamp date timezone

Nov 9 '17 at 23:46 Evan Carroll 46.3k

1

10

votes

4

answers

8k

views

How do I generate a time series in PostgreSQL?

postgresql time

Sep 30 '17 at 23:34 Erwin Brandstetter 122k

1

9

votes

1

answer

798

views

Where can I find the SQL-89 standard?

sql-standard

Aug 10 at 9:03 Thaer Al-Hanafi 1

1

9

votes

3

answers

700

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 122k

9

votes

3

answers

3k

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

9

votes

3

answers

6k

views

What are Identity Columns?

postgresql identity postgresql-10

Apr 30 '18 at 20:09 Evan Carroll 46.3k

2

9

votes

1

answer

2k

views

Internally, how does OpenRowset(TABLE …) work?

sql-server database-internals

Feb 21 '18 at 16:19 John aka hot2use 12k

8

votes

2

answers

2k

views

PostgreSQL network compression for result set?

postgresql network compression

Jul 6 '18 at 17:27 Evan Carroll 46.3k

1

8

votes

1

answer

408

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 122k

8

votes

2

answers

1k

views

Does SQL Server support custom DOMAINs?

sql-server datatypes sql-clr sql-standard domain

Jun 2 '18 at 20:26 Evan Carroll 46.3k

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 74.7k

8

votes

2

answers

5k

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 39.6k

3

8

votes

1

answer

7k

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

3

8

votes

3

answers

11k

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 46.3k

1

7

votes

2

answers

2k

views

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

sql-server json

Jul 11 '19 at 15:36 Peter Vandivier 3,388

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

259 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?

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

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

CREATE TABLE AS vs SELECT INTO

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

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

Why is there a PostgreSQL Turtle?

How do I store phone numbers in PostgreSQL?

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

How do I totally remove SQL Server 2017 on Ubuntu?

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

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

How do I generate a date series in PostgreSQL?

How do I generate a time series in PostgreSQL?

Where can I find the SQL-89 standard?

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?

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

What are Identity Columns?

Internally, how does OpenRowset(TABLE …) work?

PostgreSQL network compression for result set?

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

Does SQL Server support custom DOMAINs?

How do I do factorials in SQL Server?

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

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

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

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