- Jon Lewis on A Busy/Accidental DBA’s Guide to Managing VLFs
- Arnold Lieberman on A Busy/Accidental DBA’s Guide to Managing VLFs
- Update Statistics fails with Error Number:–1073548784 “Could not allocate space for object ‘dbo.SORT” – ReplTalk on Stored Procedure to Sequentially Run SQL Agent Jobs
- steve kirchner on Whats a Good Rule for Max Degree of Parallelism?
- Bipin on Stored Procedure to Sequentially Run SQL Agent Jobs
Monthly Archives: September 2010
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people are talking about. It is also a great place to looking for different ways of doing things. I sometimes even go to the site just to look for entertaining technical concepts, like the “Cactus Stack”, “Stooge Sort” or even “Big-O Notation”. Continue reading
How is Fill Factor Impacting My Indexes?
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
Posted in Utilities Tagged fill factor, fill_factor, SQL 2005, SQL 2008, SQL 2008 R2, SSC, SSP, sys.dm_db_index_physical_stats 13 Comments
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading
Posted in Utilities Tagged SQL 2005, SQL Server, SSC, SSIS 3 Comments