User Andy Jones

1 vote

Accepted

SQL Server Management Studio SSMS 18.0 General Availability release (GA) install fails

answered May 1, 2019 at 12:35

0 votes

Best way to merge tightly coupled SQL Server Instances

answered Dec 20, 2016 at 15:57

4 votes

SQL server Principal and Mirror logins and permissions Issue

answered Dec 20, 2016 at 15:17

0 votes

Who started the SQL Server Agent?

answered Nov 10, 2016 at 11:16

0 votes

SQL Transactional Replication and Table level compression

answered Nov 2, 2016 at 17:26

1 vote

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

answered Nov 2, 2016 at 15:01

6 votes

Accepted

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

answered Nov 2, 2016 at 14:27

1 vote

how to query multiple junction tables to create 1 record

answered Nov 2, 2016 at 10:17

0 votes

Days between two days by month SQL

answered Nov 2, 2016 at 10:06

1 vote

SQL query for number of users

answered Nov 1, 2016 at 20:51

0 votes

Update statistics more often and stop defragmenting indexes

answered Nov 1, 2016 at 17:19

0 votes

Setting up an alert to monitor where/when your databases are backed up

answered Nov 1, 2016 at 16:55

1 vote

SSIS Promote Package - Move Some Stored Procedures

answered Nov 1, 2016 at 15:54

2 votes

Accepted

Multi-Instance Failover Cluster SQL Cluster

answered Nov 1, 2016 at 12:53

1 vote

Implementing audit trail ms sql using stored procedure

answered Nov 1, 2016 at 9:28

0 votes

Backing up MS SQL Server database creates a huge transation log

answered Oct 31, 2016 at 20:03

2 votes

Accepted

Left Joining Tables with tables that have subquery aggregate

answered Oct 31, 2016 at 19:49

0 votes

ssis control flow loop

answered Oct 25, 2016 at 21:31

0 votes

What is the best way to keep track of all changes implemented on a database?

answered Oct 25, 2016 at 17:30

1 vote

Accepted

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

answered Oct 22, 2016 at 13:12

0 votes

Sql Where statement dynamic with case

answered Oct 21, 2016 at 15:53

3 votes

Scripted SQL Deployment in a Transaction with Rollback

answered Oct 21, 2016 at 13:20

0 votes

Too many VLFs - How do I truncate them?

answered Oct 21, 2016 at 9:50

1 vote

Launch a stored procedure when a datetime is expired

answered Oct 21, 2016 at 9:39

5 votes

Should I disable the guest user on system databases

answered Oct 21, 2016 at 9:35

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

6 votes

Accepted

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

answered Oct 19, 2016 at 10:31

2 votes

SQL Server Memory allocation and max server memory setting

answered Oct 19, 2016 at 9:31

0 votes

AlwaysOn AG between 2 sql server failover clusters

answered Oct 18, 2016 at 15:26

1 vote

Enrolling for Microsoft SQL Server related Newsletters from Microsoft

answered Oct 14, 2016 at 7:46

Stack Exchange Network

59 Answers

SQL Server Management Studio SSMS 18.0 General Availability release (GA) install fails

Best way to merge tightly coupled SQL Server Instances

SQL server Principal and Mirror logins and permissions Issue

Who started the SQL Server Agent?

SQL Transactional Replication and Table level compression

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

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

how to query multiple junction tables to create 1 record

Days between two days by month SQL

SQL query for number of users

Update statistics more often and stop defragmenting indexes

Setting up an alert to monitor where/when your databases are backed up

SSIS Promote Package - Move Some Stored Procedures

Multi-Instance Failover Cluster SQL Cluster

Implementing audit trail ms sql using stored procedure

Backing up MS SQL Server database creates a huge transation log

Left Joining Tables with tables that have subquery aggregate

ssis control flow loop

What is the best way to keep track of all changes implemented on a database?

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

Sql Where statement dynamic with case

Scripted SQL Deployment in a Transaction with Rollback

Too many VLFs - How do I truncate them?

Launch a stored procedure when a datetime is expired

Should I disable the guest user on system databases

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

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

SQL Server Memory allocation and max server memory setting

AlwaysOn AG between 2 sql server failover clusters

Enrolling for Microsoft SQL Server related Newsletters from Microsoft