User Evan Carroll

4

33

votes

4

answers

35k

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 Aaron Bertrand♦ 166k

4

26

votes

3

answers

9k

views

What does the word “SARGable” really mean?

terminology

Dec 3 at 8:54 Peter Vandivier 3,215

3

24

votes

2

answers

68k

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

24

votes

2

answers

2k

views

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

sql-standard

May 1 '18 at 20:41 Evan Carroll 44.5k

7

22

votes

6

answers

31k

views

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

sql-server t-sql feature-comparison

Apr 22 '19 at 9:11 Colin 't Hart 7,387

8

18

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

1

17

votes

2

answers

1k

views

Why is there a PostgreSQL Turtle?

postgresql

Sep 17 at 10:27 Peter Vandivier 3,215

2

17

votes

2

answers

8k

views

CREATE TABLE AS vs SELECT INTO

postgresql ctas

Aug 18 at 19:25 shrumm 11

6

17

votes

1

answer

16k

views

How do I store phone numbers in PostgreSQL?

postgresql datatypes data-integrity data-validation

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

7

16

votes

2

answers

28k

views

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

mysql mariadb errors odbc timezone

Jun 8 '19 at 15:42 Evan Carroll 44.5k

5

14

votes

2

answers

7k

views

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

postgresql aggregate array benchmark

Feb 25 at 11:51 Erwin Brandstetter 116k

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

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

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

1

9

votes

3

answers

644

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 clifton_h 657

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

9

votes

3

answers

5k

views

What are Identity Columns?

postgresql identity postgresql-10

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

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

4

9

votes

1

answer

17k

views

How do I generate a date series in PostgreSQL?

postgresql datetime timestamp date timezone

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

1

9

votes

4

answers

7k

views

How do I generate a time series in PostgreSQL?

postgresql time

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

8

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

1

8

votes

1

answer

388

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

1

8

votes

1

answer

688

views

Where can I find the SQL-89 standard?

sql-standard

Jun 21 '18 at 21:13 Jeremy Lee 1

8

votes

2

answers

939

views

Does SQL Server support custom DOMAINs?

sql-server datatypes sql-clr sql-standard domain

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

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

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

7

votes

2

answers

2k

views

PostgreSQL network compression for result set?

postgresql network compression

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

1

7

votes

1

answer

775

views

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

postgresql index

Jul 5 '18 at 15:32 Arkhena 991

7

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

1

7

votes

3

answers

10k

views

Making sense of sys.objects, sys.system_objects, and sys.sysobjects?

sql-server database-internals system-tables

Dec 22 '17 at 8:57 John aka hot2use 11.2k

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

257 Questions

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

What does the word “SARGable” really mean?

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

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?

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

Why is there a PostgreSQL Turtle?

CREATE TABLE AS vs SELECT INTO

How do I store phone numbers in PostgreSQL?

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

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 ()

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?

What are Identity Columns?

Internally, how does OpenRowset(TABLE …) work?

How do I generate a date series 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?

Where can I find the SQL-89 standard?

Does SQL Server support custom DOMAINs?

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?

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

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

Making sense of sys.objects, sys.system_objects, and sys.sysobjects?