Viewing 15 posts - 1 through 15 (of 7,253 total)
Did you check this article . https://techcommunity.microsoft.com/t5/azure-sql-blog/using-query-store-with-least-privileges-instead-of-db-owner-to/ba-p/775177
April 16, 2024 at 6:24 pm
If relationship is 1 - 1 -> inner join
If relationship is 1 - n -> exists
April 16, 2024 at 7:32 am
Don't you monitor your connections (using XE) ?
"Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"
April 12, 2024 at 9:47 am
Why not just schedule the TSQL statement in a sqlagent job?
or use a powershell jobstep to create the backup using sqlagent ( or scheduled tasks if for express edition )
April 9, 2024 at 7:32 pm
are you querying cross domain ? ( add the domain extention ! )
April 5, 2024 at 12:35 pm
I have to scan a bunch of servers for failed logins. As part of this process, I want to get the incoming host names. However, the SQL log file...
April 5, 2024 at 6:54 am
Hi all.
I wanted tyo report back that i was able to overcome this issue by doing the loopback reg fix
you can find it here https://learn.microsoft.com/en-us/troubleshoot/windows-server/networking/accessing-server-locally-with-fqdn-cname-alias-denied
Method 2
Thank you...
March 26, 2024 at 2:44 pm
Start with avoinding functions in where clauses ! ( needs full ( index ) conversion before actual use )
Declare @RefTs datetime2(0) = dateadd(MM, datediff(MM, 0, GETDATE()) -...
March 25, 2024 at 12:15 pm
Can this ref be applicable for your issue?
gMSA account authentication failure during password rotation
March 21, 2024 at 1:08 pm
spid -2 is supposed to be an orphaned DTC transaction.
ref: Disaster recovery 101: dealing with negative SPIDS (-2 and -3)
March 19, 2024 at 12:57 pm
Johan, you would need to check with the vendor, but I don't belive that performance improvements are the core reason. I belive that for some special purposethey choose KS+WS...
March 19, 2024 at 8:04 am
It is indeed scheduled in the weekend (using SQLAgent and Powershell).
Still 23 minutes is a long time to collect these statistics for this single database.
It's a good thing not all...
March 18, 2024 at 5:29 pm
Currently we are collecting database statistics information using
select * FROM sys.dm_db_index_physical_stats( 14, NULL, NULL, NULL, 'SAMPLED')
For some larger databases this statement takes more than
March 18, 2024 at 3:10 pm
We collect these statistics on a weekly basis.
This way we persist runtime history for all monitored instances.
This comes in handy when provisioning for growth or planning migrations.
Devs and application teams...
March 18, 2024 at 2:43 pm
Can you save and post the deadlock graph ?
An .xdl file can directly be opened by e.g. Solarwinds Plan Explorer (free tool), which has a great replay feature, helping...
March 18, 2024 at 8:39 am
Viewing 15 posts - 1 through 15 (of 7,253 total)