All Questions
Tagged with sql-server azure-sql-database
552
questions
2
votes
1
answer
82
views
Query Store Plan Forcing is Failing with OPTIMIZATION_REPLAY_FAILED
I am trying to use Query Store to force a particular plan in an Azure SQL DB database, and it's not obeying me! I've checked in sys.query_store_plan, and it has a column which describes the reason for ...
- 121
-1
votes
1
answer
67
views
How do I measure the SQL Database responsiveness
I am load testing my web app which is Azure App Server + Azure SQL Database.
I am looking at the the Azure data dashboard metrics as we load test it and most measures (DTU percentage, CPU percentage, ...
- 181
8
votes
3
answers
887
views
View doesn't recognise a change to an underlying table when an existing column is dropped and replaced with one with the same name but as computed
My understanding here is that when a View is created, the definition is stored in metadata sys.tables. i.e. sys.views.
Also, that if you use SELECT * FROM it will store the exact column names e.g. ...
- 513
1
vote
0
answers
51
views
Spatial index performance
I need help to improve query performance of a spatial query.
I have the following query:
DECLARE @Longitude float,@Latitude float
SET @Longitude = -79.46278668733325
SET @Latitude = 43.70410072435495
...
8
votes
2
answers
574
views
%%LOCKRES%% - SQL Server - Row identifier causing Deadlocks - possible bug
Recently I came across an issue where I am facing deadlocks in SQL Server databases (19.2.56.2) due to the internal hashing mechanism of the Row identifier virtual column - %%LOCKRES%%
On analysis I ...
- 81
0
votes
1
answer
38
views
View on a history table - question how implement a view on history table
question about creating a view with history table.
I've got a table that i moved old rows to history table,
now i would like to delete the data from the main table.
Main table : Currency....
- 47
4
votes
1
answer
248
views
Granting SELECT...INTO permissions
I've created a new schema, archive, and am able to create, read, update and delete tables within it.
I have an EXTERNAL_USER who I'm trying to give permissions to so that they can carry out select.....
- 163
0
votes
1
answer
95
views
SSMS Won't Show Databases in the Explorer Tree for a Specific SQL Server Account
When logging in as a specific SQL Server user, I was unable to view all the databases in the SSMS Explorer tree. Originally, I thought this was a SQL Server user account problem. I examined the Login ...
- 157
0
votes
2
answers
95
views
How does this user log in to the database server, when its login is deactivated on the database server?
I've specifically disabled a login on the database server. This is an Azure hosted SQL-as-a-Service database.
alter login [********@hotmail.com] disable
Here's what the login looks like on the server....
- 157
0
votes
1
answer
118
views
How do I create user logins on my read replica database?
Is it possible to have different users accessing my read replica DB? Isn't this in fact a popular use case for a read replica? I want a certain limited set of credentials to have access to my primary ...
- 157
2
votes
1
answer
76
views
Getting "PAGEIOLATCH_SH" on a Named Replica of a HyperScale Database in Azure?
I have a monitoring query that populates a dashboard. It was created to monitor the transactions that occur on the primary replica. To avoid overloading the Primary Replica, I created a Named Replica. ...
- 19
0
votes
1
answer
153
views
How automate backup and restore in Azure SQL Managed Instance?
I'm the DBA of one Azure SQL Managed Instance and one of our clients asked us if is possible automate a backup and restore in order to have a copy of one of the database before one of our ETL procces ...
- 21
-4
votes
1
answer
73
views
How can i write a sql statement to get customers who have rented at least one film from each category from dvdrental
How can i write a sql statement to get customers who have rented at least one film from each category, to Return customer_id, first_name and last_name. from dvdrental
- 1
0
votes
0
answers
100
views
Database disappear from Failover Group
I run an Azure subscription with a main SQL Server in West Europe and a georeplicated SQL Server in North Europe with a failover group. In these servers I have two elastic pools with the same name.
...
- 101
0
votes
0
answers
22
views
Azure SQL Can't Connect to DB through SSMS Though User Can Log Into Different DB on The Same Server
I have a SQL Server on Azure with two databases which I can see just fine with the admin account
Now using a regular user account I need to specify the DB i want to connect on the configuration ...
- 1