788 reputation
411
bio website spartansql.com
location Minnesota
age
visits member for 3 years, 9 months
seen Oct 17 at 21:15

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


Sep
24
awarded  Autobiographer
Sep
10
comment Database Properties Error - sys.spt_values missing but dbo.spt_values works?
On a lark, have you tried connecting over the DAC?
Sep
1
awarded  Popular Question
Aug
19
comment Troubleshoot of WRITELOG on new machine running very slow?
From your description, it seems like these are the exact same operations just on different servers. Is that accurate? That is, there's not a change in anything like the batch size for your select into or how many tables are being created in one transaction? How about the recovery model of each db?
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.