Skip to main content
Share Your Experience: Take the 2024 Developer Survey
9 votes
Accepted

Granting SELECT...INTO permissions

The documentation for the INTO clause says: Requires CREATE TABLE permission in the destination database. But CREATE TABLE says: Requires CREATE TABLE permission in the database and ALTER ...
Paul White's user avatar
  • 85.8k
2 votes

View on a history table - question how implement a view on history table

Can i create a view with the name of the table Currency.InstrumentRates after changing main table to : Currency.InstrumentRates_main so that the change will be transparent to the client side? Yes. ...
J.D.'s user avatar
  • 37.9k
2 votes

Performance issue - using try catch to return data to service & how to use partition table with unique index

You need to add locking hints to avoid constraint errors. Otherwise what can happen is that the server checks the table, then releases the lock before inserting, allowing another session to jump in. (...
Charlieface's user avatar
  • 13.2k
2 votes
Accepted

What happens to my read-replica database in failover mode?

In the Azure portal on the Failover Group tab, there should be two endpoints, one that is for read-write workloads and one for read-only workloads (.secondary.). If you have your read-only workloads ...
Jonathan Fite's user avatar
1 vote
Accepted

SSMS Won't Show Databases in the Explorer Tree for a Specific SQL Server Account

Please look at this answer (reproduced below) on Stack Overflow by Joseph Xu: I think you'd better check the Options settings, did you specify the db name. If so, you will only can see specified db, ...
MBuschi's user avatar
  • 4,535
1 vote

Performance issue - using try catch to return data to service & how to use partition table with unique index

Avoiding TRY...CATCH Another option is to alter the existing unique index to silently reject duplicates: ALTER INDEX UX_SubscribersMessages_MessageId ON Saga.SubscribersMessages SET ( ...
Paul White's user avatar
  • 85.8k
1 vote
Accepted

How can I monitor query performance on my Azure read-replica database?

Query Store is not available on read replicas. One way to monitor query performance is using Dynamic Management Views (DMVs). You can rely sys.[dm_db_wait_stats] to monitor waits see script I shared ...
Alberto Morillo's user avatar
1 vote
Accepted

CXSYNC_PORT & "Long running low CPU"

The CXSYNC_PORT wait is a subcategory of CXPACKET wait and related synchronizing opening/closing of exchange port between consuming thread and producing thread. Long waits here may indicate server ...
Alberto Morillo's user avatar
1 vote
Accepted

Why can't I create more than 1 geo replica for my primary database?

You probably have already enable named read scale out or zone redundancy for the database and is counting that as part of the replication limit. With Hyperscale, named replicas or high availability ...
Alberto Morillo's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible