User Craig Efrein

31 votes

Accepted

I need to run VACUUM FULL with no available disk space

answered Apr 27, 2012 at 10:14

20 votes

Accepted

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

answered Dec 2, 2011 at 7:52

20 votes

Accepted

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

answered Jan 15, 2014 at 15:58

18 votes

Accepted

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

answered Oct 30, 2015 at 12:45

15 votes

Accepted

SQL Server data folder access rights

answered Aug 27, 2015 at 8:26

15 votes

What to set innodb_buffer_pool and why..?

answered Jun 13, 2012 at 9:48

13 votes

Mirroring - Server network address cannot be reached

answered Sep 7, 2012 at 16:52

13 votes

Accepted

pg_dump custom format between postgres versions

answered Oct 21, 2013 at 8:06

13 votes

If exists then update else insert

answered Apr 29, 2015 at 11:57

12 votes

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

answered Jun 6, 2016 at 10:27

12 votes

Accepted

GROUP BY with MAX versus just MAX

answered Oct 28, 2013 at 10:55

11 votes

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

answered Aug 6, 2015 at 14:23

10 votes

How to promote an existing index to primary key in PostgreSQL

answered Dec 15, 2011 at 15:01

9 votes

Accepted

Temporarily Disable Sql Replication

answered Feb 14, 2012 at 15:38

9 votes

Accepted

SQL Server : keep track of all connections/disconnections

answered Dec 5, 2013 at 9:30

8 votes

Accepted

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

answered Dec 5, 2011 at 7:03

8 votes

How to extract pipe-delimited data using BCP?

answered Aug 18, 2015 at 8:21

7 votes

Accepted

Who created a procedure? (SQL Server 2008 R2 )

answered Aug 5, 2015 at 14:45

7 votes

Accepted

Tracking Down Application Timeout Errors in SQL Server

answered Oct 15, 2014 at 13:07

7 votes

How can I check for stored procedure consistency across multiples servers

answered Nov 21, 2014 at 8:45

7 votes

Script to show MySQL health status?

answered May 10, 2012 at 16:41

6 votes

Accepted

Running the DBT2 test results in 0.00 NOTPM

answered Jul 30, 2013 at 15:44

6 votes

Aggressive Autovacuum on PostgreSQL

answered Jul 18, 2012 at 16:30

6 votes

Query taking non-consistent time to execute

answered Jul 23, 2013 at 10:26

6 votes

Accepted

DBCC SHRINKDATABASE TRUNCATEONLY - 2008R2 vs 2012

answered Nov 8, 2013 at 14:27

6 votes

Accepted

Grant postgres superuser to linux account

answered Dec 2, 2013 at 13:09

6 votes

Accepted

DROP USER takes too long when there are many users

answered Jun 6, 2016 at 7:49

5 votes

Accepted

Mysql error "#1030 - Got error -1 from storage engine" when doing insert/update queries

answered Aug 22, 2015 at 7:33

5 votes

Accepted

Cannot configure nor start MySQL

answered Aug 18, 2014 at 9:46

5 votes

Accepted

Check all MySQL tables at once

answered Nov 5, 2013 at 14:04

Stack Exchange Network

157 Answers

I need to run VACUUM FULL with no available disk space

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

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

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

SQL Server data folder access rights

What to set innodb_buffer_pool and why..?

Mirroring - Server network address cannot be reached

pg_dump custom format between postgres versions

If exists then update else insert

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

GROUP BY with MAX versus just MAX

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

How to promote an existing index to primary key in PostgreSQL

Temporarily Disable Sql Replication

SQL Server : keep track of all connections/disconnections

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

How to extract pipe-delimited data using BCP?

Who created a procedure? (SQL Server 2008 R2 )

Tracking Down Application Timeout Errors in SQL Server

How can I check for stored procedure consistency across multiples servers

Script to show MySQL health status?

Running the DBT2 test results in 0.00 NOTPM

Aggressive Autovacuum on PostgreSQL

Query taking non-consistent time to execute

DBCC SHRINKDATABASE TRUNCATEONLY - 2008R2 vs 2012

Grant postgres superuser to linux account

DROP USER takes too long when there are many users

Mysql error "#1030 - Got error -1 from storage engine" when doing insert/update queries

Cannot configure nor start MySQL

Check all MySQL tables at once