User Ronaldo

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

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

10 votes

2 answers

944 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

10 votes

1 answer

349 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

8 votes

2 answers

389 views

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

asked Sep 16, 2019 at 15:34

8 votes

2 answers

2k views

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

asked Oct 27, 2020 at 13:28

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

4 votes

1 answer

142 views

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

asked Jan 10, 2020 at 15:30

2 votes

1 answer

407 views

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

asked Apr 22, 2022 at 1:10

1 vote

2 answers

58 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

1 vote

0 answers

2k views

Troubleshoot MS DTC error

asked Dec 18, 2019 at 20:50

1 vote

0 answers

140 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

0 votes

1 answer

195 views

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

asked Feb 22, 2021 at 10:04

0 votes

1 answer

74 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

102 views

Why is the result of DATABASEPROPERTYEX not consistent for AdventureWorks?

asked Jan 18, 2022 at 9:42

0 votes

1 answer

55 views

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

asked Apr 12, 2022 at 8:37

Stack Exchange Network

16 Questions

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

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?

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 exactly triggers the UPDATE of the column is_media_read_only on sys.database_files?

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

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

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

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

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

Troubleshoot MS DTC error

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

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

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

Why is the result of DATABASEPROPERTYEX not consistent for AdventureWorks?

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