user avatar
user avatar
user avatar
Gabe
  • Member for 11 years, 3 months
  • Last seen more than a week ago
28 votes
1 answer
30k views

When to use sort_in_tempdb when rebuilding indexes?

14 votes
1 answer
6k views

Cannot insert duplicate key row on a non-unique index?

9 votes
1 answer
724 views

Does SentryOne Plan Explorer count the reads in UDFs?

5 votes
1 answer
5k views

Finding when a currently running Extended Events session started?

4 votes
2 answers
2k views

Best way to design this mileage table?

4 votes
1 answer
2k views

Should I use the deprecated MD5 function in SQL Server?

3 votes
2 answers
6k views

High cpu usage on SQL Server

3 votes
1 answer
6k views

Estimated row size and estimated data size is incorrect

3 votes
1 answer
132 views

Where clause to filter rows for Azure Stretch Database?

3 votes
2 answers
114 views

How to avoid lengthy CASE statement?

2 votes
1 answer
85 views

Retention not working on temporal table or very slow?

2 votes
1 answer
197 views

Handling new fields when merging in data using hashbytes?

2 votes
1 answer
746 views

Decode URL encoded characters in inline table valued function?

2 votes
1 answer
1k views

Which reporting method has better performance, using linked server or using lookup in SSRS?

1 vote
0 answers
445 views

How to trace an SSIS package using Extended Events?

1 vote
1 answer
6k views

Installing SQL Server 2012 SP2 on instance with Cumulative Update #10

1 vote
1 answer
63 views

Viewing how much transaction log is used in Simple Recovery Model

1 vote
1 answer
2k views

Predicate pushdown on view to optimize query?

1 vote
2 answers
130 views

SQL Sentry Plan Explorer - Execution Mode in plan diagram?

1 vote
0 answers
867 views

Error while importing flat file (CSV) in SSMS 17.5

1 vote
1 answer
23 views

Finding matching records in a chain to form a parent user

1 vote
1 answer
36 views

Prevent updating table using procedure in different database

0 votes
1 answer
50 views

Table design to store Refund Transaction information

0 votes
1 answer
187 views

Hide bottom status bar in SSMS

0 votes
0 answers
75 views

How best to index large table with many index keys

0 votes
1 answer
416 views

XQuery on Extended Events joining with dm_exec_query_plan not working [duplicate]