Craig Efrein

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.

top accounts reputation activity subscriptions

Automating failover in PostgreSQL 9.1

postgresql failover asked Dec 22, 2011 at 10:29

dba.stackexchange.com

14 votes

Setting variables in SQLCMD mode

sql-server sql-server-2008-r2 sqlcmd asked Jul 12, 2013 at 12:04

dba.stackexchange.com

14 votes

Comparing two queries in SQL Server 2012

sql-server-2012 performance query-performance asked Nov 21, 2013 at 10:04

dba.stackexchange.com

13 votes

Tracking Down Application Timeout Errors in SQL Server

sql-server query-timeout connection-timeout asked Oct 14, 2014 at 15:51

dba.stackexchange.com

12 votes

Does MERGE use tempdb?

sql-server t-sql asked Jul 18, 2013 at 9:12

dba.stackexchange.com

11 votes

DROP USER takes too long when there are many users

sql-server security asked Jun 1, 2016 at 9:03

dba.stackexchange.com

9 votes

PostgreSQL PITR restore

postgresql backup recovery asked Jun 29, 2012 at 15:15

dba.stackexchange.com

8 votes

After Upgrade to 2016, SQL Server Agent can't connect to Instance

sql-server upgrade sql-server-2016 asked Jun 6, 2016 at 9:59

dba.stackexchange.com

7 votes

In-Memory Optimized Error: The code generation directory cannot be created or set up correctly

sql-server sql-server-2016 memory-optimized-tables asked Mar 29, 2017 at 8:47

dba.stackexchange.com

7 votes

SQL Server backup fails on disk space error

sql-server sql-server-2008-r2 backup asked Sep 25, 2013 at 12:43

dba.stackexchange.com

Top Answers

I need to run VACUUM FULL with no available disk space

dba.stackexchange.com

What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?

dba.stackexchange.com

I dropped MySQL's `performance_schema` database, how can I create it?

dba.stackexchange.com

How to update 10 million+ rows in MySQL single table as Fast as possible?

dba.stackexchange.com

What to set innodb_buffer_pool and why..?

dba.stackexchange.com

SQL Server data folder access rights

dba.stackexchange.com

pg_dump custom format between postgres versions

dba.stackexchange.com

Mirroring - Server network address cannot be reached

dba.stackexchange.com

If exists then update else insert

dba.stackexchange.com

GROUP BY with MAX versus just MAX

dba.stackexchange.com

After Upgrade to 2016, SQL Server Agent can't connect to Instance

dba.stackexchange.com

Does an empty column value occupy same storage space as a filled column value?

dba.stackexchange.com

How to promote an existing index to primary key in PostgreSQL

dba.stackexchange.com

Temporarily Disable Sql Replication

dba.stackexchange.com

SQL Server : keep track of all connections/disconnections

dba.stackexchange.com

What memory should be given to the variables of my.cnf ?

dba.stackexchange.com

How to extract pipe-delimited data using BCP?

dba.stackexchange.com

Script to show MySQL health status?

dba.stackexchange.com

Tracking Down Application Timeout Errors in SQL Server

dba.stackexchange.com

How can I check for stored procedure consistency across multiples servers

dba.stackexchange.com

Who created a procedure? (SQL Server 2008 R2 )

dba.stackexchange.com

How to upgrade a SQL 2000 Database to SQL 2005 - need confirmation?

dba.stackexchange.com

Query taking non-consistent time to execute

dba.stackexchange.com

Running the DBT2 test results in 0.00 NOTPM

dba.stackexchange.com

Aggressive Autovacuum on PostgreSQL

dba.stackexchange.com

DBCC SHRINKDATABASE TRUNCATEONLY - 2008R2 vs 2012

dba.stackexchange.com

Grant postgres superuser to linux account

dba.stackexchange.com

DROP USER takes too long when there are many users

dba.stackexchange.com

Can't connect to MySQL database over SSH with Workbench

dba.stackexchange.com

Slow MySQL Database Import with mysqldump and USE .. SOURCE

dba.stackexchange.com