User Andy Jones

7 votes

VARCHAR primary key - MySQL

answered Oct 22, 2014 at 9:09

6 votes

Accepted

Computed Column Bit based on other Bit Columns

answered Mar 11, 2015 at 15:29

6 votes

Timeout error after SQL Server upgrade from 2008R2 to SQL Server 2014

answered Aug 24, 2016 at 18:15

6 votes

Accepted

SQL Server 2016: Temporal table performance vs. Triggers and CDC

answered Oct 19, 2016 at 10:31

6 votes

Accepted

Sql Server: A seemingly strange behaviour of BEGIN TRAN - COMMIT

answered Nov 2, 2016 at 14:27

5 votes

Should I disable the guest user on system databases

answered Oct 21, 2016 at 9:35

5 votes

Accepted

SQL Server stored procedure causing 100% CPU usage

answered Feb 6, 2015 at 9:43

4 votes

Why will my ALTER and UPDATE not work in the same query in this specific instance?

answered Oct 19, 2016 at 14:01

4 votes

SQL server Principal and Mirror logins and permissions Issue

answered Dec 20, 2016 at 15:17

3 votes

Scripted SQL Deployment in a Transaction with Rollback

answered Oct 21, 2016 at 13:20

3 votes

Accepted

Incorrect execution plan

answered Oct 12, 2016 at 14:10

3 votes

Accepted

Sql Server Stored Procs vs Linq with C# and unit testing

answered Aug 28, 2016 at 8:49

3 votes

Is it good idea to repair sql file?

answered Nov 7, 2014 at 11:29

3 votes

Accepted

SQL Server 2012 extended event session to expose the network protocol

answered Feb 11, 2015 at 15:14

2 votes

Make SqlClient default to ARITHABORT ON

answered Mar 12, 2015 at 8:33

2 votes

Accepted

Restrictions on creating new SQL tables?

answered Aug 24, 2016 at 9:43

2 votes

Capturing the result(print statements) of SP_UPDATESTATS

answered Aug 24, 2016 at 12:05

2 votes

Problems with Insert( simple query - can't think something )

answered Feb 11, 2015 at 10:35

2 votes

SQL Server Performance

answered Oct 22, 2014 at 13:24

2 votes

Index file - size changed

answered Oct 22, 2014 at 15:25

2 votes

How to determine the size of my tables in the SQL Server database

answered Oct 28, 2014 at 7:40

2 votes

Accepted

SQL to combine records only if data is available

answered Aug 24, 2016 at 18:06

2 votes

SQL Server 2016 on Microsoft Failover cluster

answered Oct 13, 2016 at 9:44

2 votes

Accepted

Left Joining Tables with tables that have subquery aggregate

answered Oct 31, 2016 at 19:49

2 votes

SQL Server Memory allocation and max server memory setting

answered Oct 19, 2016 at 9:31

2 votes

Accepted

Multi-Instance Failover Cluster SQL Cluster

answered Nov 1, 2016 at 12:53

1 vote

SSIS Promote Package - Move Some Stored Procedures

answered Nov 1, 2016 at 15:54

1 vote

Restore a SQL 7 database into SQL 2014 without in-between versions?

answered Nov 2, 2016 at 15:01

1 vote

Implementing audit trail ms sql using stored procedure

answered Nov 1, 2016 at 9:28

1 vote

Accepted

Precautions for moving a SQL cluster from an old to a new datastore

answered Oct 22, 2016 at 13:12

Stack Exchange Network

59 Answers

VARCHAR primary key - MySQL

Computed Column Bit based on other Bit Columns

Timeout error after SQL Server upgrade from 2008R2 to SQL Server 2014

SQL Server 2016: Temporal table performance vs. Triggers and CDC

Sql Server: A seemingly strange behaviour of BEGIN TRAN - COMMIT

Should I disable the guest user on system databases

SQL Server stored procedure causing 100% CPU usage

Why will my ALTER and UPDATE not work in the same query in this specific instance?

SQL server Principal and Mirror logins and permissions Issue

Scripted SQL Deployment in a Transaction with Rollback

Incorrect execution plan

Sql Server Stored Procs vs Linq with C# and unit testing

Is it good idea to repair sql file?

SQL Server 2012 extended event session to expose the network protocol

Make SqlClient default to ARITHABORT ON

Restrictions on creating new SQL tables?

Capturing the result(print statements) of SP_UPDATESTATS

Problems with Insert( simple query - can't think something )

SQL Server Performance

Index file - size changed

How to determine the size of my tables in the SQL Server database

SQL to combine records only if data is available

SQL Server 2016 on Microsoft Failover cluster

Left Joining Tables with tables that have subquery aggregate

SQL Server Memory allocation and max server memory setting

Multi-Instance Failover Cluster SQL Cluster

SSIS Promote Package - Move Some Stored Procedures

Restore a SQL 7 database into SQL 2014 without in-between versions?

Implementing audit trail ms sql using stored procedure

Precautions for moving a SQL cluster from an old to a new datastore