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,491 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,928 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,538 reads
Automate Range Right Partition Management with Powershell (Part II)
In the last script, we covered removing the trailing partition in a Range Right, date valued partition. This script adds a new (empty) partition to the partition scheme.
2010-11-12 (first published: 2009-12-17)
1,056 reads
Automate Range Right Partition Management with PowerShell
This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.
2010-11-11 (first published: 2009-12-17)
2,174 reads
Extracting Logins From SQL Server
This script will help you transfer logins between one instance of SQL and another.
2010-11-08 (first published: 2010-01-07)
4,560 reads
2006-09-04
5,962 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,427 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,336 reads
Blogs
Query multiple Azure SQL Databases
I was sick of changing context in Azure Data Studio while cleaning up things...
KDA: Echoes of Deception - Case 3
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
The Book of Redgate: Do Your Best Work
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Forums
Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere
Comments posted to this topic are about the item Shining a Light on Shadow...
CAST(VARCHAR(n)) resolved performance issue?
Hi, I would love to hear if anyone can tell me why a CAST...
isnull, coalesce overhead
hi, one of our sister division's erp extract view is going thru at least...
Question of the Day
The Internals of Writing a Page
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers