The Mystery Of The Slow Last Row
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
Changing Text in Multiple Stored Procedures From a Stored Procedure
In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL.
Configuring Kerberos Authentication
Longtime author Brian Kelley brings us a new article on security and Kerberos authentication in SQL Server.
How to Deal with the Stresses and Anxieties in Today's IT Industry
Today we have a guest editorial from Stanley Popovich that talks about dealing with stress at work.
Patch Week
With SQL Server releasing new cumulative updates this week, Steve Jones talks about the patching strategy of SQL Server.
SSRS Reports Performance Debugging and Analysis
SSRS provides a very user friendly way to author and deploy reports. These reports can be accessed from different platforms where the reports are deployed - reports manager, SharePoint, stand-alone / distributed applications or programmatically using SSRS SOAP endpoints. Unfortunately, SSRS / BIDS does not provide any high-end debugging tools such as SQL Profiler for analyzing the performance of SSRS reports. In this tip we will look at different ways of debugging and analyzing SSRS reports performance using execution logs and freeware tools.
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
The default trace in SQL Server - the power of performance and security auditing
Since the introduction of SQL Server 2005, there is a simple lightweight trace that is left running by default on every SQL Server. This provides some very valuable information for the DBA about the running server, but it isn't well-documented. Feodor Georgiev reveals many of the secrets of this facility and shows how to get reports from it.
What Differentiates Enterprise?
This Friday Steve Jones asks you about the Enterprise Edition of SQL Server, and what should the distinction be?
SQL Server 2008 Service Broker - Conversation Priorities
SQL Server 2008 Service Broker lets you process higher priority messages and conversations earlier than those with lower priority.
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers