I'm so in love with the Internetz, I think I'll marry it. I just semi-borked a load test I was supposed to be tracing…perfmon wouldn't start at the last minute, and in the scramble to get it going, I not only forgot to start my SQL trace, I also left the perfmon output file in […]
Category: Tech and Learning
SSIS: Deploy Packages, Part 1
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 […]
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 […]