This is the companion text to the video SSIS: Deploy Packages. This will be a two- or three-part series, I think. There are two ways to deploy SIS packages, and the difference becomes important when you have a lot of packages. The first way is just to individually deploy a package directly to SQL (or […]
Category: sql server
Index Rebuilds: SQL vs. PowerShell
I thought this conversation worth reporting…Sean and I were comparing our scripts to create rebuild / reorgs, and he sent this: DECLARE @currSchema VARCHAR(100) , @currTableName VARCHAR(100) , @SQL NVARCHAR(200) DECLARE Tables CURSOR read_only FOR SELECT SS.name , SO.name FROM sys.objects SO INNER JOIN sys.schemas SS ON SO.schema_id = SS.schema_id […]
Case Study: Rebuilding Indexes
It’s not all that uncommon to start a new job, or inherit a project, and find out that index maintenance hasn’t exactly been a priority. One of the first things you want to do is look at fragmentation. This query will pull back all the indexes for My_Database ordered by the average fragmentation in percent. […]