Questions About SQL Server Distribution Statistics
Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1
Learn how to create a Windows 2008\SQL Server 2008 virtual cluster in this three part series.
Halfway Through 2011
Steve Jones stops halfway through the year to look over the things that he ought to be doing to better manage systems as a DBA and reminds you to do the same.
Lesson #6: What CIOs really care about
This editorial was originally published on Dec 30, 2005. Steve is traveling to the UK this week and we are reprinting editorials.
TSQL Challenge 60 - Generate a relational tree structure from a string
Your job is to read a string containing product hierarchy information and generate a relational table (result set) representing the hierarchy of categories.
Free ebook: SQL Server Execution Plans
This free book is brought to you by Red Gate Software and Simple Talk Publishing. Why my query is running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed guide to this essential topic.
Monitor SQL Server Replication Jobs
The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job) SQL Server jobs execute a binary executable file which is basically C++ code.
Self-aware Instances
For this Friday's poll, Steve Jones talks about a fundamental architectural decision for your software. Do you want central control or a series of distributed processes, each one self-aware, and able to act on its own.
SQL Overview SSIS Package II - Retrieving SQL Error Log
In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers