PARTITION BY clause works incorrectly when in nested select over large volumes of data
I have been witnessing a very strange behaviour of ROW_NUMBER() PARTITION BY clause in complex join and nested select or...
2010-11-03
2,755 reads
Blog Posts
PASS Update #45 (Agenda for SQLSaturday Roundtable)
If you’re attending the 2010 Summit and are interested in helping improve SQLSaturday, I hope you’ll register and attend our...
2010-11-03
341 reads
PASS Update #46 (What Should PASS Be?)
I’ve been wanting to write this for a while, and I haven’t because I felt that I just didn’t quite...
2010-11-03
408 reads
Powershell and Policy Based Management
If you haven’t looked at Policy Based Management (PBM), and you manage multiple instances, you ought to really look at...
2010-11-03
971 reads
Service Broker – SQL Server Connections
These are some notes and thoughts from sessions and my time at SQL Server Connections/DevConnections in Nov 2010.
Denny Cherry gives...
2010-11-03
1,602 reads
SQL Saturday 58 – It’s A Wrap! #sqlsat58
It’s Tuesday after PASSMN’s first SQL Saturday event in Minnesota. After a restful weekend, I’m finally starting to completely wind...
2010-11-03
454 reads
SQLSaturday #59 – Speaker Interview #16 with DW Expert, Chuck Kelley
SQLSaturday #59 – Speaker Interview #16 with DW Expert, Chuck Kelley
Working on a large DW project, I had the pleasure of...
2010-11-03
818 reads
SQLServerPedia Award Votes
This is just another reminder to please vote for my blog post on using PowerShell Remoting with SQL Server. It’s...
2010-11-03
575 reads
Successful Teams: Everyone Performs
By day I'm a DBA. Nights and weekends I'm a junior high youth pastor and Awana commander. I have the...
2010-11-03
1,472 reads
VLDB Issues at SQL Server Connections
Kim Tripp is a great speaker, with a wealth of knowledge. This session was talking about some of the issues...
2010-11-03
727 reads
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
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...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
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