User ErikE

37 votes

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

answered Nov 10, 2016 at 0:29

19 votes

Accepted

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

answered Aug 3, 2012 at 21:20

14 votes

Should you design the database before the application code is written?

answered Mar 16, 2012 at 5:07

8 votes

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

answered Feb 9, 2012 at 5:24

8 votes

Accepted

Is it possible in a view to reference a linked server implicitly rather than explicitly?

answered Mar 6, 2012 at 20:11

7 votes

Accepted

Inventory database structure when inventory items have varying attributes

answered Mar 17, 2012 at 7:02

7 votes

Form groups of consecutive rows with same value

answered Mar 9, 2017 at 0:02

6 votes

Is it a good idea to use Synonyms to avoid creating a duplicate table?

answered Feb 14, 2012 at 16:45

6 votes

Sql Server fails to use index on simple bijection

answered Aug 11, 2016 at 3:53

5 votes

Understanding datetime formats in SQL Server

answered Nov 25, 2015 at 18:50

5 votes

Table view created with triggers, someone please explain why?

answered Feb 23, 2012 at 0:28

4 votes

Accepted

Interpreting an execution plan

answered Sep 10, 2010 at 4:24

4 votes

how do I model this in database?

answered Mar 22, 2012 at 4:55

4 votes

Easily show rows that are different between two tables or queries

answered Mar 22, 2012 at 21:32

4 votes

How to improve performance if index is not Most SELECTIVE?

answered Feb 1, 2014 at 2:58

4 votes

Merging two selects then sort by and remove duplicates

answered Oct 21, 2016 at 17:02

4 votes

What is the best practice for selecting from two tables with multiple relations?

answered Feb 16, 2017 at 18:46

3 votes

Quick way to validate two tables against each other

answered Feb 9, 2013 at 5:26

3 votes

query optimization: time intervals

answered Feb 9, 2013 at 7:38

3 votes

Checking a wide table for nulls

answered Jul 5, 2012 at 5:05

3 votes

Why evaluates "IS NULL" in SSMS interactive mode to "TRUE" but the same statement being executed in a SP to "FALSE"?

answered Feb 23, 2012 at 8:06

3 votes

Accepted

How do I model data from arbitrary CSV's in a database?

answered Feb 18, 2012 at 7:27

2 votes

Accepted

Express union which is dependent on other results

answered Feb 7, 2012 at 21:44

2 votes

Accepted

Remove nulls from TSQL connection string

answered Feb 23, 2012 at 3:49

2 votes

How to find out what is causing my Identity column to keep going up

answered Feb 28, 2012 at 19:41

2 votes

What will happen when a forum uses 24 char length as an URL ID?

answered Mar 3, 2012 at 5:06

2 votes

Tables with hierarchy: create a constraint to prevent circularity through foreign keys

answered Mar 15, 2012 at 23:45

2 votes

Accepted

sp_executesql adds statements to executed dynamic script?

answered May 30, 2013 at 2:24

2 votes

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

answered Sep 11, 2013 at 18:29

1 vote

changing a range into discrete values for a field in oracle

answered Mar 16, 2012 at 21:21

Stack Exchange Network

37 Answers

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

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

Should you design the database before the application code is written?

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

Is it possible in a view to reference a linked server implicitly rather than explicitly?

Inventory database structure when inventory items have varying attributes

Form groups of consecutive rows with same value

Is it a good idea to use Synonyms to avoid creating a duplicate table?

Sql Server fails to use index on simple bijection

Understanding datetime formats in SQL Server

Table view created with triggers, someone please explain why?

Interpreting an execution plan

how do I model this in database?

Easily show rows that are different between two tables or queries

How to improve performance if index is not Most SELECTIVE?

Merging two selects then sort by and remove duplicates

What is the best practice for selecting from two tables with multiple relations?

Quick way to validate two tables against each other

query optimization: time intervals

Checking a wide table for nulls

Why evaluates "IS NULL" in SSMS interactive mode to "TRUE" but the same statement being executed in a SP to "FALSE"?

How do I model data from arbitrary CSV's in a database?

Express union which is dependent on other results

Remove nulls from TSQL connection string

How to find out what is causing my Identity column to keep going up

What will happen when a forum uses 24 char length as an URL ID?

Tables with hierarchy: create a constraint to prevent circularity through foreign keys

sp_executesql adds statements to executed dynamic script?

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

changing a range into discrete values for a field in oracle