Automate Sliding Window Partition Maintenance: Part III
Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell
2014-03-21 (first published: 2010-12-28)
7,482 reads
Hugh Scott
Automate Sliding Window Partition Maintenance: Part II
Part 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.
2014-03-14 (first published: 2010-12-21)
9,901 reads
Automate Sliding Window Partition Management: Part I
A new series on how you can automate partition management and administration. Hugh Scott explains how this technique helps him manage large deletes.
2014-03-07 (first published: 2010-12-14)
19,484 reads
2006-09-04
5,961 reads
SQLAnswers Review
How many of you using SQL Server 2000 have the need to send email from SQL Server? How many of you hate Outlook? Here is a software package that can send not only HTML, but PDF as well and through SMTP. Read Hugh Scott's review and thoughts on this product.
2005-09-22
7,426 reads
A SAN Primer
Storage is getting cheaper and cheaper, which means that more and more SQL Server servers will be incorporating SAN storage as an architecture moving forward. It seems that most DBAs, however, have never worked with this technology. New author Hugh Scott brings us a primer on this Storage Area Networks for DBAs new to this technology.
2005-06-22
15,335 reads
Blogs
Friday Flyway Tips: State-based deployment with Flyway Teams
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Advice I Like: The Main Thing
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
ExecutionLog3 table in Reportserver Database
I have a SSRS report for which users are complaining to be slow, but...
SQL Server Maintenance Plan Feedback
Hi I set this up today. I wanted to get some feedback. I have...
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers