Shaun J Stuart

Just another SQL Server weblog

Browsing Posts in SQLServerPedia Syndication

More SSMS Tips

No comments

I’ve written in the past about some of the ways you can configure SQL Server Management Studio to help you make your life a bit easier. I’ve discovered two more little tricks I thought I’d pass along. Every DBA has a handful or more of T-SQL scripts they use on a regular basis to make […]

Share

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