Robert Davis

  • Interests: Poker, computers, reading/writing horror fiction

Technical Article

How do I ... Determine Database Growth If I Am Not Tracking It? -- Error Logs Part III

How do I ... Determine Database Growth If I Am Not Tracking It? If your database has grown considerably and you're not sure when or why it happened, you'll be hard pressed to figure out the answer unless you're tracking changes in database size.

You rated this post out of 5. Change rating

2009-02-27

4,388 reads

Technical Article

Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?

Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online? This question was sent to me via email. My reply follows. Quick question on DB mirroring client redirection after Principal fails

You rated this post out of 5. Change rating

2009-02-24

3,649 reads

Blogs

Finding the Latest Backup Timestamps for Your Databases

By

Finding the Latest Backup Timestamps for Your Databases I wanted to find out the most...

Using SQL Elastic Pools

By

We use SQL elastic pools at work. I needed to learn more about their...

Webcast: How to Secure SQL Server – End to End Security

By

On April 16, 2024, I will be giving another webcast; this one will be...

Read the latest Blogs

Forums

Database Mirroring is Back in Azure SQL Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Mirroring is Back in...

Tracking Database Growth - Script Automation & Reporting

By EM2

Hello,   I found this script that helps me in populate a table with...

Outer join table where there is 2 foreign keys to join

By mjohnson 71479

I am asked to provide a date in a query from a table that...

Visit the forum

Question of the Day

The Cloned Database Size

I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:database file propertiesI now run this command:

DBCC CLONEDATABASE(sandbox, sandbox_clone);
GO
When I examine the database file properties, what do they show?

See possible answers