user avatar
user avatar
user avatar
Gabe
  • Member for 11 years, 4 months
  • Last seen more than a week ago
29 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
728 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
133 views

Where clause to filter rows for Azure Stretch Database?

3 votes
2 answers
121 views

How to avoid lengthy CASE statement?

2 votes
1 answer
106 views

Retention not working on temporal table or very slow?

2 votes
1 answer
213 views

Handling new fields when merging in data using hashbytes?

2 votes
1 answer
790 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
453 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
64 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
131 views

SQL Sentry Plan Explorer - Execution Mode in plan diagram?

1 vote
0 answers
879 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
91 views

Table design to store Refund Transaction information

0 votes
1 answer
194 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
420 views

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