Tag Archives: sql server

Rebuilding a Heap–Don’t Do It

Posted on January 13, 2016 by way0utwest

I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but when I looked in BOL, I saw that indeed you can run this on a heap. That’s interesting, in that … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

An Impressive SQL Server

Posted on December 25, 2015 by way0utwest

This editorial was originally published on May 6, 2011. It is being re-run for the Christmas holiday. Merry Christmas and Happy Holidays! Recently I heard about one SQL Server with 1TB of RAM and another one that was handling over … Continue reading →

Posted in Editorial | Tagged , | Comments Off on An Impressive SQL Server

Tracking Logins with Extended Events

Posted on December 16, 2015 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers. I was building a question the other day on Extended Events and needed to build a new session. One of … Continue reading →

Posted in Blog | Tagged , , , , | 4 Comments

The Writeable Warm Standby

Posted on December 14, 2015 by way0utwest

I saw a question recently that went like this: I get one full backup from FTP. I’ll get daily log backups through FTP after this, but never another full. I need to restore this daily log backup and allow the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on The Writeable Warm Standby