Schema & Renaming Fun
I wrote the SQLServerCentral question of the day that is live today called Schema & Renaming Fun. Mildly interesting, but looking...
2014-03-12
470 reads
T-SQL Tuesday #52 – Arguments
It’s time for T-SQL Tuesday, this month hosted by Michael J Swart, our artistic DBA in the community. I love...
2014-03-11
950 reads
Why worry about CXPACKET
Many people see CXPACKET at the top of their waits and start trying to fix it. I know this topic’s...
2014-03-11
1,623 reads
SQL Jobs – Complete Information – SQL 2000/2005/2008/R2
SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns...
2014-03-11
413 reads
SQL Jobs – Complete Information – SQL 2000/2005/2008/R2
SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns...
2014-03-11
780 reads
Local TempDB on SQL 2012
This post has been sitting in the draft folder for way too long, March of last year to be precise....
2014-03-11
1,774 reads
Call For Speakers for SQLSaturday Houston (Before TechEd)
SQLSaturday returns to Houston this year, this time at San Jacinto College on May 10, 2014. That’s the Saturday just...
2014-03-11
400 reads
Changing the 1000 separator in Power View
Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box,...
2014-03-11
1,008 reads
sp_updatestats Is Not Smart
No, I don’t mean the use of sp_updatestats is not smart. It’s a fine, quick mechanism for getting statistics updated...
2014-03-11
1,129 reads
Buffer Pool Extensions in SQL Server 2014
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-11
1,925 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers