The HierarchyID Datatype in SQL Server 2008
This article examines one of the T-SQL changes coming in SQL Server 2008: The hierarchyID.
Views and Horizontal Partitioning
Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
Column-Store Databases and DW Appliances
With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.
Dynamic Search Conditions
ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.
2007 Tech Salary Survey Results
Dice.com recently completed a salary survey for 2007. If you didn't participate, Steve Jones summarizes the results for DBAs.
A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
Feature (In)Complete
A look at some of the interesting database news from the previous week (March 24, 2008).
Blogs
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,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
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