July, 2011

Hi, In the continuation of our Business Intelligence series in our Ezequiel Blog, I’m making this post to announce the release of SharePoint 2010 SP1 and the new features that have been included. From a BI perspective there are several functionalities...

Hello all, Here is another post on SQL scripts that may help DBAs, following the series "SQL Swiss Army Knife", this time on the topic of VLFs again. If you follow this blog, you know I blogged on this subject several times before and if you want to read...

Hi, The purpose of this post is to share some notes (links) about the recent release of SQL Server 2008 R2 SP1: SQL Server 2008 R2 SP1 Technorati Tags: SQL Server 2008 R2 SP1 , Service Pack Download http://www.microsoft.com/download/en/details.aspx?id...

Hello all, The topic today is database and server collations. As part of pre-installation tasks for SQL Server, we should always take into account what is the collation required by the user databases. Why is that? Collation is a subject many times...

The purpose for this procedure to to perform an intelligent defrag on one or more indexes for one or more databases. The 1st release was inspired by an earlier release of Michelle Ufford’s code in SQLFOOL.com site, and has since evolved to suit different and added needs. In a nutshell, this procedure automatically chooses whether to rebuild or reorganize an index according to its fragmentation level, amongst other parameters, like if page locks are allowed or the existence of LOBs.
All within a specified time frame you choose, defaulting to 8 hours. The defrag priority can also be set, either on size, fragmentation level or index usage (based on range scan count), which is the default.
It also handles partitioned indexes, optional statistics update (table-wide or only those related to indexes), rebuilding with the original fill factor or index padding and online operations, to name a few options.

...