Skip to main content
GaTechThomas's user avatar
GaTechThomas's user avatar
GaTechThomas's user avatar
GaTechThomas
  • Member for 11 years, 10 months
  • Last seen this week
8 votes
2 answers
4k views

Partition Function vs. Clustered Index

8 votes
2 answers
10k views

Get a record's current partition

7 votes
1 answer
2k views

SQL Server considerations when backing up / restoring a database that uses replication

6 votes
1 answer
1k views

Stuffing a datetime value into a datetime2 column

4 votes
1 answer
2k views

Where is sp_MSrepl_getpublisherinfo in SQL Server?

4 votes
1 answer
15k views

To use or not use ISNULL(NULLIF(Field1, ''))?

4 votes
2 answers
936 views

Execution plan results for sp_executesql suggests adding missing index for already existing index

3 votes
0 answers
70 views

List of changes required to upgrade scripts after starting to use replication in SQL Server

2 votes
1 answer
422 views

ALLOW_SNAPSHOT_ISOLATION Duration

2 votes
2 answers
321 views

Optimize Query of Count Less Than

2 votes
1 answer
163 views

Make View Supersede Table in Same Database?

1 vote
0 answers
453 views

Script Rename of SQL Server Database and Database Files

1 vote
1 answer
120 views

Control SQL Server pace of db shrink to split into multiple files

1 vote
3 answers
131 views

Generally speaking, what pecking order should be used when tuning SQL Server?

0 votes
1 answer
263 views

SQL Server alternatives to triggers for default-value logic

0 votes
1 answer
175 views

SARG-able date conversion

0 votes
1 answer
46 views

Oracle procedure usage metrics?