Skip to main content
Pete Carter's user avatar
Pete Carter's user avatar
Pete Carter's user avatar
Pete Carter
  • Member for 11 years, 9 months
  • Last seen more than 4 years ago
29 votes
Accepted

Why do we need to rebuild and reorganize Indexes in SQL Server

18 votes
Accepted

Can I change table structure in a transaction and then roll it back if there is an error?

9 votes
Accepted

Security and Performance implications of "View Server State"

8 votes

Partition Key questions in SQL Server 2008

7 votes

Can the transaction log in SQL Server 2008 Express edition be viewed in text?

6 votes

Should I rely on Database Engine Tuning Advisor for creating indexes?

4 votes
Accepted

Why index REBUILD does not reduce index fragmentatation with a page count > 1000?

3 votes
Accepted

How can I copy specific tables into one SQL Server Table into a separate table automatically?

3 votes

Help with a multi-language medical database

3 votes

IN Clause causes Execution plan to change from Nested Loops to Hash Match

3 votes
Accepted

Merging tables with a 1 to 1 relationship in a database

2 votes

sql server session revert

2 votes

SQL Server Service Account on Windows Server 2016 Workgroup Cluster

2 votes

Investigating/Troubleshooting I/O Spikes

2 votes

SQL Server WMI Event Alert and BROKER_TASK_STOP waits

2 votes
Accepted

How to check if there is partitions in use in fact tables?

1 vote
Accepted

Selecting the right data type for text

1 vote

SQL Server 2012 CPU core usage

1 vote

correct security and user setup for SQL Server database

1 vote

Difficult categorising of rows

1 vote

Can you set up a SQL server maintenance plan to restore a database?

0 votes

help in multi-language medical database?

0 votes
Accepted

Can I replicate to a pre-existing database?

0 votes

How do I find I.O. statistics (by index) for queries in progress