User Ronaldo

10 votes

3 answers

2k views

Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively?

asked Feb 12, 2020 at 12:25

11 votes

2 answers

964 views

Is there a way to see what were the Candidate Execution Plans generated by the Query Optimizer?

asked Apr 20, 2020 at 11:13

1 vote

2 answers

68 views

How can I create a brand new alarm based on a verification not listed by default on SQL Server?

asked Apr 26, 2022 at 16:09

2 votes

1 answer

573 views

How do I generate the private key needed to restore the encrypted backup?

asked Apr 22, 2022 at 1:10

0 votes

1 answer

64 views

What does it mean to reach a stable point during the execution of a job?

asked Apr 12, 2022 at 8:37

0 votes

1 answer

115 views

Why is the result of DATABASEPROPERTYEX not consistent for AdventureWorks?

asked Jan 18, 2022 at 9:42

0 votes

1 answer

89 views

Is there a formula to calculate the max acceptable number of reads a query should have?

asked Dec 7, 2021 at 12:20

0 votes

1 answer

235 views

How can I measure the impact of queries with errors being rejected by SQL Server?

asked Feb 22, 2021 at 10:04

10 votes

1 answer

396 views

Why using a local temp table (instead of a global temp table or a regular table) influences the Query Optimizer to choose a poor query plan?

asked Jan 8, 2021 at 2:51

7 votes

4 answers

2k views

What could cause SQL Server to deny execution of a SP at first, but allow it later with no privileges change?

asked Nov 10, 2020 at 12:33

8 votes

2 answers

2k views

Why do we have undocumented and unsupported functions in SQL Server?

asked Oct 27, 2020 at 13:28

1 vote

0 answers

159 views

Is there any way to recklessly drop a principal leaving orphaned objects or should I assume only data corruption could cause it?

asked Jul 14, 2020 at 10:16

8 votes

2 answers

412 views

What exactly triggers the UPDATE of the column is_media_read_only on sys.database_files?

asked Sep 16, 2019 at 15:34

4 votes

1 answer

164 views

Why should I apply a CU for SP2 that was released after the release of SP3?

asked Jan 10, 2020 at 15:30

1 vote

0 answers

3k views

Troubleshoot MS DTC error

asked Dec 18, 2019 at 20:50

13 votes

1 answer

3k views

How can I know what hashing algorithm SQL Server used to decrypt the encrypted data when using the function DECRYPTBYPASSPHRASE?

asked Sep 6, 2019 at 12:27

Stack Exchange Network

16 Questions

Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively?

Is there a way to see what were the Candidate Execution Plans generated by the Query Optimizer?

How can I create a brand new alarm based on a verification not listed by default on SQL Server?

How do I generate the private key needed to restore the encrypted backup?

What does it mean to reach a stable point during the execution of a job?

Why is the result of DATABASEPROPERTYEX not consistent for AdventureWorks?

Is there a formula to calculate the max acceptable number of reads a query should have?

How can I measure the impact of queries with errors being rejected by SQL Server?

Why using a local temp table (instead of a global temp table or a regular table) influences the Query Optimizer to choose a poor query plan?

What could cause SQL Server to deny execution of a SP at first, but allow it later with no privileges change?

Why do we have undocumented and unsupported functions in SQL Server?

Is there any way to recklessly drop a principal leaving orphaned objects or should I assume only data corruption could cause it?

What exactly triggers the UPDATE of the column is_media_read_only on sys.database_files?

Why should I apply a CU for SP2 that was released after the release of SP3?

Troubleshoot MS DTC error

How can I know what hashing algorithm SQL Server used to decrypt the encrypted data when using the function DECRYPTBYPASSPHRASE?