Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues
This tip describes memory pressure issues that can arise from the RESOURCE_SEMAPHORE Waittype and how to find which query or transaction is causing the memory pressure.
Encryption Not Restriction
Encryption keys for services in the cloud should be maintained by the customer, according to Steve Jones. It's actually a good idea for all of your data.
Free Webinar: Statistics in Oracle and SQL Server
In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.
SQLServerCentral Runs sp_Blitz - Performance Part 1
The third article that examines the output of the sp_Blitz script™ run against SQLServerCentral's database servers.
Hypothetical Indexes on SQL Server
Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take too long. Is there another way? Well, yes, why not use the same method the DTA (Database Tuning Advisor) uses, and take the tedium out of the job.
Antipathy for Entity Attribute Value data models
EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.
The Data Scientist
Phil Factor on why Data Science is about much more than just clever visualizations and big data.
The Optimists
A develop should be a glass-half-full kind of guy, at least according to Steve Jones. This editorial was originally published on April 15, 2008. It is being re-run as Steve is on holiday.
VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types
Despite NTEXT and TEXT being deprecated in SQL Server for some time they are still both used in production systems. In this article, I will briefly demonstrate the difference between a VARCHAR (MAX), NVARCHAR (MAX) and the NTEXT data types, and the impact on performance from using NTEXT/TEXT.
Blogs
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Databases and AI Agents
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers