Mike Fal's user avatar
Mike Fal's user avatar
Mike Fal's user avatar
Mike Fal
  • Member for 11 years, 8 months
  • Last seen more than 2 years ago
204 votes

How do I move SQL Server database files?

74 votes
Accepted

After moving database (backup, restore), I have to re-add user

46 votes

How to query a database for empty tables

38 votes
Accepted

SQL-Server - Grant user DBO permission on database

31 votes
Accepted

Max Connection Pool capped at 100

29 votes
Accepted

Give permission to select from system tables

28 votes
Accepted

24x7 vs Night Time Window

25 votes

Query to report disk space allocation and used space

22 votes

Difference between DROP and TRUNCATE

21 votes

Indexing a PK GUID in SQL Server 2012

20 votes

Move multiple databases from C: to D: at once

18 votes

What is shared between two instances on the same server?

17 votes
Accepted

Create new database with large initial size

15 votes

How can I compare the schema of two databases?

14 votes
Accepted

Is table partitioning improving performance? Is it worth it?

14 votes
Accepted

What is the different between compression on the PK vs. on the Table?

14 votes
Accepted

Shrink a large log file for a "Throw Away" database

13 votes
Accepted

Moving rows from one table to another

13 votes
Accepted

How do you move a SQL Server 7 database to SQL Server 2012?

12 votes
Accepted

How to get a list of global temporary tables in the current database?

11 votes

Manually set log file size after shrink SQL Server 2008 R2

11 votes
Accepted

Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery

11 votes
Accepted

Transaction with multiple SQLCMD calls in a batch file

10 votes

SQL Server- Table partitions on SSD

10 votes
Accepted

Estimating IO Requirements for Bursty Usage

10 votes
Accepted

Which is better: many join conditions or many where conditions?

10 votes

Shrink database operation in maintenance plan failed

10 votes
Accepted

Compressions vs shrinking a database

9 votes
Accepted

Steal ownership on database from user that no longer exists

9 votes
Accepted

Is there a way to list the "last backup" file of a Database?

1
2 3 4 5