Gabe

Member for 10 years, 9 months
Last seen more than a month ago

Reputation

1,154

1.2k
872
591

2018
2019
2020
2021

Top tag

sql-server

Next privilege

2,000 Rep.

Edit questions and answers

Badges

Newest

Next badge

0/1

Impact

0 posts edited

0 helpful flags

265 votes cast

24 Questions

Votes Activity Newest Views

votes

answer

28k

views

When to use sort_in_tempdb when rebuilding indexes?

Sep 11 '20 at 13:12 smt 1

votes

answer

views

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

sql-server update sql-server-2017

Jul 1 '19 at 17:39 CommunityBot 1

votes

answer

693

views

Does SentryOne Plan Explorer count the reads in UDFs?

sql-server sql-server-2008 query-performance execution-plan functions

May 7 '20 at 23:03 Aaron Bertrand 175k

votes

answer

views

Finding when a currently running Extended Events session started?

sql-server

Aug 5 '15 at 12:24 CommunityBot 1

votes

answers

views

Best way to design this mileage table?

sql-server-2008 database-design schema

Oct 17 '11 at 16:11 CommunityBot 1

votes

answers

views

How to avoid lengthy CASE statement?

sql-server sql-server-2017

Oct 9 '19 at 5:03 Michael Green 21.8k

votes

answer

views

Should I use the deprecated MD5 function in SQL Server?

sql-server sql-server-2017 hashing

Apr 10 '19 at 11:49 Hannah Vernon♦ 66.4k

votes

answers

views

High cpu usage on SQL Server

sql-server-2008

Feb 22 '17 at 7:52 CommunityBot 1

votes

answer

132

views

Where clause to filter rows for Azure Stretch Database?

sql-server sql-server-2016

Apr 1 '16 at 12:11 Paul White♦ 64.6k

votes

answer

views

Estimated row size and estimated data size is incorrect

sql-server sql-server-2012 performance query-performance

Oct 21 '15 at 16:47 CommunityBot 1

votes

answer

158

views

Handling new fields when merging in data using hashbytes?

sql-server sql-server-2017

Oct 10 at 1:03 CommunityBot 1

votes

answer

601

views

Decode URL encoded characters in inline table valued function?

sql-server sql-server-2017

Feb 22 '19 at 14:24 Scott Hodgin - Retired 23.1k

votes

answer

views

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

sql-server linked-server

Oct 25 '11 at 12:56 Gabe 1,154

vote

answer

views

Finding matching records in a chain to form a parent user

sql-server query sql-server-2017

Jun 26 '20 at 12:47 Gabe 1,154

vote

answer

views

Prevent updating table using procedure in different database

sql-server permissions security sql-server-2017

Jul 18 '19 at 20:25 Dan Guzman 23k

vote

answers

128

views

SQL Sentry Plan Explorer - Execution Mode in plan diagram?

sql-server execution-plan

Feb 13 '19 at 17:21 Gabe 1,154

vote

answer

views

Predicate pushdown on view to optimize query?

sql-server optimization

Jul 17 '18 at 21:17 Gabe 1,154

vote

answers

822

views

Error while importing flat file (CSV) in SSMS 17.5

sql-server-2016 ssms

May 8 '18 at 7:57 Hosham 1

vote

answers

427

views

How to trace an SSIS package using Extended Events?

sql-server-2012 trace

Aug 27 '15 at 15:45 Gabe 1,154

vote

answer

views

Viewing how much transaction log is used in Simple Recovery Model

sql-server-2012 transaction-log

Oct 7 '14 at 20:21 CommunityBot 1

vote

answer

views

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

sql-server-2012

Jul 2 '14 at 11:34 marc_s 8,593

votes

answer

177

views

Hide bottom status bar in SSMS

ssms

Apr 15 '20 at 9:21 Flou 36

votes

answer

407

views

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

sql-server-2012 extended-events

Jun 26 '15 at 17:14 Aaron Bertrand 175k

votes

answers

views

How best to index large table with many index keys

sql-server-2012 index

Nov 13 '14 at 15:47 Gabe 1,154

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

24 Questions

When to use sort_in_tempdb when rebuilding indexes?

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

Does SentryOne Plan Explorer count the reads in UDFs?

Finding when a currently running Extended Events session started?

Best way to design this mileage table?

How to avoid lengthy CASE statement?

Should I use the deprecated MD5 function in SQL Server?

High cpu usage on SQL Server

Where clause to filter rows for Azure Stretch Database?

Estimated row size and estimated data size is incorrect

Handling new fields when merging in data using hashbytes?

Decode URL encoded characters in inline table valued function?

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

Finding matching records in a chain to form a parent user

Prevent updating table using procedure in different database

SQL Sentry Plan Explorer - Execution Mode in plan diagram?

Predicate pushdown on view to optimize query?

Error while importing flat file (CSV) in SSMS 17.5

How to trace an SSIS package using Extended Events?

Viewing how much transaction log is used in Simple Recovery Model

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

Hide bottom status bar in SSMS

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

How best to index large table with many index keys