Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
Pete Carter's user avatar
Pete Carter's user avatar
Pete Carter's user avatar
Pete Carter
  • Member for 11 years, 8 months
  • Last seen more than 4 years ago
29 votes
Accepted

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

17 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