Skip to main content
paulH's user avatar
paulH's user avatar
paulH's user avatar
paulH
  • Member for 11 years, 10 months
  • Last seen this week
  • West Yorkshire, United Kingdom
11 votes
3 answers
273 views

One index or two?

9 votes
1 answer
11k views

Improve speed of index rebuild on SQL server

8 votes
2 answers
7k views

Clustered index compression vs table compression - are they the same thing?

8 votes
1 answer
7k views

Restore MSDB data to a new server

8 votes
2 answers
335 views

'Cleanse' a SQL Server database file created with Instant File Initialization enabled?

7 votes
1 answer
4k views

SQL Server database backup file is double final size until backup completes

6 votes
2 answers
4k views

Tracking down a transaction rollback

6 votes
1 answer
234 views

Drillthrough action on semi-additive measure group

5 votes
1 answer
6k views

How to disable or delete an index

5 votes
2 answers
5k views

Manually moving SQL instance to another node causes immediate database mirror failover

5 votes
1 answer
1k views

Don't rebuild indexes < 1000 pages - then why bother having them?

4 votes
0 answers
2k views

Auditing access to a linked server

4 votes
1 answer
1k views

Oldest unsent transaction alert for Availability Group

3 votes
1 answer
1k views

MAXTRANSFERSIZE setting causes restore to fail

3 votes
1 answer
4k views

Page Lookups Percentage - SQL Server performance monitoring

3 votes
1 answer
574 views

Can you restore log file backups to a mirror database after failure?

3 votes
2 answers
3k views

Where to put ReportServer and ReportServerTempDB databases?

2 votes
1 answer
102 views

indexes with unspecific columns

2 votes
0 answers
406 views

always on availability group with different speed disks

2 votes
1 answer
1k views

SQL Server Management Studio 2012 - horrible blue background [closed]

2 votes
1 answer
181 views

Meaning of SQLIO output "counts per second"

2 votes
3 answers
7k views

Check if SQL Agent job is being executed manually

2 votes
1 answer
5k views

SQL Server - register Service Principle Name without service restart?

1 vote
1 answer
848 views

view current session roles for another session

1 vote
1 answer
1k views

Get the size of all Azure SQL Databases

1 vote
1 answer
135 views

SSIS Execute Package task is slow to start running the first time

1 vote
0 answers
31 views

Process dimension task is querying the wrong column!

1 vote
1 answer
792 views

SQL Server 64-bit - Import from Excel

1 vote
1 answer
2k views

SQL Server connection from iis website: "error: 26 - Error Locating Server/Instance Specified"

1 vote
0 answers
43 views

How to restrict SQL Server database access to application or server running the application [duplicate]