#sqlhelp Has anyone figured out a way to change the time zone setting on an Azure Managed Instance? I know the documentation says it's not possible, I'm just hoping it's wrong or out of date or maybe someone figured out a hack?

@SteveClementJax From my understanding, that trace flag is applicable to SQL Server 2016, 2017, and 2019. SQL 2022 should be functional without the trace flag applied. #sqlhelp support.microsoft.com/en-us/topic/kb…

For SQL friends - is TF 8291 needed to enable the associated patch in SQL 2022, or is it on by default and the TF is only needed in 2019 and lower? #sqlhelp

Trying to run Azure blob backups to URL but getting this error: "Exception 0xc06d007e EXCEPTION_MOD_NOT_FOUND for module 'sqlfabric.dll' (Error: The specified module could not be found." - what feature or setup option did we miss during install? @SQLBalls @TalesftField #SQLhelp

#sqlhelp Howdy! Anyone run two (or more) concurrent DiskSpd tests to simulate a workload? Wonder if there are any special considerations.

Need urgent help with C#, Python, SQL, or Web Development Projects? ✅ Clean code, fast delivery ✅ Assignments | Bug Fixes | Custom Projects Trusted freelance developer on Fiverr! 🔗fiverr.com/s/8zDyPZvB #PythonDeveloper #CSharp #SQLHelp #CodeHelp #FreelancerForHire #WebDevV

I have 2 questions about SSMS 21: 1. How to best install and upgrade it in an offline environment at scale? 2. Will it still be security patched via Windows Update? #sqlhelp

@leemarkum I most certainly could be wrong (and I'm jetlagged), but yeah, my understanding is that those are physical writes. Memory first, yes, but also down to disk. #sqlhelp

#SQLHelp All, app jobs running slower after applying window patch v4.0.30319. Wintel uninstalled patch but still slowness. Observation: queryenumerator::current exception detected. System.componentmodel.win32exception: wait operation timed out. Any help will be appreciated.

Does Oracle support sorting dates with a sense of humor, or do they strictly prefer chronological sarcasm? Source: devhubby.com/thread/how-to-… #Database #TechTips #SQLHelp #OracleHelp #oracle #date

reddit.com/r/SQLServer/s/… #SQLHelp #SQL #SQLServer #TSQL Datefromparts and getdate seemingly nondeterministic even though I am taking only the month and year parts in a cte

#sqlhelp #sqlserver Can someome help me understand why the below query was non deterministic when running parallel. I am taking only month and year parts from getdate I know getdate is nondeterministic but I am not even taking day part from it let alone time Can someone expl

@SQLBalls @DBABullDog @GFritchey Is there a way to estimate how many ghost records are left to clean? I'm experimenting with sp_clean_db_free_space and it's been running for 2 hours #Sql #SqlHelp

Yesterday one of our SQL2019Std instances allocated over 70% of memory to the OBJECTSTORE_LOCK_MANAGER clerk, causing memory grant waits. No excessive locking seemed to be occurring, and we manually had to flush the clerk. 1. Should this clerk not have freed itself? #sqlhelp 1/x

💻 Battling with ER diagrams, SQL queries, or normalization? Let our experts simplify it for you — with clean scripts, real-world case studies, and 100% plagiarism-free solutions. 📞 Instant help is just a message away! #SQLHelp #ERDiagram #AssignmentHelp #MBAAssignmentExpertCj

I've got a column with decimal(38,20) as data type. If I multiply the column with 1, I get a "Arithmetic overflow error converting numeric to data type numeric.", also if I use 1.0 or 0. When trying to convert to numeric(20,10), same error. #sqlhelp

Seems like #sqlhelp is dead. :( Where are people going these days for community help for SQL Server?

Is there a way to create a lakehouse in #MicrosoftFabric with the workspace identity as the owner? #sqlhelp

@LimeGargoyle Should be able to alter that directly and not require data movement suspension. It’s been a while since I’ve tried it and can’t test it at the moment. #sqlhelp

#sqlhelp I’m trying to change file growth settings for a database in a SQL 2016 Basic Availability Group. Can that be done directly, or do I need to remove it from the AG, make the change and re-add? Is suspending data movement during the change possible? #sqlhelp