Profile Activity

Gabe

Meta user

Network profile

Reputation

594

2016
2017
2018
2019

Top tag

sql-server

Next privilege

1,000 Rep.

See votes, expandable usercard

Badges

Newest

Nice Question

Next badge

0/1

Impact

0 posts edited

0 helpful flags

232 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

22 Questions

Views Newest Activity Votes

votes

answer

19k

views

When to use sort_in_tempdb when rebuilding indexes?

Apr 11 at 4:47 Michael Freidgeim 125

votes

answer

408

views

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

sql-server update sql-server-2017

Jul 1 at 17:39 Paul White♦ 58.4k

votes

answer

601

views

Does SQL Sentry Plan Explorer count the reads in UDFs?

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

May 5 at 20:21 Aaron Bertrand♦ 159k

votes

answer

views

Finding when a currently running Extended Events session started?

sql-server

Aug 5 '15 at 12:24 Shawn Melton 14.6k

votes

answers

939

views

Best way to design this mileage table?

sql-server-2008 database-design schema

Oct 17 '11 at 16:11 Community♦ 1

votes

answer

401

views

Should I use the deprecated MD5 function in SQL Server?

sql-server sql-server-2017 hashing

Apr 10 at 11:49 Max Vernon 55.4k

votes

answers

views

High cpu usage on SQL Server

sql-server-2008

Feb 22 '17 at 7:52 Kundan Dasange 209

votes

answer

131

views

Where clause to filter rows for Azure Stretch Database?

sql-server sql-server-2016

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

votes

answer

views

Estimated row size and estimated data size is incorrect

sql-server sql-server-2012 query-performance

Oct 21 '15 at 16:47 Community♦ 1

votes

answer

views

Decode URL encoded characters in inline table valued function?

sql-server sql-server-2017

Feb 22 at 14:24 Scott Hodgin 19.1k

votes

answer

952

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 594

vote

answer

views

Prevent updating table using procedure in different database

sql-server permissions security sql-server-2017

Jul 18 at 20:25 Dan Guzman 15.7k

vote

answers

views

Handling new fields when merging in data using hashbytes?

sql-server sql-server-2017

Feb 27 at 22:21 Gabe 594

vote

answers

102

views

SQL Sentry Plan Explorer - Execution Mode in plan diagram?

sql-server execution-plan

Feb 13 at 17:21 Gabe 594

vote

answer

468

views

Predicate pushdown on view to optimize query?

sql-server optimization

Jul 17 '18 at 21:17 Gabe 594

vote

answers

549

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

332

views

How to trace an SSIS package using Extended Events?

sql-server-2012 trace

Aug 27 '15 at 15:45 Gabe 594

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 Community♦ 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 7,268

votes

answer

views

Hide bottom status bar in SSMS

ssms

May 15 '18 at 23:33 Randolph West 2,887

votes

answer

307

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♦ 159k

votes

answers

views

How best to index large table with many index keys

sql-server-2012 index

Nov 13 '14 at 15:47 Gabe 594

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

22 Questions

When to use sort_in_tempdb when rebuilding indexes?

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

Does SQL Sentry Plan Explorer count the reads in UDFs?

Finding when a currently running Extended Events session started?

Best way to design this mileage table?

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

Decode URL encoded characters in inline table valued function?

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

Prevent updating table using procedure in different database

Handling new fields when merging in data using hashbytes?

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