• Home

  • Services

    • Query Performance Tuning
    • Security Audit
    • Database Recovery
    • Medical Data Management
  • Contact

  • Process and Pricing

    • Frequently Asked Questions
  • Buy Tickets

    • Cart
  • DBA Blog

  • More

    Use tab to navigate through the menu items.

    Quick query to return currently restoring databases

    People need weird thigns for weird reasons. Well, if the thing you need just happens to be: List of databases that are currently in Restoring... state We can help. Just run: SELECT percent_complete , * FROM sys.dm_exec_requests WHERE command In ( 'RESTORE DATABASE' ) #restore #restoredatabase #dmexecrequests
    Featured Posts
    If the SQL Server service does not start in a VM, check this:

    If the SQL Server service does not start in a VM, check this:

    Recent Posts
    ScaleIO SAN - Great for VMware, Not so great for SQL Server

    ScaleIO SAN - Great for VMware, Not so great for SQL Server

    IsDST function for SQL Server

    IsDST function for SQL Server

    Finally, a mirrored drive!

    Finally, a mirrored drive!

    Deciding between Availability Group and Clustering - Episode IV: Software side of the story

    Deciding between Availability Group and Clustering - Episode IV: Software side of the story

    Availability Group is a Klingon Warrior

    Availability Group is a Klingon Warrior

    Out of space? SQL dead? Here's what you do.

    Out of space? SQL dead? Here's what you do.

    Yep. We are SQL consultants, and are telling you to stop using SQL.

    MiniMe to the rescue - Simple but effective performance tuning trick

    MiniMe to the rescue - Simple but effective performance tuning trick

    SQL Server Simple Facts

    Quick query to return currently restoring databases

    Archive
    • April 2016 (1) 1 post
    • April 2015 (1) 1 post
    • January 2015 (1) 1 post
    • December 2014 (4) 4 posts
    • November 2014 (1) 1 post
    • August 2014 (1) 1 post
    • July 2014 (1) 1 post
    • June 2014 (1) 1 post
    • May 2014 (1) 1 post
    • April 2014 (1) 1 post
    Search By Tags
    No tags yet.
    Follow Us
    • Facebook Basic Square
    • Twitter Basic Square
    • Google+ Basic Square
    • facebook
    • Twitter Round
    • googleplus
    • flickr

    © 2014 SATO Database Architects, LLC. SQL Server, SQL Azure are registered trademarks of Microsoft Corporation.