SQL Server Transactions and Locking (Part 1)
In many situations, data modification requires several steps. For example, you may need to change the values ??in two separate...
2013-05-22
617 reads
Basit's SQL Server Tips
Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)
The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP...
2013-05-22
900 reads
SQL Server index related dynamic management views and functions (Part 3)
With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function...
2013-05-22
594 reads
Microsoft SQL Server 2012 Builds
The following table lists all builds of SQL Server 2012 known hotfixes, service packs and KB articles that have been...
2013-05-08
1,688 reads
Microsoft SQL Server 2008 R2 Builds
The following table lists all builds of SQL Server 2008 R2 known hotfixes, service packs and KB articles that have...
2013-05-08
21,351 reads
Microsoft SQL Server 2008 Builds (Last Updated May 20, 2013)
The following table lists all builds of SQL Server 2008 known hotfixes, service packs and KB articles that have been...
2013-05-08
1,341 reads
Microsoft SQL Server 2005 Builds
The following table lists all builds of SQL Server 2005 known hotfixes, service packs and KB articles that have been...
2013-05-08
2,643 reads
Microsoft SQL Server 2000 Builds
The following table lists all builds of SQL Server 2000 known hotfixes, service packs and KB articles that have been...
2013-05-08
2,393 reads
Microsoft SQL Server 7.0 Builds
The following table lists all builds of SQL Server 7.0 known hotfixes, service packs and KB articles that have been...
2013-05-08
1,179 reads
Find Duplicate Indexes on SQL Server (Script)
Like other mainstream commercial database systems, Microsoft SQL Server allows you to create multiple indexes on the same column of...
2013-05-07
1,222 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