Attention: We are retiring the ASP.NET Community Blogs. Learn more >

Contents tagged with SQL Article

  • Things you don't want to hear your DBA say...

    No Comments

    • I don't have to worry about I/O because I use a SAN.
    • RAID 5 is our backup strategy!
    • I just made you a sysadmin, now you don't have to keep asking me for permissions
    • I've changed all of the databases in production to use both AutoShrink and AutoClose
    • Nope - the backups were on that drive too.
    • Just use sa, the password is blank
    • Excel can do this and much more
    • Wow. It really IS the database! Sorry, guys... I've been blaming the developers and storage guys so long!
    • We have more than one sql server installed here?!
    I got these from a DBA I work with.  Hopefully you enjoyed them...

    Read more...

  • Pulling back the covers on SQL Server

    No Comments

    Tuning SQL Server has always been a black art.  Luckily, SQL Server 2005 added a number of tools to give us a glimpse into its inner workings through Dynamic Management Views (DMV). In the MSDN article, SQL Server: Uncover Hidden Data to Optimize Application Performance, Ian Stirk provides an excellent overview of the various DMVs.  "SQL Server 2005 collects data relating to running queries. This data, which is held in memory and starts accumulating after a server restart, can be used to identify numerous issues and metrics, including those surrounding table indexes, query performance, and server I/O. You can query this data via the SQL Server Dynamic Management Views (DMVs) and related Dynamic Management Functions (DMFs)."  More...

    Read more...