Tag Archives: SQL 2005
The theme for this month’s T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices for fill factors on indexes actually does to the structure of those indexes. Continue reading
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading
Mladen Prajdic recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a while searching on Google I did not turn up anything I liked so I turned to Profiler and started looking at what calls SQL Management Studio uses. After a bit of poking around I was able to come up with a stored procedure that I could call. Continue reading