|
|
|
|
|
|
|
| Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
SQL Server Vector Support II | |
| With regard to SQL Server 2025's Vector support, what is an embedding? | |
Think you know the answer? Click here, and find out if you are right. | |
| Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Hyperscale Replicas V I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica? Answer: No Explanation: As of Oct 2026, a second geo-replica on a first geo-replica (replica-chaining) is not supported. Ref: Hyperscale secondary replicas - https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-replicas?view=azuresql-db |
| Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Development |
| Inventory Snapshot for missing Period - Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels. However, a new record is only created when there is a change in the inventory value. As a result, if an item has an inventory value of 200 in January 2026 and the value remains unchanged through March 2026 with value […] |
| SQL Server 2019 - Development |
| MERGE in a nested TRY/CATCH won't roll back - I have a section of code similar to the following abstract: DECLARE @loop [int] = 0, @savepoint [varchar](4) BEGIN TRY BEGIN TRANSACTION _OUTER_ WHILE (@loop < 10) BEGIN SELECT @loop = @loop + 1, @savepoint = '_' + CAST(@loop AS [varchar](2)) BEGIN TRY BEGIN TRANSACTION SAVE TRANSACTION @savepoint MERGE ... -- This transaction works MERGE […] |
| SQL Azure - Administration |
| Managed Instance vs Azure Database - is this a good option? - We're currently in Azure, however as we had a very tight migration timeline when we moved, we've been using SQL Server on Azure VMs for the last several years. There's a push in the organization to go "cloud native," and on the database side, well, I see some potential headaches. My question can be boiled […] |
| Editorials |
| A Heavy Heart - Comments posted to this topic are about the item A Heavy Heart |
| AI Is Improving Security - Comments posted to this topic are about the item AI Is Improving Security |
| Making an Impression - Comments posted to this topic are about the item Making an Impression |
| Article Discussions by Author |
| Hyperscale Replicas V - Comments posted to this topic are about the item Hyperscale Replicas V |
| Calculating Weighted Average in Power BI - Comments posted to this topic are about the item Calculating Weighted Average in Power BI |
| SQL Server 2025 Server-level Roles - Comments posted to this topic are about the item SQL Server 2025 Server-level Roles |
| Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions - Comments posted to this topic are about the item Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions |
| Azure SQL Hyperscale Unveiled - Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled |
| MiniMax m3 and SQL Server - Comments posted to this topic are about the item MiniMax m3 and SQL Server |
| SQL Server Vector Support I - Comments posted to this topic are about the item SQL Server Vector Support I |
| SQL Server 2022 - Administration |
| Perfermance result aftet purge operatio - Hello everyone, I am planning to implement a data purging solution that is expected to reduce the size of one of our main databases by nearly 50%. One of my colleagues believes that the performance benefits will be limited. His argument is that most queries access data through Index Seeks, so reducing the amount of […] |
| What is the worst part about existing monitoring solutions? - Hi. What is the most difficult aspect of using monitoring software like idera, redgate, solarwinds? |
| |
| ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |