Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: azure-sql-database

Finding the row with the latest date for each row type

By adminPosted on January 30, 2023

Question : I’ve got an SQL database (SQLAzure V12 version running on Azure) that looks like the following: DECLARE @VehicleData […]

How to tell if an index has OPTIMIZE_FOR_SEQUENTIAL_KEY turned on?

By adminPosted on January 29, 2023

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

By adminPosted on January 28, 2023

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]

By adminPosted on January 27, 2023

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

By adminPosted on January 25, 2023

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?

By adminPosted on January 19, 2023

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

By adminPosted on January 13, 2023

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?

By adminPosted on January 9, 2023

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?

By adminPosted on January 6, 2023

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

By adminPosted on January 6, 2023

Question : I have a view containing N levels of nested views with UDFs and TVFs that I have to […]

  • 1
  • 2
  • 3
  • …
  • 40

Recent Posts

  • Convert seconds into HH:MM:SS format in MySQL
  • Guaranteeing a FK relationship through multiple tables
  • Is it Possible to Recover Data from a BLACKHOLE table? [closed]
  • MySQL: sysbench test – InnoDB vs Memory tables
  • Why are virtual log files not always allocated in order?
  • Need help to understand how information_schema.TABLES get updated
  • unique constraint on a set
  • PostgreSQL, integer arrays, index for equality
  • What is the most performant way to group by and join high cardinality columns in column based table?
  • LOAD DATA (400k rows) INFILE takes about 7 minutes, cannot kill the “logging slow query” process?
  • Is a process created in Oracle for every SQL statement?
  • How to select a row based on the maximum value of a column, when ties are expected
  • I am unable to join tables in correct manner
  • How often to backup database and what are the favoroble practices to do so [closed]
  • In Postgresql, after pg_dump the access privileges on the database itself are not restored
  • InnoDB Buffer pool not showing as much I configured in MariaDB 10.5
  • Which version of SQL Server 2016 supports R
  • Design DB for users with different information fields?
  • WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)
  • Speeding up group by and max query

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding