Craig Efrein's user avatar
Craig Efrein's user avatar
Craig Efrein's user avatar
Craig Efrein
  • Member for 12 years, 3 months
  • Last seen this week
18 votes
3 answers
29k views

Automating failover in PostgreSQL 9.1

14 votes
1 answer
19k views

Setting variables in SQLCMD mode

14 votes
1 answer
21k views

Comparing two queries in SQL Server 2012

13 votes
3 answers
29k views

Tracking Down Application Timeout Errors in SQL Server

12 votes
2 answers
3k views

Does MERGE use tempdb?

11 votes
3 answers
2k views

DROP USER takes too long when there are many users

9 votes
2 answers
1k views

PostgreSQL PITR restore

8 votes
3 answers
16k views

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

7 votes
1 answer
2k views

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

7 votes
2 answers
11k views

Tracking down a stored procedure's parameters after execution

7 votes
2 answers
11k views

Execution-Policy Error running Powershell Script in SQL Server Agent

7 votes
1 answer
1k views

SQL Server 2008 R2 DMV Question

7 votes
1 answer
16k views

SQL Server backup fails on disk space error

6 votes
2 answers
4k views

How to update statistics for a database's system tables

5 votes
3 answers
2k views

After upgrade to 2016, can't view SQL Server Logs

5 votes
3 answers
813 views

Cardinality Estimator Question after 2014 SP1 + CU4 Upgrade

5 votes
3 answers
2k views

Efficiently remove 90% of a table's data

5 votes
3 answers
11k views

How to use variables with RESTORE FILELISTONLY

5 votes
2 answers
4k views

Shrinking a SQL Server Log File Multiple Times

5 votes
1 answer
4k views

Optimising a query against sys.fn_dblog

5 votes
2 answers
2k views

Error using triggers with SQL Server Profiler Tables

5 votes
1 answer
2k views

Can't update trigger because of activity

5 votes
1 answer
3k views

Failed Upgrade from SQL Server 2005 sp2 to SQL Server 2005 sp4

4 votes
0 answers
2k views

Why is loading data into MySQL cluster taking so long?

4 votes
2 answers
3k views

Querying Extended Events in SQL Server 2008

4 votes
1 answer
311 views

Most efficent DELETE Method

4 votes
2 answers
3k views

Question about non-clustered index storage in SQL Server

4 votes
2 answers
15k views

How to save and then restore permissions after refreshing a database

4 votes
1 answer
7k views

Dropping a table with powershell

3 votes
1 answer
3k views

How to avoid Forced reboots using unattended upgrades to SQL Server 2014