(Class sessions available tomorrow)
SSIS Class – Online, 12 Hours/classes
Eric Johnson’s class starts May 15 and you can register now to attend! Brought straight to your desktop, this 12-session class includes weekly business hours with Eric, LOTS of information about SSIS and how you can put it to use in your own shop. There is SO MUCH information packed into this course, it’s unbelievable. Take a look at the class sessions here. If you’re working with SSIS, or considering it, you can’t go wrong.
[Find out more] here at the class site.
Are You Updating Statistics with Your SQL Server?
This is a reminder that you’ll want to be sure to update statistics, either automatically or manually, as information changes in your system.
I’ve come across a couple of different cases lately where statistics were NOT being updated automatically and there was no manual process to do so either. At one time the client had this in place, but through database moves, updates, etc. the statistics were no longer set to auto-update.
We were troubleshooting a performance issue and, after an update to the statistics, we saw real, measurable gains in performance.
If you’re not familiar with statistics, it’s the internal information SQL Server uses to figure out the best way to go after information in your tables. Think of it as a model of the information layout in your database and tables. SQL Server sets this up and then uses this model to determine the best way to fulfill queries you submit. Sure, there’s more to it of course, but that’s the summary.
When this information gets out of date, it becomes less useful. It gets out of date when enough information changes in your tables so that the information is not well represented in the model. Then SQL Server isn’t able to make decisions as well and may have to work harder to fulfill queries.
So, when you get a minute, check your databases. It’s in the database properties, options area (SQL Server 2008). You can turn on auto-update stats and you’ll be in a much better place vs. not updating statistics. When you turn on the auto-update feature, SQL Server will go through and update statistics when a certain percentage of data changes in your tables. It resamples and re-determines the statistics based on the potentially new distribution of information in the tables that changed. You can also use the DBCC command (UPDATE STATISTICS) to update statistics manually.
Webcast: SharePoint Infrastructure: The databases, file structure, and services that make up your SharePoint Implementation.
In this session, we will discuss the various databases that are created when you install SharePoint from various options. We will also take a deeper look into the 12 hive file structure and the services that are required.
Presented by: Shannon Bray