User HLGEM

7 votes

Column name naming conventions and best practices

answered Feb 23, 2012 at 19:30

0 votes

Data - Changes Audit Trail

answered Sep 11, 2012 at 15:06

4 votes

Convert varchar column to datetime

answered May 15, 2012 at 17:57

3 votes

Accepted

Database Design question, calculate or save financial positions

answered Mar 15, 2013 at 15:08

2 votes

PRIMARY KEY CONSTRAINT fundamentals

answered Mar 15, 2013 at 13:55

11 votes

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

answered Aug 20, 2013 at 19:46

6 votes

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

answered Jun 5, 2013 at 14:23

7 votes

Accepted

How to handle huge table

answered Jan 17, 2013 at 18:59

5 votes

Is it safe to change the name of a database?

answered Feb 28, 2012 at 20:44

0 votes

Optimisation Newbie: How much of a 'sin' is redundancy?

answered Apr 24, 2012 at 19:01

1 vote

Editing built-in templates in Management Studio

answered Mar 30, 2012 at 17:26

9 votes

How could DBAs be more 'programmer friendly'?

answered Feb 14, 2013 at 20:04

1 vote

Views - Indexes/Keys/Execution Plans

answered Mar 13, 2012 at 17:56

-1 votes

How to migrate data between "all-surrogate" databases?

answered Jul 8, 2013 at 18:34

1 vote

Is this a good strategy for importing a large amount of data and decomposing as an ETL?

answered Jun 20, 2013 at 21:15

3 votes

Find procedures that haven't been called in <n> days

answered Jun 5, 2013 at 21:12

1 vote

SQL Server transaction log growing without control

answered Jun 4, 2013 at 14:45

2 votes

Left Join not giving desired result

answered May 14, 2013 at 19:03

1 vote

MySQL: Join one Row in a table with two Rows in other table

answered Apr 16, 2013 at 22:19

20 votes

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

answered Apr 12, 2013 at 18:22

1 vote

SQL Server BULK INSERT

answered Apr 8, 2013 at 21:27

2 votes

SSIS keeps force changing excel source string to float

answered Apr 4, 2013 at 21:51

6 votes

Foreign keys - link using surrogate or natural key?

answered Apr 2, 2013 at 17:49

2 votes

Accepted

New Database vs New Table for User Registrations

answered Mar 22, 2013 at 13:55

0 votes

Database Design Regarding a Relationship for Patient Visit

answered Mar 18, 2013 at 19:19

1 vote

Right Join vs Left Join - My joins are broken and I don't understand why

answered Mar 14, 2013 at 21:00

1 vote

Large time difference between two almost identical simple queries....why?

answered Mar 7, 2013 at 18:37

2 votes

Best practices for history/temporal tables?

answered Feb 27, 2013 at 23:05

0 votes

SSIS Validation slow. OLTP OLAP running on same server

answered Feb 25, 2013 at 14:58

2 votes

How to have a one-to-many relationship with a privileged child?

answered Feb 5, 2013 at 15:44

Stack Exchange Network

93 Answers

Column name naming conventions and best practices

Data - Changes Audit Trail

Convert varchar column to datetime

Database Design question, calculate or save financial positions

PRIMARY KEY CONSTRAINT fundamentals

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

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

How to handle huge table

Is it safe to change the name of a database?

Optimisation Newbie: How much of a 'sin' is redundancy?

Editing built-in templates in Management Studio

How could DBAs be more 'programmer friendly'?

Views - Indexes/Keys/Execution Plans

How to migrate data between "all-surrogate" databases?

Is this a good strategy for importing a large amount of data and decomposing as an ETL?

Find procedures that haven't been called in <n> days

SQL Server transaction log growing without control

Left Join not giving desired result

MySQL: Join one Row in a table with two Rows in other table

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

SQL Server BULK INSERT

SSIS keeps force changing excel source string to float

Foreign keys - link using surrogate or natural key?

New Database vs New Table for User Registrations

Database Design Regarding a Relationship for Patient Visit

Right Join vs Left Join - My joins are broken and I don't understand why

Large time difference between two almost identical simple queries....why?

Best practices for history/temporal tables?

SSIS Validation slow. OLTP OLAP running on same server

How to have a one-to-many relationship with a privileged child?