What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered.<?query --SELECT [GroupBy1].[A1]...
2016-11-11
342 reads
Friday Reading 2016-11-11
It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks...
2016-11-11
304 reads
Linked Server Security
Problem
When creating Linked Servers, security often gets overlooked. This can lead to accounts on one instance having access, sometimes with...
2016-11-11
22,412 reads
SQL Server 2016–Live Query Statistics
WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while...
2016-11-15 (first published: 2016-11-10)
2,067 reads
Azure SQL Server 2016 VM
With Windows Server 2016 just been released, now is the perfect time to build an Azure VM with SQL Server...
2016-11-10
1,041 reads
The PASS Global Alliance Program (GAP)
One of the topics I forgot to mention from the Roundtable was a swell of dissatisfaction with the GAP. Not...
2016-11-10
402 reads
Is it safe to grant Administer Bulk Operations?
First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are...
2016-11-14 (first published: 2016-11-10)
2,343 reads
Query tuning 101: Problems with IN ()
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,721 reads
CHECKDB’s Hidden Snapshot
I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...
2016-11-10
468 reads
SQL Server 2016 - “Number of Rows Read” on Execution plan
One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan....
2016-11-10
844 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