User Randy Minder

26 votes

2 answers

40k views

Changing a column from NOT NULL to NULL - What's going on under the hood?

asked Apr 13, 2015 at 18:03

16 votes

1 answer

974 views

Dropping unused indexes - Assessing the unexpected dangers

asked Nov 19, 2015 at 20:20

10 votes

1 answer

1k views

Why isn't the primary (clustered) key being used in this query?

asked Jun 19, 2015 at 20:33

10 votes

4 answers

4k views

SQL Server Query Store - What is considered an 'ad-hoc' query?

asked Oct 11, 2017 at 13:17

7 votes

1 answer

2k views

sys.dm_exec_requests - start_time

asked Oct 5, 2015 at 17:22

7 votes

2 answers

25k views

How to Import a BACPAC file to Azure SQL and Overwrite Existing Database?

asked May 26, 2017 at 21:39

6 votes

2 answers

910 views

Index Fragmentation - Am I interpreting the results correctly?

asked Sep 23, 2015 at 16:59

6 votes

1 answer

323 views

SQL Server 2008 Replication - Fixed Overhead of Replication?

asked Oct 12, 2011 at 15:08

6 votes

3 answers

613 views

Azure SQL Database Restore after Server Failure - Where are the Backups?

asked Oct 16, 2017 at 12:25

5 votes

2 answers

170 views

Confused about why a particular index is being used

asked Oct 6, 2015 at 19:05

5 votes

1 answer

1k views

sys.dm_exec_requests and cpu_time

asked Oct 14, 2015 at 17:29

5 votes

1 answer

894 views

SQL Server 2016 - ColumnStore Clustered Index vs. Non-ColumnStore Clustered Index

asked Feb 17, 2017 at 15:53

5 votes

3 answers

34k views

Converting a SQL Server 2000 Database to SQL Server 2016

asked Mar 4, 2017 at 16:57

5 votes

2 answers

3k views

LOG_RATE_GOVERNOR Wait Stat

asked Sep 18, 2017 at 13:17

4 votes

2 answers

2k views

PAGEIOLATCH wait type

asked Oct 5, 2015 at 22:14

4 votes

3 answers

2k views

Why is SQL Server 2012 Recommending This Index Be Created?

asked Nov 10, 2013 at 2:39

4 votes

3 answers

3k views

Why aren't some spid values showing up in sys.dm_exec_requests?

asked Oct 5, 2017 at 19:26

3 votes

2 answers

1k views

SQL Audit and AlwaysOn Replicas

asked Jan 22, 2018 at 17:13

3 votes

2 answers

7k views

SQL Server 2016 Install - R Server and R Services Install Failed

asked Jul 29, 2016 at 18:00

2 votes

2 answers

92 views

Can SQL Server Transactional Replication do this?

asked May 4, 2015 at 16:28

2 votes

1 answer

2k views

SQL Server 2012 Page Compression - Determine compression ratio?

asked Sep 20, 2013 at 14:01

2 votes

1 answer

623 views

Creating additional indexes on a table with a columnstore clustered index

asked Feb 17, 2017 at 19:21

2 votes

1 answer

2k views

SQL Server 2016 ColumnStore Clustered Index - Query plan showing a scan, performance not great

asked Feb 20, 2017 at 14:22

2 votes

1 answer

2k views

SQL Server 2016 SP1 - Unable to execute R code [duplicate]

asked Mar 1, 2017 at 19:30

2 votes

1 answer

522 views

Azure SQL - Server login vs. database login

asked May 27, 2017 at 21:02

2 votes

2 answers

1k views

Snapshot Isolation vs Read Committed - OLTP and Reporting Databases

asked Oct 9, 2017 at 14:18

2 votes

3 answers

3k views

Always On - Does the read replica need the same SQL license as the primary?

asked Mar 14, 2018 at 18:39

2 votes

1 answer

1k views

Log Shipping - Secondary Database - Can CDC be enabled?

asked Jul 10, 2018 at 19:16

2 votes

1 answer

374 views

Dynamic Data Masking Doesn't Seem To Work Correctly With ISNULL

asked Oct 15, 2020 at 19:29

2 votes

1 answer

215 views

Dynamic Data Masking Issue when Concatenating Fields

asked Oct 16, 2020 at 17:00

Stack Exchange Network

47 Questions

Changing a column from NOT NULL to NULL - What's going on under the hood?

Dropping unused indexes - Assessing the unexpected dangers

Why isn't the primary (clustered) key being used in this query?

SQL Server Query Store - What is considered an 'ad-hoc' query?

sys.dm_exec_requests - start_time

How to Import a BACPAC file to Azure SQL and Overwrite Existing Database?

Index Fragmentation - Am I interpreting the results correctly?

SQL Server 2008 Replication - Fixed Overhead of Replication?

Azure SQL Database Restore after Server Failure - Where are the Backups?

Confused about why a particular index is being used

sys.dm_exec_requests and cpu_time

SQL Server 2016 - ColumnStore Clustered Index vs. Non-ColumnStore Clustered Index

Converting a SQL Server 2000 Database to SQL Server 2016

LOG_RATE_GOVERNOR Wait Stat

PAGEIOLATCH wait type

Why is SQL Server 2012 Recommending This Index Be Created?

Why aren't some spid values showing up in sys.dm_exec_requests?

SQL Audit and AlwaysOn Replicas

SQL Server 2016 Install - R Server and R Services Install Failed

Can SQL Server Transactional Replication do this?

SQL Server 2012 Page Compression - Determine compression ratio?

Creating additional indexes on a table with a columnstore clustered index

SQL Server 2016 ColumnStore Clustered Index - Query plan showing a scan, performance not great

SQL Server 2016 SP1 - Unable to execute R code [duplicate]

Azure SQL - Server login vs. database login

Snapshot Isolation vs Read Committed - OLTP and Reporting Databases

Always On - Does the read replica need the same SQL license as the primary?

Log Shipping - Secondary Database - Can CDC be enabled?

Dynamic Data Masking Doesn't Seem To Work Correctly With ISNULL

Dynamic Data Masking Issue when Concatenating Fields