User Gabe

28 votes

1 answer

30k views

When to use sort_in_tempdb when rebuilding indexes?

asked Jul 31, 2015 at 18:31

14 votes

1 answer

6k views

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

sql-server update sql-server-2017

asked Jun 18, 2019 at 14:54

9 votes

1 answer

724 views

Does SentryOne Plan Explorer count the reads in UDFs?

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

asked Dec 11, 2013 at 16:05

5 votes

1 answer

5k views

Finding when a currently running Extended Events session started?

sql-server

asked Aug 4, 2015 at 17:25

4 votes

2 answers

2k views

Best way to design this mileage table?

sql-server-2008 database-design schema

asked Oct 14, 2011 at 21:53

4 votes

1 answer

2k views

Should I use the deprecated MD5 function in SQL Server?

sql-server sql-server-2017 hashing

asked Feb 7, 2019 at 14:38

3 votes

2 answers

6k views

High cpu usage on SQL Server

sql-server-2008

asked Oct 17, 2013 at 22:05

3 votes

1 answer

6k views

Estimated row size and estimated data size is incorrect

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

asked Oct 21, 2015 at 16:21

3 votes

1 answer

132 views

Where clause to filter rows for Azure Stretch Database?

sql-server sql-server-2016

asked Nov 4, 2015 at 17:02

3 votes

2 answers

114 views

How to avoid lengthy CASE statement?

sql-server sql-server-2017

asked Oct 8, 2019 at 17:26

2 votes

1 answer

85 views

Retention not working on temporal table or very slow?

sql-server sql-server-2017 temporal-tables

asked Jan 19 at 22:17

2 votes

1 answer

197 views

Handling new fields when merging in data using hashbytes?

sql-server sql-server-2017

asked Dec 28, 2018 at 20:15

2 votes

1 answer

746 views

Decode URL encoded characters in inline table valued function?

sql-server sql-server-2017

asked Feb 21, 2019 at 21:11

2 votes

1 answer

1k views

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

sql-server linked-server

asked Oct 18, 2011 at 17:16

1 vote

0 answers

445 views

How to trace an SSIS package using Extended Events?

sql-server-2012 trace

asked Aug 27, 2015 at 15:45

1 vote

1 answer

6k views

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

sql-server-2012

asked Jun 27, 2014 at 18:32

1 vote

1 answer

63 views

Viewing how much transaction log is used in Simple Recovery Model

sql-server-2012 transaction-log

asked Oct 7, 2014 at 19:55

1 vote

1 answer

2k views

Predicate pushdown on view to optimize query?

sql-server optimization

asked Jul 11, 2018 at 22:50

1 vote

2 answers

130 views

SQL Sentry Plan Explorer - Execution Mode in plan diagram?

sql-server execution-plan

asked Nov 7, 2017 at 14:55

1 vote

0 answers

867 views

Error while importing flat file (CSV) in SSMS 17.5

sql-server-2016 ssms

asked Feb 26, 2018 at 4:49

1 vote

1 answer

23 views

Finding matching records in a chain to form a parent user

sql-server query sql-server-2017

asked Jun 25, 2020 at 14:50

1 vote

1 answer

36 views

Prevent updating table using procedure in different database

sql-server permissions security sql-server-2017

asked Jul 17, 2019 at 23:34

0 votes

1 answer

50 views

Table design to store Refund Transaction information

sql-server database-design table data-warehouse

asked Mar 2 at 1:00

0 votes

1 answer

187 views

Hide bottom status bar in SSMS

ssms

asked May 15, 2018 at 22:42

0 votes

0 answers

75 views

How best to index large table with many index keys

sql-server-2012 index

asked Nov 13, 2014 at 15:47

0 votes

1 answer

416 views

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

sql-server-2012 extended-events

asked Jun 26, 2015 at 17:03

Stack Exchange Network

current community

your communities

more stack exchange communities

26 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?

Should I use the deprecated MD5 function in SQL Server?

High cpu usage on SQL Server

Estimated row size and estimated data size is incorrect

Where clause to filter rows for Azure Stretch Database?

How to avoid lengthy CASE statement?

Retention not working on temporal table or very slow?

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?

How to trace an SSIS package using Extended Events?

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

Viewing how much transaction log is used in Simple Recovery Model

Predicate pushdown on view to optimize query?

SQL Sentry Plan Explorer - Execution Mode in plan diagram?

Error while importing flat file (CSV) in SSMS 17.5

Finding matching records in a chain to form a parent user

Prevent updating table using procedure in different database

Table design to store Refund Transaction information

Hide bottom status bar in SSMS

How best to index large table with many index keys

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