User Michael Green

47 votes

Accepted

Not using foreign key constraints in real practice. Is it OK?

answered Mar 30, 2017 at 5:13

34 votes

Accepted

Why would SELECT * be magnitudes faster than SELECT foo?

answered Jul 27, 2014 at 11:40

29 votes

Does it save anything to use a smaller varchar or nvarchar size instead of some large value like 4000?

answered Feb 12, 2022 at 12:08

19 votes

Accepted

Does an excessive table violate normalization rules?

answered Oct 7, 2019 at 0:05

19 votes

What is the benefit of indexing assuming that SQL server has huge memory to accomodate the entire database in memory?

answered Sep 1, 2022 at 5:40

18 votes

Business logic in stored proc vs middle layer (c#)

answered Jun 15, 2016 at 3:18

18 votes

Accepted

Memory Optimized Tables - can they really be so difficult to maintain?

answered Sep 1, 2014 at 9:53

16 votes

Accepted

Merge two SELECT queries with different WHERE clauses

answered Apr 19, 2014 at 12:57

15 votes

Accepted

What is the effect of having an opened transaction in MSSQL for too long?

answered Jun 27, 2016 at 5:49

14 votes

Asked to Not Use Transactions and to Use A Workaround to Simulate One

answered Sep 13, 2019 at 7:22

14 votes

Accepted

How to generate globally unique ids for different tables of the same database?

answered Mar 14, 2019 at 11:34

13 votes

What are the best practices regarding lookup tables in relational databases?

answered Jul 3, 2016 at 16:40

13 votes

Accepted

Optimise huge Postgres table for fast read

answered Jan 13, 2015 at 9:01

12 votes

Accepted

How to create a synonym for a column in SQL Server?

answered Jan 14, 2019 at 23:29

11 votes

Accepted

Nested-Loop-Join: How many comparisons and how many pages-accesses?

answered Jul 14, 2019 at 4:47

11 votes

Accepted

Attached database to SQL Server 2016 and now won't work in SQL Server 2014

answered Sep 15, 2016 at 23:07

11 votes

Is adding the ‘tbl’ prefix to table names really a problem?

answered Nov 9, 2016 at 2:07

11 votes

Accepted

Is it "OK" to have a table that only contain foreign keys?

answered Feb 21, 2016 at 6:38

11 votes

Accepted

What problems are solved by splitting street addresses into individual columns?

answered Mar 29, 2016 at 10:36

11 votes

Accepted

which way is better to design shopping Cart Table - SQL Server

answered Mar 29, 2016 at 11:17

11 votes

Accepted

During rollback, is lock escalation reversed

answered May 6, 2016 at 5:41

11 votes

Accepted

using a column that references an object_id in your own table

answered Nov 22, 2020 at 10:55

10 votes

Solution to assigning unique values to rows with finite collaboration distance

answered Mar 4, 2019 at 12:13

10 votes

Accepted

MS SQL Page split confusion

answered Nov 15, 2016 at 2:15

9 votes

SQL server changes XML structure when inserted

answered Nov 27, 2018 at 2:44

9 votes

Convert a date range to an interval description

answered May 10, 2016 at 5:29

9 votes

Is a single-table relational database similar to a simple NoSQL database?

answered May 8, 2020 at 5:58

9 votes

Is it a good idea to Partition a table (in MS SQL) based on date, when there's a clustered index present on ID (INT)

answered Aug 23, 2021 at 12:38

9 votes

As there is no unsigned int in SQL Server doesn't an Identity Seed of -2,147,483,648 make more sense for large tables?

answered Jan 29, 2021 at 11:45

9 votes

Accepted

Is a serialization anomaly only possible with SUM/COUNT?

answered Aug 8, 2022 at 10:20

Stack Exchange Network

839 Answers

Not using foreign key constraints in real practice. Is it OK?

Why would SELECT * be magnitudes faster than SELECT foo?

Does it save anything to use a smaller varchar or nvarchar size instead of some large value like 4000?

Does an excessive table violate normalization rules?

What is the benefit of indexing assuming that SQL server has huge memory to accomodate the entire database in memory?

Business logic in stored proc vs middle layer (c#)

Memory Optimized Tables - can they really be so difficult to maintain?

Merge two SELECT queries with different WHERE clauses

What is the effect of having an opened transaction in MSSQL for too long?

Asked to Not Use Transactions and to Use A Workaround to Simulate One

How to generate globally unique ids for different tables of the same database?

What are the best practices regarding lookup tables in relational databases?

Optimise huge Postgres table for fast read

How to create a synonym for a column in SQL Server?

Nested-Loop-Join: How many comparisons and how many pages-accesses?

Attached database to SQL Server 2016 and now won't work in SQL Server 2014

Is adding the ‘tbl’ prefix to table names really a problem?

Is it "OK" to have a table that only contain foreign keys?

What problems are solved by splitting street addresses into individual columns?

which way is better to design shopping Cart Table - SQL Server

During rollback, is lock escalation reversed

using a column that references an object_id in your own table

Solution to assigning unique values to rows with finite collaboration distance

MS SQL Page split confusion

SQL server changes XML structure when inserted

Convert a date range to an interval description

Is a single-table relational database similar to a simple NoSQL database?

Is it a good idea to Partition a table (in MS SQL) based on date, when there's a clustered index present on ID (INT)

As there is no unsigned int in SQL Server doesn't an Identity Seed of -2,147,483,648 make more sense for large tables?

Is a serialization anomaly only possible with SUM/COUNT?