Shaun J Stuart

Just another SQL Server weblog

Browsing Posts in SQLServerPedia Syndication

I’ve finally had a chance to play around with SQL Server 2012 and one of the nice things I’ve discovered is that it features a warning when a transaction log file has an excessive number of virtual log files. I’ve written about VLFs before and any seasoned DBA will know about them. However, there are […]

Share

As a database professional, I see a lot of instructions from vendors on how they want their SQL Server backend configured. Many times, the recommended configuration stinks. It’s not their fault – the companies typically don’t have anyone on staff whose job it is to lean how to configure each database platform they support for […]

Share

We recently upgraded our installation of Great Plains from version 10 to Dynamics GP 2010 and ran into some difficulties with the upgrade hanging. We’re using SQL 2008 R2 as our database back end. Let me first state that I was not involved in this upgrade and it was our vendor who was working with […]

Share

Everyone know SQL Server loves memory. It will happily gobble up all the RAM you throw at it. On physical boxes, this may not be a big deal, especially if you plan for it and properly configure your max and min memory settings within SQL Server. RAM makes SQL Server run faster and who doesn’t […]

Share

Microsoft released SP2 for SQL Server 2008 R2 a couple weeks ago and I’ve been applying it to my servers. Most of the time it installed without problems, but I encountered a very puzzling error on one server. When I ran the service pack installation, I saw a DOS window pop and and disappear quickly […]

Share