User HLGEM

20 votes

Why are constraints applied in the database rather than the code?

answered Apr 12, 2013 at 18:22

14 votes

Common Table Expression (CTE) benefits?

answered Mar 6, 2012 at 20:51

11 votes

Accepted

Is a surrogate key better than a natural key in this case

answered Jan 6, 2013 at 19:51

11 votes

EF Code First uses nvarchar(max) for all strings. Will this hurt query performance?

answered Aug 20, 2013 at 19:46

9 votes

How could DBAs be more 'programmer friendly'?

answered Feb 14, 2013 at 20:04

9 votes

How can I identify when to create a new table to hold data that can be obtained from a query?

answered Mar 30, 2012 at 14:14

8 votes

Is my ER Diagram correct? Why use relationships?

answered Mar 15, 2012 at 20:07

8 votes

Does the compatibility level for sql server work reliably for scripts?

answered Oct 11, 2011 at 16:45

8 votes

Can you give me one example of Business Intelligence?

answered Jul 3, 2012 at 14:23

7 votes

Accepted

How to handle huge table

answered Jan 17, 2013 at 18:59

7 votes

Column name naming conventions and best practices

answered Feb 23, 2012 at 19:30

6 votes

Database suggestion for a social network/ knowledge base community?

answered Feb 29, 2012 at 18:10

6 votes

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

answered Mar 9, 2012 at 22:16

6 votes

How does shrinking a SQL Server log file affect performance?

answered Jul 12, 2011 at 14:52

6 votes

Is it critical for a database to have a relationship table/diagram or not?

answered Feb 13, 2012 at 21:07

6 votes

Potential risks of users connecting to SQL Server, through Excel, as sysadmin?

answered Oct 4, 2012 at 21:22

6 votes

Accepted

Good reason to denormalize?

answered May 17, 2012 at 13:48

6 votes

Is it worth to separate columns into multiple tables for one-to-one relational table

answered Jun 5, 2013 at 14:23

6 votes

Foreign keys - link using surrogate or natural key?

answered Apr 2, 2013 at 17:49

5 votes

How to avoid using the IN clause in sql query used in a stored procedure

answered Jan 16, 2013 at 21:44

5 votes

SSIS ETL Question/Option

answered May 16, 2012 at 15:28

5 votes

What should every DBA know?

answered Jun 22, 2012 at 17:42

5 votes

Is it safe to change the name of a database?

answered Feb 28, 2012 at 20:44

5 votes

Performance degradation while updating tables having 10s of millions of records

answered May 9, 2012 at 18:48

4 votes

Convert varchar column to datetime

answered May 15, 2012 at 17:57

4 votes

Is there a reason/benefit I am not aware of for this kind setup?

answered Mar 16, 2012 at 15:22

4 votes

migrating from SQL server 2005 to 2008

answered Mar 27, 2012 at 18:47

4 votes

Database growing like crazy - what do I do?

answered Mar 5, 2012 at 16:35

4 votes

Should you ever not assign an unique ID to each row in a table?

answered Sep 22, 2011 at 15:01

4 votes

Proper use of NULL, and utilizing CHECK constraints for business logic vs stored procedures

answered Jul 26, 2012 at 20:30

Stack Exchange Network

93 Answers

Why are constraints applied in the database rather than the code?

Common Table Expression (CTE) benefits?

Is a surrogate key better than a natural key in this case

EF Code First uses nvarchar(max) for all strings. Will this hurt query performance?

How could DBAs be more 'programmer friendly'?

How can I identify when to create a new table to hold data that can be obtained from a query?

Is my ER Diagram correct? Why use relationships?

Does the compatibility level for sql server work reliably for scripts?

Can you give me one example of Business Intelligence?

How to handle huge table

Column name naming conventions and best practices

Database suggestion for a social network/ knowledge base community?

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

How does shrinking a SQL Server log file affect performance?

Is it critical for a database to have a relationship table/diagram or not?

Potential risks of users connecting to SQL Server, through Excel, as sysadmin?

Good reason to denormalize?

Is it worth to separate columns into multiple tables for one-to-one relational table

Foreign keys - link using surrogate or natural key?

How to avoid using the IN clause in sql query used in a stored procedure

SSIS ETL Question/Option

What should every DBA know?

Is it safe to change the name of a database?

Performance degradation while updating tables having 10s of millions of records

Convert varchar column to datetime

Is there a reason/benefit I am not aware of for this kind setup?

migrating from SQL server 2005 to 2008

Database growing like crazy - what do I do?

Should you ever not assign an unique ID to each row in a table?

Proper use of NULL, and utilizing CHECK constraints for business logic vs stored procedures