Trying to Figure Out if SQL Server 2008 Data Compression Will Benefit You?
SQL Server 2008 (Enterprise Edition) offers row and page compression, which can potentially offer a boost in disk I/O in...
2008-12-08
1,517 reads
A Custom Trace
I have to admit that when I had a performance problem with some code, I would often fire up Profiler...
2008-12-08
703 reads
Using Result Set as Variable in Stored Procedure
I’ve been asked several times lately from non-SQL developers that are sometimes required to do some quick SQL work how...
2008-12-08
3,442 reads
Tampa Code Camp Notes
I attended the Tampa Code Camp this past weekend. It was located at the Kforce Building in Tampa, a very...
2008-12-08
1,111 reads
Managing By The Numbers Part 1
I have a long held belief that if you really care about results, you have to measure them somehow. The...
2008-12-07
321 reads
Starting a Technical Blog (Link)
Brent Ozar had a nice post recently on starting a technical blog, well worth reading and a good addition to...
2008-12-07
283 reads
A skinnier SQL Server Magazine
I could have sworn that my SQL Server Magazine seemed much smaller this month. When I pulled out last’s months...
2008-12-07
1,312 reads
Database Administrtion Skillset Investment Rules
With each new release of SQL Server version, there is something new to learn. In SQL Server 6.5 days, it...
2008-12-05
809 reads
Inbox Zero
An interesting idea in this video. I’d recommend you watch this if you have too much email. It's from the...
2008-12-05
435 reads
Keeping Shorn
One interesting thing about doing the podcasts and working from home is that I tend to shave a bit more...
2008-12-05
395 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