Database Administrators
Ronaldo's user avatar
Ronaldo's user avatar
Ronaldo's user avatar
Ronaldo
  • Member for 4 years, 2 months
  • Last seen this week
  • Brasil
Profile Activity

146 Answers

Score Activity Newest
23 votes
Accepted

During a log backup is the data backed up to the start or end of the operation?

9 votes

DB backups have suddenly gotten smaller

9 votes

Why is the default page size for databases so small?

9 votes

How to retrieve the maximum value and its corresponding date in a table

7 votes
Accepted

Why does this query fail when I run it from a SQL Server job?

7 votes
Accepted

How crash recovery process works in SQL Server?

6 votes
Accepted

Why a dropped index is still there, and does it prevent a table from being altered?

6 votes
Accepted

Does the query still run even when SQL Server can't grant the requested memory for the query?

6 votes
Accepted

SQL Server, how to log client PID of failed login attempts?

5 votes
Accepted

Why automatic failover does not occur when I turn off SQL Service in SQL Server Failover Cluster Instance?

4 votes
Accepted

Can we use multiple backup software programs at the same time?

4 votes
Accepted

Resource Governor and Resource Pool CPU Utilization Configuration

4 votes
Accepted

Find an open transaction across any session and any database in SQL Server

4 votes
Accepted

SQL Server 2005 error after update to windows 10

4 votes

Database master key and certificate for backup encryption - SQL Server

4 votes
Accepted

Does only a full backup (and no tlog backup) of a db in full recovery model allow for point in time recovery?

4 votes

Why can't you add an Identity to an existing colum in SQL Server?

4 votes
Accepted

Will SQL Server go offline if it loses network connectivity to SAN where master and msdb system databases reside?

4 votes
Accepted

Any potential cons associated with enabling backup checksums when performing backups?

4 votes
Accepted

Is it always safe to use WITH SCHEMABINDING in a UDF?

4 votes
Accepted

How to deal with SQL Server Full Text Log Files?

3 votes
Accepted

Query to retrieve SQL Server login password length

3 votes
Accepted

Best approach for moving tempdb .ndf files

3 votes

Is @@ROWCOUNT preserved by EXECUTE or not?

3 votes
Accepted

Does Traceflag 1800 require a restart?

3 votes
Accepted

Avg write latency spikes for disk more than usual. Need help finding the culprit

3 votes
Accepted

SQL Server - Restore only primary Filegroup but bring the database online

3 votes

How can I fix "Login failed for user sa" error in SQL Server?

3 votes
Accepted

Which authentication is better for MS-SQL Server 2019 : integrated security=SSPI vs uid=sa;pwd=xx | windows auth vs sa auth

3 votes
Accepted

Minimal Permissions to Create an Application Database and Database Owner

1
2 3 4 5

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.