In this article, Brad McGehee takes a brief look at four resource intensive queries that are running on the SQL Server instance that runs the SQLServerCentral.com website. Don't miss out on the competition in this article.
In a guest editorial, Rodney Landrum offers a light-hearted guide to role of each member of the cast in a typical SQL code deployment.
A discrete list of database objects is extracted from SSRS using SQL, SSIS, and RegExtractor in order to identify reports that might break when a schema upgrade is performed.
Steve Jones talks about the problems of outages, and why we ought to perhaps introduce failure into our systems to help us learn to cope with them.
Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.
Come join Steve Jones for a day of SQL Server training in Baton Rouge on Aug 6, 2011. Free training!
This Friday Steve Jones has a non-work related, but fun poll. Let us know what your geeky media recommendations are this year.
Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.
Write your database backup to multiple files. In addition to writing your database backup to one file you have the ability to write to multiple files at the same time and therefore split up the workload. The advantage to doing this is that the backup process can run using multiple threads and therefore finish faster as well as having much smaller files that can be moved across the network or copied to a CD or DVD.
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
Comments posted to this topic are about the item Why Your Index Isn't Being...
Comments posted to this topic are about the item Distance Metric Algorithms
Comments posted to this topic are about the item What Can AI Really Do?
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers