How Stale Are My Statistics?
Unlike fine wine, you typically wouldn’t want your statistics to be aged. At least for tables that are being updated...
2010-11-05
11,849 reads
A Brute Force Way to Compress a Database
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-05
2,030 reads
Dr. DMV Queries From Fall 2010 SQLConnections Conference
This is the SQL Server 2008/2008 R2 version of the DMV Diagnostic Information Queries that I did for my Dr....
2010-11-04
876 reads
An Invitation To Come To My PASS Summit Session On Blogging And Speaking
On Wednesday morning at 10:15 AM during the 2010 PASS Summit next week I'm presenting "Getting Started In Blogging And...
2010-11-04
712 reads
SQL ServerPedia – Blog Awards
I have been catching up on some blog posts and I read a few posts by well known bloggers like...
2010-11-04
598 reads
Ascending Mount BI Stack: Basecamp
Not quite Mount Doom but...
As some of you may know, I’ve recently transitioned over from the fabulous life of being...
2010-11-04
608 reads
Return of the Index Analysis Report
Let’s Anaylze An Index! Finally up to the last post of this series resurgence. Time to update the Index Analysis...
2010-11-04
1,157 reads
What’s in a Full Backup?
I got asked a question today that I though was quite interesting. If my backup starts at 6pm and it...
2010-11-04
686 reads
SQLServerPedia Award Nomination
I thought this week was going to be pretty low key. SQL Saturday 58 has wrapped up. The PASS Summit...
2010-11-04
982 reads
Slides and Example Code for SQL Lunch #42 - Auditing Database Permission in SQL Server
As promised, here are the slides and sample code from my SQL Lunch presentation today. Thanks for all who came...
2010-11-04
686 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers