User DForck42

7 votes

Is this a standard way to design a database?

answered Sep 28, 2011 at 19:08

7 votes

Should dbo schema be avoided?

answered Dec 7, 2011 at 21:27

6 votes

Accepted

What units is Page Life Expectancy in?

answered Oct 12, 2011 at 19:13

5 votes

Storing date as integer (numeric), what are the advantages

answered Mar 27, 2012 at 15:33

5 votes

Accepted

Recommendations on creating user-objects on system database

answered Mar 27, 2012 at 18:21

5 votes

Why are periodic restarts required to keep my instance performing well?

answered Apr 4, 2012 at 15:12

5 votes

Why do people recommend not using the name "Id" for an identity column?

answered Apr 17, 2012 at 15:16

4 votes

Accepted

Beginner design of biological sampling database

answered Apr 5, 2012 at 5:40

4 votes

Identical(?) SQL Server 2005 machines; query takes 2sec on one, 15min on the other

answered Oct 6, 2011 at 15:06

4 votes

Accepted

What is the impact of large varchar data types on indexing?

answered Mar 15, 2012 at 17:29

3 votes

Stored Procedure stuck at waitfor delay '00:00:02'

answered Apr 12, 2018 at 14:07

3 votes

Why is this Full Outer Join not working?

answered Mar 21, 2012 at 15:55

2 votes

Best practice - Update Primary Keys

answered Feb 9, 2015 at 22:09

2 votes

SQL Maintenance Rebuild Fails

answered Feb 3, 2015 at 21:14

2 votes

Convert datetime to europe default without time

answered Aug 27, 2012 at 15:09

2 votes

SQL services wont start due to incorrect drive letter after windows restore

answered Jan 21, 2013 at 21:54

2 votes

Accepted

Replication error: the principal "dbo" does not exist

answered Jul 16, 2013 at 13:51

2 votes

Why are Stored Procedure schema changes not being replicated when using ”initialize with backup”?

answered Mar 16, 2012 at 16:33

1 vote

Issue with CAST using linked servers (possible bug?)

answered Mar 16, 2012 at 18:07

1 vote

Create an Audit trail on SQL Server 2008 to trace all privilege users

answered Mar 16, 2012 at 18:17

1 vote

CTE Running in Infinite Loop

answered Apr 5, 2012 at 13:23

1 vote

SQL Server 2012 replication permissions with virtual user and agent credentials

answered Mar 15, 2012 at 17:35

1 vote

How often do you back up the distribution database for transactional replication when sync with backup is set to true for the distribution database?

answered Mar 15, 2012 at 17:39

1 vote

Mathematical method for spotting irregularity in numbers flow

answered Jan 13, 2015 at 21:58

1 vote

Run a report by specifying which server to execute the query on

answered Jan 21, 2015 at 22:28

1 vote

Multiple instances of same foreign key in a single table

answered Feb 3, 2015 at 21:23

1 vote

1 hour query, is there another way to do this?

answered Feb 6, 2015 at 21:02

1 vote

How to create a summary report that contains other reports?

answered Jul 3, 2012 at 19:44

0 votes

SQL server indexing foreign keys, covering indexes included columns

answered Jul 3, 2012 at 19:49

0 votes

Accepted

Odd error when stress testing against an AG

answered Oct 4, 2018 at 14:15

Stack Exchange Network

41 Answers

Is this a standard way to design a database?

Should dbo schema be avoided?

What units is Page Life Expectancy in?

Storing date as integer (numeric), what are the advantages

Recommendations on creating user-objects on system database

Why are periodic restarts required to keep my instance performing well?

Why do people recommend not using the name "Id" for an identity column?

Beginner design of biological sampling database

Identical(?) SQL Server 2005 machines; query takes 2sec on one, 15min on the other

What is the impact of large varchar data types on indexing?

Stored Procedure stuck at waitfor delay '00:00:02'

Why is this Full Outer Join not working?

Best practice - Update Primary Keys

SQL Maintenance Rebuild Fails

Convert datetime to europe default without time

SQL services wont start due to incorrect drive letter after windows restore

Replication error: the principal "dbo" does not exist

Why are Stored Procedure schema changes not being replicated when using ”initialize with backup”?

Issue with CAST using linked servers (possible bug?)

Create an Audit trail on SQL Server 2008 to trace all privilege users

CTE Running in Infinite Loop

SQL Server 2012 replication permissions with virtual user and agent credentials

How often do you back up the distribution database for transactional replication when sync with backup is set to true for the distribution database?

Mathematical method for spotting irregularity in numbers flow

Run a report by specifying which server to execute the query on

Multiple instances of same foreign key in a single table

1 hour query, is there another way to do this?

How to create a summary report that contains other reports?

SQL server indexing foreign keys, covering indexes included columns

Odd error when stress testing against an AG