User Matt

10 votes

Why don't databases create their own indexes automatically?

answered Jun 8, 2013 at 17:57

6 votes

Unable to restore database backup because it is accessed by other connection

answered May 19, 2015 at 16:10

5 votes

Accepted

sql server 2014 unable to connect with Microsoft account or sa

answered May 27, 2015 at 8:49

4 votes

Accepted

Header and line item data source mismatch

answered Apr 25, 2013 at 10:12

3 votes

MDF and LDF contents in SQL Server

answered Sep 23, 2012 at 15:15

3 votes

Accepted

Is worth change databases collation from Latin1_General to Modern spanish, migrating to a new server

answered May 19, 2015 at 12:34

3 votes

Accepted

Select Column value based on two values in another column

answered May 20, 2015 at 11:49

3 votes

When Should You Shrink Your Database

answered May 24, 2015 at 13:23

2 votes

migrate db's - best way to mirror or replicate a full database

answered May 20, 2015 at 15:17

2 votes

What is the most effective way to discover all running instances of SQL Server using PowerShell?

answered May 19, 2015 at 14:20

2 votes

Accepted

SQL self join with condition

answered May 19, 2015 at 21:06

2 votes

How to confirm if the backups are going to tape in SQL Server 2005 and 2008 R2

answered May 7, 2015 at 8:59

2 votes

Pulling data from identical tables in different databases

answered Jan 28, 2014 at 13:32

1 vote

What is the benefit of two FK, when one of them can be deduced from another table?

answered Apr 25, 2013 at 12:36

1 vote

Help with modeling this table

answered Apr 25, 2013 at 13:16

1 vote

Accepted

Can I have more than one relationship between two tables?

answered May 18, 2015 at 13:51

1 vote

Accepted

MySQL Pivot Table Dynamic Rows

answered May 19, 2015 at 10:27

1 vote

Accepted

Single query for searching for records without knowing what the search column is for

answered May 19, 2015 at 11:11

1 vote

Accepted

Which of these database designs is normalized?

answered May 20, 2015 at 9:58

1 vote

Linked Server Risks

answered Apr 20, 2013 at 10:47

1 vote

Find all tables that are related to a view recursively sql server

answered May 27, 2015 at 11:10

1 vote

Is Primary Key Non Clustered recommended?

answered May 27, 2015 at 13:39

1 vote

Accepted

Optimizing a query that performs worse on a smaller dataset

answered May 28, 2015 at 9:22

0 votes

Initials separated by periods (e.g. J.E.F. Smith)

answered May 29, 2015 at 9:22

0 votes

Database Design - Cardinality

answered May 19, 2015 at 9:02

0 votes

Does varchar size matter in temporary tables?

answered Nov 17, 2012 at 13:49

0 votes

Create Table Script in SQL Server 2008 R2?

answered Mar 26, 2014 at 11:18

0 votes

Combine datetime + string to make a proper datetime

answered Jul 8, 2013 at 15:39

Stack Exchange Network

28 Answers

Why don't databases create their own indexes automatically?

Unable to restore database backup because it is accessed by other connection

sql server 2014 unable to connect with Microsoft account or sa

Header and line item data source mismatch

MDF and LDF contents in SQL Server

Is worth change databases collation from Latin1_General to Modern spanish, migrating to a new server

Select Column value based on two values in another column

When Should You Shrink Your Database

migrate db's - best way to mirror or replicate a full database

What is the most effective way to discover all running instances of SQL Server using PowerShell?

SQL self join with condition

How to confirm if the backups are going to tape in SQL Server 2005 and 2008 R2

Pulling data from identical tables in different databases

What is the benefit of two FK, when one of them can be deduced from another table?

Help with modeling this table

Can I have more than one relationship between two tables?

MySQL Pivot Table Dynamic Rows

Single query for searching for records without knowing what the search column is for

Which of these database designs is normalized?

Linked Server Risks

Find all tables that are related to a view recursively sql server

Is Primary Key Non Clustered recommended?

Optimizing a query that performs worse on a smaller dataset

Initials separated by periods (e.g. J.E.F. Smith)

Database Design - Cardinality

Does varchar size matter in temporary tables?

Create Table Script in SQL Server 2008 R2?

Combine datetime + string to make a proper datetime