Tag: sql server

Community

Installing SQL Server 2012

(Greg Larsen) SQL Server 2012 has been out for a while. Since its release Microsoft has already released a number of Community Updates (CUs). In order to help you evaluate how you are going to install SQL Server 2102, I will be showing how to install a stand-alone instance of the Database Engine.

Community

DBAs and the SQL Server Agent

(Michael K. Campbell) Following-up on previous posts where I addressed some basics about how DBAs should regularly review SQL Server Logs and be aware of what’s going on with their underlying hosts and/or hardware, I thought I’d take a few minutes and address some of the things that I recommend ‘kee

Community

The Joys of Filtered Indexes

(Tim Chapman) A filtered index, introduced in SQL Server 2008, is a non-clustered index that contains only a subset of the number of rows contained in a table. Because there is a 1:1 ratio between the number of rows in a table and the number of rows in a regular non-clustered index, a filtered inde