Featured Article(s)
Parameters for Analysis Services Reporting: Introduction, Pt. 2
Part 2: BI Architect Bill Pearson begins an extended examination of parameterization within Analysis Services reports. In this article, we get hands-on practice creating a parameter within the graphical user interface, and then examine the construction that Reporting Services 2005/ 2008 / 2008 R2 performs behind the scenes.
Featured Script
Check free space on drive
this routine will check free space on your server as well as on all linked servers and send an email-requires sqlMail… (read more)
Webcast: Using Log Shipping for High Availability
Log Shipping has been around in one form or another since SQL Server 2000 and many “homegrown†and third-party solutions have recently become available. This session will cover all you need to know about log shipping to use it effectively for high availability. We will look at set up, maintenance, monitoring, and failover. In addition, we will look at other SQL Server objects that you need to account for when using Log Shipping for HA. This session is for beginning to advanced SQL Server DBAs with little or no Log Shipping experience.
Presented by: Eric Johnson
> Register Now
> Live date: 7/14/2010 at 12:00 Pacific
Managing Fragmentation, Stats and More
More feedback, lessons learned and approaches to working with stats, indexes, fragmentation, etc.
From Mike: "We’ve about 400 databases so I normally as part of our maintenance have all indexes rebuilt weekly (weekend) and update stats run during the midweek."
Trisha writes – "I just left a global investment services firm a few months ago. My primary database was around 150 GB, around a GB of new data was loaded nightly, about 7 GB was removed weekly (> a month old for certain tables).
On the 150 GB db, I defragged the indices every weekend. Automatic, almost no exceptions. It’s the only thing that gave us the response time we needed during the week.
We did the smaller databases (around 10 of them) twice a week. Lots of data coming in for a limited amount of time for very impatient users."
John added a step – "All of our production db’s undergo a full db reindex each Sunday morning followed by a update stats. Then we mark each stored proc to recompile on next run. We have found that, due to badly written vendor application, if this is not done then the performance of the application drops dramatically."
Rich wrote to say "Our index defragmentation procedure is a set of 3 scripts that run dbcc reindex on many tables in our two main databases and sets the fill to a single amount…75. These run as jobs every night whether or not they are needed. "