Do You Want to Be Right?
Steve Jones talks about being right versus being effective in your IT work.
Do You Want to Be Right?
Steve Jones talks about being right versus being effective in your IT work.
Do You Want to Be Right?
Steve Jones talks about being right versus being effective in your IT work.
The Database Weekly Update for June 16, 2008
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
The Database Weekly Update for June 16, 2008
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
The Database Weekly Update for June 16, 2008
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
Eliminating Cursors
T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance.
Include Column Headers From SSMS
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
Compound Assignment Operators in SQL Server 2008
MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.
Introduction to the Unified Dimensional Model (UDM)
This paper provides an introduction to the Unified Dimensional Model (UDM), including the basic end-user model, and a brief overview of the architecture and security models.
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