Question : I’ve been struggling to understand how to deal with a specific type of performance issue that shows up […]
Tag: azure-sql-database
Why is DistinctSort followed by TopNSort in my query plan?
Question : I have the following definition: CREATE TABLE [dbo].[JobItems] ( [ItemId] UNIQUEIDENTIFIER NOT NULL, [ItemState] INT NOT NULL, [ItemCreationTime] […]
Using CROSS APPLY OPENJSON causes Azure to hang
Question : I have a table with around 8 million rows with a schema of: CREATE TABLE [dbo].[Documents]( [Id] [uniqueidentifier] […]
SQL Server credentials – Maximum Password size
Question : What’s the maximum password size I can get on SQL Server 2012/2014? I was unable to find this […]
Slow JOIN on tables with millions of rows
Question : In my application I have to join tables with millions of rows. I have a query like this: […]
How to apply Static Data Masking With Replication of Database [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Shopping list question – questions about which […]
Questionable duplicate index suggested by optimization
Question : Good day, I have the following sql server database table: Please note the compound primary key. This was […]
From Azure-DTU to regular machine
Question : There’s a way to calculate how many DTU’s a given regular server outputs, but i need the other […]
Managed Instance Restart
Question : Does anyone know how to restart a SQL Server Managed Instance? The stop / start / reset are […]
Can Oracle Heterogeneous Services be used to connect to a SQL Azure database?
Question : I would like to be able to use a database link from an Oracle 10g database to a […]