User Evan Carroll

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

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?

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

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

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

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

CREATE TABLE AS vs SELECT INTO

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

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?

How do I generate a time series in PostgreSQL?

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

What are Identity Columns?

How do I generate a date series in PostgreSQL?

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

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.”

Internally, how does OpenRowset(TABLE …) work?

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

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

How can I get a unique array in PostgreSQL?

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

PostgreSQL network compression for result set?

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

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

How do you index a text column in MySQL?