Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server
Search options not deleted
user 241429
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
5
votes
1
answer
488
views
Does database role permissions take precedence over schema/object level permissions?
I had an interesting observation on SQL Server security permissions.
My Setup is as below. I am trying to restrict user from updating tables under specific schema.
Problem statement is Why user is all …
- 186
1
vote
1
answer
40
views
Does SQL Service need restart after NW adapter teaming?
Recently we discovered in our AlwaysOn cluster, one node was using one NIC as stand-by in team of two NICs. While on another node it was using both NICs actively. We got first one changed to active as …
- 186
0
votes
1
answer
52
views
Why log_send_queue_size spikes all of sudden?
Environment details:
SQL Server 2019 (CU 19) - 96 logical processors, 1.5 TB RAM
Hosting 1 database of 3 TB
I have distributed availability group (async) setup which spans across two datacenters. Both …
- 186
1
vote
Accepted
Why log_send_queue_size spikes all of sudden?
Followed Sean's advice and noticed pattern of big log backups compared to other times.
So, I dug couple of log backups using fn_dump_dblog (WARNING: undocumented) where I saw the spikes and it seems q …
- 186
1
vote
"Test-SqlAvailabilityGroup" takes too much time
Test-SqlAvailabilityGroup evaluates health of your AG, which may take some time depending upon multiple factors.
If you just want to check if AlwaysOn is enabled or not, you can use this
(Get-SqlInsta …
- 186
1
vote
Accepted
Transactional Replication - Issue in Availablity Group
You cannot create publication on read replica. You can only do it on Primary which is Read-Write.
- 186
0
votes
Restarting primary SQL Server instance with log shipping
No you don't need to disable any job at all. Just make sure your backup job is not running at the time of restart, it may corrupt your backup in very rare case and it can disrupt your restore job even …
- 186
0
votes
1
answer
73
views
Can an odd number of stripes in RAID can affect tempdb performance if I have an even number ...
This is out of curiosity: since it is recommended to configure tempdb data files in an even number of sets so that it can get aligned with NUMA nodes evenly, I just wanted to know if it is the case fo …
- 186
1
vote
1
answer
172
views
Is Log stream compression enabled by default for asynchronous replicas in Distributed Availa...
I am seeding a database using distributed availability group. Seeding is automatic but synchronization mode is asynchronous. Log stream compression for automatic seeding is NOT enabled via TF 9567. Va …
- 186
0
votes
SQL Database Replication
Assuming you would be modifying data on Primary server only once a day, there are two methods should work for you
Daily refresh (Restore Full backup from Primary after ETL process is done to Secondar …
- 186
0
votes
1
answer
2k
views
How to parse JSON without key name in SQL Server
I have JSON values like following in a column. I tried parsing it using OPENJSON.
DECLARE @json NVARCHAR(MAX)='[[108,290,1388,2056],[108,290,1388,2057]]'
DECLARE @json2 NVARCHAR(MAX)='{"1":29893,"2":1 …
- 186
0
votes
2
answers
861
views
Backup on Distributed AG setup
I have setup a distibruted availability group and trying to understand behaviour of backups on it. While I can take backup from primary replica of Primary AG, I can not take backup from primary replic …
- 186
0
votes
0
answers
69
views
Why Bytes Sent to Transport/sec is different on different replicas?
I am troubleshooting latency for a specific replica in a Distributed AG setup (with 2 remote replicas).
Looking at perfmon I see clear indication as to why one replica shows delay. I see Bytes Sent to …
- 186
0
votes
1
answer
153
views
Does NOT FOR REPLICATION affect query plan generation?
I do understand why replicated articles have not trusted FK constraints, but wanted to know if I force FK for trusted anyway, will query plan actually change?
- 186
2
votes
3
answers
814
views
What affects log_send_rate in Normal or Distributed AG other than OS resources?
I am observing low log_send_rate in my distributed AG setup.
I understand that AG uses log stream and so I assume it should not have anything to do with data, but I was wondering if this has anything …
- 186