758 reputation
49
bio website spartansql.com
location Minnesota
age
visits member for 3 years, 6 months
seen yesterday

A SQL Server DBA living and working in the Twin Cities. Professional interests include replication and T-SQL programming.


Jun
6
awarded  Notable Question
Jun
4
answered How to make snapshot for new tables only
May
28
comment SQL Server Deadlock - Two SELECT Exclusive Locks on Exact Same Index and Key
Is it possible that they were both waiting to escalate the lock from row -> page or page -> table? If so, the other select would prevent that from happening. Also, what's the transaction isolation level of each process?
May
2
answered Backup and Restore of Development
May
2
answered Mirroring between two Ms-sql servers for Migrating server from one Datacenter to other Datacenter
May
1
comment SQL Server 2012 Simple Recovery Model with LOG_BACKUP log_reuse_wait_desc
This is KB 2830400 (support.microsoft.com/kb/2830400) and is fixed in SP1 CU4 or RTM CU7. Just in case CU5 was too much.
Apr
30
comment AlwaysOn Availability Group Automatic Failover does not work
What does your quorum model look like? Is it a simple node majority? If so, that could be your problem. From technet.microsoft.com/en-us/library/cc731739.aspx, that quorum model can only sustain a loss of (half of the nodes in the cluster) -1. So, if you have a two node cluster with node majority quorum, you can sustain 0 node failures.
Apr
14
comment Slow performance of remote restore
The 100% I was referring to was the output from the restore process as a result of having added "with stats = 10" to the restore command.
Apr
14
comment Slow performance of remote restore
Yes, the backup files were remote to the DR system. I'm just confused by the apparent contradiction where it seemed to read the file quickly (or at least as quick as I'd have expected), but then was slow to actually complete the restore.
Apr
14
asked Slow performance of remote restore
Mar
20
comment Accidental Turn On of Replication
If my environment is any indication, no. All of mine are owned by distributor_admin. Besides, a lot of times, tearing down replication will remove the jobs as well.
Mar
19
answered Accidental Turn On of Replication
Mar
17
comment SQL Server 2008 replication and large data updates
I'd question why you're doing a nuke and pave daily. Replication is designed to keep two tables in sync. If you delete all of the data and then insert all new data, that's a 2*(size of table) operation.
Mar
12
answered Oracle RAC Vs SQL Server Cluster
Feb
20
comment SQL ODBC silently truncating numeric data
You say that you have NUMERIC_ROUNDABORT on in SQL Server. How are you setting that for the replication process?
Feb
19
comment Trigger to restrict users from creating a new table in the database
Keep in mind that you will still have created the table. Its just that it gets rolled back. A small difference,but it may be important to you.
Jan
27
answered c# Backup sql server database, error Operating system error 5(Access is denied.)
Jan
24
answered Restoring Differential Backups
Jan
10
awarded  Yearling
Jan
7
answered SQL Server Replication breaks up after doing DBCC CheckDB with Allow data loss on Primary