Question : I’ve got an SQL database (SQLAzure V12 version running on Azure) that looks like the following: DECLARE @VehicleData […]
Tag: azure-sql-database
How to tell if an index has OPTIMIZE_FOR_SEQUENTIAL_KEY turned on?
Question : SQL Server 2019 brings the OPTIMIZE_FOR_SEQUENTIAL_KEY option that, as far as I know you specify on index creation […]
Database user permissions: GRANT VIEW DEFINITION but DENY on some object types
Question : I’m trying to figure out a combination of permissions that will allow a partner to see basic db […]
Improve speed of stored proc with lots of inserts [Azure-SQL]
Question : Running an S0. @@version = Microsoft SQL Azure (RTM) – 12.0.2000.8 Jul 21 2017 14:10:34 Copyright (C) 2017 […]
Create Temporary Access to production support
Question : We’re thinking of creating a web site where a manager can provide temporary access to a person for […]
Is it good practice to have relationship between the tenant table and all other tables in a multi tenant application?
Question : I am developing a multi tenant SaaS that uses Azure SQL for data storage. I make use of […]
Executing query against Azure SQL db using Linked server takes hours
Question : I have a linked server to Azure SQL database and I am trying to run the below SQL […]
Optimize query plan when your results are either a few rows or hundreds of rows?
Question : The most frequent query typically uses a variable that has hundreds of rows, but also runs often with […]
Why does PK constraint require a separate index when I already have a suitable unique clustered index?
Question : This is part of table definition from here: CREATE TABLE [dbo].[JobItems] ( [ItemId] UNIQUEIDENTIFIER NOT NULL, — lots […]
Finding source query in execution plan of nested views and UDFs
Question : I have a view containing N levels of nested views with UDFs and TVFs that I have to […]