Call for Speakers - SQL Saturday Pittsburgh
SQL Saturday #440 is coming to Pittsburgh on October 3, 2015. Now is the time to submit if you'd like to speak at the event.
2015-07-31
3,428 reads
Articles
SQL 2014 Clustered Columnstore Index Rebuild and Maintenance Considerations
Building (or rebuilding) a Columnstore index can be a resource intensive operation. In this article, Denzil Ribeiro describes the index rebuild process and index maintenance for clustered Columnstore indexes in SQL 2014.
2015-07-31
2,990 reads
Detecting Differences in Files on Servers
Detecting file differences on two different web servers using T-SQL.
2015-07-30
5,846 reads
Download tSQLt Today and Start Unit Testing
The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.
2015-07-30
1,759 reads
SQL Server Archive and Data Retention Considerations
Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.
2015-07-30
2,895 reads
Demystifying Oracle's Clustering Factor
One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, more specifically the distance between 'jumps' for a given index key. Commonly, a 'jump' is the number of blocks between rows containing the given index key starting with the first block found containing that key. If that sounds confusing don't despair, David Fitzjarrell explains in detail.
2015-07-29
3,764 reads
The Importance of Maintenance on MSDB
MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.
2015-07-28
6,714 reads
Learning Backup to Azure
References and links to get you started in backing up your database to the Azure blob storage.
2015-07-27
817 reads
Can Code Review Be Automated?
Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.
2015-07-27
5,104 reads
SAN and NAS protocols and how they impact SQL Server
Discusses the various SAN and NAS protocols (FC, iSCSI, NFS) and how choosing one over the other can impact your SQL Server Performance.
2015-07-24 (first published: 2012-04-24)
18,243 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you’ve been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers