PowerShell Script for Creating Indexes
I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...
2010-01-21
1,814 reads
Blog Posts
Speaking at European PASS
I just heard that two of my presentations have been accepted for the European PASS Conference 2010 in Neuss, Germany,...
2010-01-21
691 reads
Speaking at SQL Saturday Tampa and Richmond
Over the next two weekends there will be three SQL Saturday’s held, in Tampa (1/23), Boston (1/30) and Richmond (1/30).I...
2010-01-21
583 reads
SQL Server 2008 - Top Reasons to Upgrade.....
OK, you've seen many of these before, but if you haven't figured out its TIME to upgrade your SQL Servers to...
2010-01-21
1,217 reads
SQL Server 2008 R2 - official date
Since the August 2009 when the CTP ( Community Technology Preview) version was available, the Microsoft announced the offical release date...
2010-01-21
450 reads
SQL Server 2008 R2 to be Available in May
This past Tuesday, Microsoft officially announced that SQL Server 2008 R2 will be available in May 2010. See the announcement...
2010-01-21
679 reads
SQLSaturday #32 – Tampa
Just a reminder that SQLSaturday #32 – Tampa is taking place this weekend (January 23rd). This will be my 5th SQLSaturday...
2010-01-21
355 reads
Using sp_ExecuteSql to Run Dynamic SQL
Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...
2010-01-21
655 reads
Can query performance be dependent on the client?
This question sounds really easy! The query performance depends essentially on the execution plan, which in its turn isn’t dependent...
2010-01-20
657 reads
Collaboration Patterns – Part 2
Recently I caught a few minutes of a CSPAN interview with Chief Justice John Roberts, part of a larger presentation...
2010-01-20
494 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