Recommended reading from mrdenny for April 11, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. SQL Server 2014 In-Memory OLTP: Nonclustered Indexes for Memory-Optimized Tables The 411 on the Microsoft SQL Server 2014 In-Memory OLTP Blog Series Smart, Secure, Cost-Effective: SQL Server Back Up to Windows […]
Viewing Maintenance Plan Logs
For many of my customers I’ve got them setup to use maintenance plans because they are small shops without a DBA and the maintenance plans give them something visual which they can easily tweak later on if needed without having to have me come in to make a small change to their reindexing or backups, […]
Recommended reading from mrdenny for April 04, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. First Week As The DBA Whitepaper Published Beware the ß Waiting, waiting… Great Advice (and Free!): DBA JumpStart SQL Server 2012 Diagnostic Information Queries (December 2013) This weeks SQL Server person to […]
How I Setup TempDB
How TempDB should be setup is a question that comes up a lot, mostly because there is a lot of bad information out there. So here’s how I typically setup TempDB for the bulk of my clients, and these settings will probably work for you as well. Number of Files The number of files that […]