Skip to main content
Ronaldo's user avatar
Ronaldo's user avatar
Ronaldo's user avatar
Ronaldo
  • Member for 4 years, 11 months
  • Last seen this week
  • Brasil
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?

12 votes
2 answers
1k views

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

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?

10 votes
1 answer
505 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?

8 votes
2 answers
438 views

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

8 votes
2 answers
2k views

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

7 votes
4 answers
3k views

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

4 votes
1 answer
203 views

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

2 votes
1 answer
917 views

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

1 vote
2 answers
84 views

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

1 vote
0 answers
3k views

Troubleshoot MS DTC error

1 vote
0 answers
165 views

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

0 votes
1 answer
323 views

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

0 votes
1 answer
122 views

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

0 votes
1 answer
152 views

Why is the result of DATABASEPROPERTYEX not consistent for AdventureWorks?

0 votes
1 answer
67 views

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