user avatar
user avatar
user avatar
Andy Jones
  • Member for 7 years, 7 months
  • Last seen more than a month ago
  • Wales, United Kingdom
7 votes

VARCHAR primary key - MySQL

6 votes
Accepted

Computed Column Bit based on other Bit Columns

6 votes

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

6 votes
Accepted

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

6 votes
Accepted

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

5 votes

Should I disable the guest user on system databases

5 votes
Accepted

SQL Server stored procedure causing 100% CPU usage

4 votes

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

4 votes

SQL server Principal and Mirror logins and permissions Issue

3 votes

Scripted SQL Deployment in a Transaction with Rollback

3 votes
Accepted

Incorrect execution plan

3 votes

Is it good idea to repair sql file?

3 votes
Accepted

SQL Server 2012 extended event session to expose the network protocol

2 votes

Make SqlClient default to ARITHABORT ON

2 votes
Accepted

Restrictions on creating new SQL tables?

2 votes

Capturing the result(print statements) of SP_UPDATESTATS

2 votes

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

2 votes

SQL Server Performance

2 votes

Index file - size changed

2 votes

SQL Server 2016 on Microsoft Failover cluster

2 votes

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

2 votes
Accepted

SQL to combine records only if data is available

2 votes
Accepted

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

2 votes
Accepted

Left Joining Tables with tables that have subquery aggregate

2 votes

SQL Server Memory allocation and max server memory setting

2 votes
Accepted

Multi-Instance Failover Cluster SQL Cluster

1 vote

SSIS Promote Package - Move Some Stored Procedures

1 vote

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

1 vote

Implementing audit trail ms sql using stored procedure

1 vote
Accepted

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