User Jack Douglas

104

votes

9

answers

40k

views

Where are some useful SQL puzzles to teach SQL in a workplace?

learning

Dec 19 '19 at 21:52 testerab 487

83

votes

5

answers

31k

views

Working of indexes in PostgreSQL

Jul 13 at 12:55 Erwin Brandstetter 128k

38

votes

6

answers

70k

views

Error Code 1117 Too many columns; MySQL column-limit on table

mysql table

Aug 8 '18 at 19:55 Evan Carroll 48.6k

37

votes

4

answers

14k

views

I Need to Shrink My Database - I just freed a lot of space

sql-server shrink

May 31 '17 at 9:27 McNets 21.3k

35

votes

7

answers

67k

views

Is it possible to use SQLite as a client-server database? [closed]

sqlite

Jun 26 '15 at 21:53 Ruslan Zasukhin 149

31

votes

1

answer

1k

views

Why is the speed of executing statements dependent on the network connection?

sql-server t-sql

Nov 23 '19 at 9:38 Paul White♦ 58.8k

28

votes

4

answers

4k

views

Can spatial index help a “range - order by - limit” query

postgresql database-design index performance query-performance

Jan 21 '19 at 5:31 Community♦ 1

16

votes

3

answers

3k

views

Why are queries parsed in such a way that disallows the use of column aliases in most clauses?

sql-server alias

Jun 25 '15 at 20:18 Community♦ 1

14

votes

2

answers

5k

views

Streaming replication and failover on PostgreSQL

postgresql replication slony pgpool repmgr

Jul 29 '12 at 15:05 Erwin Brandstetter 128k

13

votes

3

answers

20k

views

Best way to design tournament database

mysql database-design

Jul 19 '16 at 22:07 Community♦ 1

12

votes

1

answer

47k

views

Difference between database dump (export) and database backup?

oracle backup export

Nov 10 '14 at 6:35 Ankit 1

12

votes

3

answers

30k

views

SQL to read XML from file into PostgreSQL database

postgresql xml

Jan 20 '18 at 9:22 Jack Douglas 35.3k

12

votes

2

answers

6k

views

Placing Transaction Log on Separate Volume [solid state]?

performance

Oct 19 '15 at 16:13 Community♦ 1

11

votes

2

answers

1k

views

Where to start with Oracle?

oracle plsql

Jul 23 '15 at 11:15 Community♦ 1

10

votes

3

answers

36k

views

How database size affects performance: Theory vs reality

mysql performance

Aug 23 '12 at 4:48 Community♦ 1

9

votes

3

answers

1k

views

Can I rely on functions being executed first in SQL

oracle

Jul 30 '12 at 13:33 StephenK 491

8

votes

3

answers

18k

views

Sort by match of LIKE

sql-server order-by pattern-matching

Aug 25 '18 at 5:07 peterh - Reinstate Monica 1,770

7

votes

1

answer

207

views

Gathering Read Routing information using SMO is inaccurate in SQL Server 2016

sql-server sql-server-2016 availability-groups metadata smo

Feb 13 '18 at 17:45 Sean Gallardy - Retired User 20.7k

7

votes

2

answers

254

views

Can I get the union of the a Postgres fulltext index?

postgresql full-text-search

Feb 23 '15 at 13:50 LowlyDBA - John McCall 10.4k

6

votes

3

answers

6k

views

How to configure replication from PostgreSQL (RDS) to vanilla PostgreSQL?

postgresql replication aws amazon-ec2

Oct 9 at 16:09 Community♦ 1

6

votes

2

answers

5k

views

Scaling Percona datacenters: setup and replication

mysql replication mysql-5.5 percona xtradb-cluster

Oct 22 '12 at 20:23 Community♦ 1

6

votes

4

answers

2k

views

Optimizing a compare query

oracle performance optimization query minus query-performance

Nov 29 '18 at 19:45 Community♦ 1

5

votes

1

answer

965

views

How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?

postgresql clustering postgresql-9.3

Dec 10 '14 at 19:16 Jack Douglas 35.3k

5

votes

2

answers

30k

views

Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage”

oracle windows enterprise-manager

Feb 10 '15 at 12:39 Community♦ 1

5

votes

2

answers

685

views

What are sensible/rational character limits in a database e.g. for a persons name

datatypes check-constraints

Aug 8 '18 at 19:57 Evan Carroll 48.6k

5

votes

2

answers

5k

views

Dynamic access to record column in plpgsql function

postgresql plpgsql dynamic-sql composite-types

Sep 11 '14 at 4:33 Erwin Brandstetter 128k

5

votes

4

answers

205

views

Getting the value of 'foo' for the closest previous row with higher 'bar'

oracle oracle-10g-r2

Mar 13 '12 at 15:54 Leigh Riffel 23.4k

5

votes

1

answer

684

views

Design for file based with many events

database-design sqlite c#

Jun 26 '12 at 13:35 Community♦ 1

4

votes

3

answers

2k

views

What should I consider when deciding between passing a comma-delimited string to a stored procedure instead of calling it individually per record?

sql-server-2005 performance stored-procedures entity-framework

Aug 22 '12 at 21:52 Delux 664

4

votes

2

answers

1k

views

Oracle build_plan_xml visualizer

oracle oracle-11g-r2 execution-plan

Mar 21 '12 at 14:26 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

45 Bookmarks

Where are some useful SQL puzzles to teach SQL in a workplace?

Working of indexes in PostgreSQL

Error Code 1117 Too many columns; MySQL column-limit on table

I Need to Shrink My Database - I just freed a lot of space

Is it possible to use SQLite as a client-server database? [closed]

Why is the speed of executing statements dependent on the network connection?

Can spatial index help a “range - order by - limit” query

Why are queries parsed in such a way that disallows the use of column aliases in most clauses?

Streaming replication and failover on PostgreSQL

Best way to design tournament database

Difference between database dump (export) and database backup?

SQL to read XML from file into PostgreSQL database

Placing Transaction Log on Separate Volume [solid state]?

Where to start with Oracle?

How database size affects performance: Theory vs reality

Can I rely on functions being executed first in SQL

Sort by match of LIKE

Gathering Read Routing information using SMO is inaccurate in SQL Server 2016

Can I get the union of the a Postgres fulltext index?

How to configure replication from PostgreSQL (RDS) to vanilla PostgreSQL?

Scaling Percona datacenters: setup and replication

Optimizing a compare query

How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?

Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage”

What are sensible/rational character limits in a database e.g. for a persons name

Dynamic access to record column in plpgsql function

Getting the value of 'foo' for the closest previous row with higher 'bar'

Design for file based with many events

What should I consider when deciding between passing a comma-delimited string to a stored procedure instead of calling it individually per record?

Oracle build_plan_xml visualizer