3,428 reputation
1023
bio website
location
age
visits member for 2 years, 8 months
seen 15 hours ago

Huge fan of SQL Server, I've been searching for opportunities to work on more MSSQL projects which is why I'm here.

I have been working in mixed environments with a combination of MySQL, PostgreSQL, LDAP and SQL Server for the past 15 years.


Jul
19
comment MongoDB only three of four shards being used
Hello Adam, working on 202 now and got a chance to redo the cluster and replications sets. Stopping the balancer before inserts did the trick.
Jul
19
accepted MongoDB only three of four shards being used
Jul
19
revised Open Transaction that won't go away SPID Ns
added 142 characters in body
Jul
19
comment Open Transaction that won't go away SPID Ns
Thanks again, problem solved by adding MSReplications_subscriptions table to the database where sp_vupgrade_replication was failing
Jul
19
accepted Open Transaction that won't go away SPID Ns
Jul
18
comment Open Transaction that won't go away SPID Ns
Thanks Shanky, I forgot to enable the trace flag before restarting. I'll have to wait for the next restart before attempting again.
Jul
18
revised Open Transaction that won't go away SPID Ns
deleted 57 characters in body
Jul
18
revised Open Transaction that won't go away SPID Ns
added 16 characters in body
Jul
18
comment Open Transaction that won't go away SPID Ns
Updated my answer
Jul
18
comment Open Transaction that won't go away SPID Ns
Updated my answer
Jul
18
revised Open Transaction that won't go away SPID Ns
added 784 characters in body
Jul
18
comment Open Transaction that won't go away SPID Ns
Found the error. spid7s Error executing sp_vupgrade_replication. I am following the resolution steps now
Jul
18
asked Open Transaction that won't go away SPID Ns
Jul
18
comment Optimising a query against sys.fn_dblog
Hello and thanks for your answer. I read on sqlskills that using fn_dump_dblog will create additional scheduler threads that don't go away, which is why I've avoided it. Is this true? sqlskills.com/blogs/paul/…
Jul
8
comment Starting up postgres on Ubuntu for the first time
Perhaps the user you are executing postgres with doesn't have RW access to /var/run/postgresql/?
Jul
8
answered Optimizing large table in mysql
Jul
4
comment Optimizing large table in mysql
What are you trying to accomplish exactly? The OPTIMIZE command in MySQL terms just means reclaiming space and reorganizing physical storage of data. So are you trying to reclaim space or make your queries run faster?
Jul
3
revised Options to include with mysqldump when taking backup of hybrid databases
edited body
Jul
3
revised How to create a second socket for mysqld
added 1 character in body
Jul
3
comment How to create a second socket for mysqld
@PiTheNumber, okay, updated my answer with another solution