An interesting sql question: dba.stackexchange.com/questi… Just in case any one is still here monitoring #sqlhelp

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

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

@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

Hey Devs, quick question! As someone still learning the ropes is using #StoredProcedures considered good practice these days? Any advice? #JuniorDev #DevAdvice #CleanCode #SoftwareEngineering #FullStackJourney #SQLHelp #DatabaseDesign #LearningToCode

Has anyone in the #SQLCommunity created a test suite for #SQLServer Audit that they can share? #sqlhelp #azuresql

#sqlhelp does a parallel batch mode hash aggregate need a lot more memory than what SQL Server normally estimates? 44 billion row columnstore table. Query is simple: SELECT DISTINCT column_one, column_two. Data types are bigint and nvarchar(500). Optimizer guesses about 5 million unique combinations when in actuality there are about 2.5 million. Memory grant is 1.5 GB which seems like it ought to be enough to store the hash table based on the amount and size of the data. When it spills, it uses about 2TB of tempdb (it must be spilling the data pages of the table?) to avoid the spill, I actually need about 23GB of memory. Any explanation of this behavior would be helpful! When it spills, it gets to spill level 3 and reports about 263 million pages spilled.

I'm trying to create a relationship between two tables in #PowerBI Desktop. (one is a bridge table, the other a dimension). I configure the relationship, hit create, PBI says "working on it" but nothing happens. No error. Ideas? #sqlhelp

Anyone have an idea how you can swap a calculated column in #PowerBI with a "real" column (from Power Query or DWH) without breaking reports? #sqlhelp

Has anyone successfully published a database project (SSDT) to the new #microsoftfabric SQL DB? #sqlhelp

I don't think that's feasible as the constraint is applied to the entire table on that column and not individual rows, so a full scan is expected IMHO here #sqlhelp

Asking a #sqlhelp question. That's so 2014. How do I add a trusted check constraint quickly? dba.stackexchange.com/q/3438…

#sqlhelp #sqlfamily Any recommendations of training material to get certified on databricks?

Hey #sqlhelp, does anyone know a way to retrieve plan cost from the plan cache or from a DMV? Even better, how to pull an aggregate value like SUM, MIN, MAX, etc. Any help is much appreciated! =^D

Ever had that "Aha!" moment when you finally squash that stubborn bug? Let's swap tales and tips. #SQLServer #Debugging #TechLife #ProgrammerHumor #CodeLife #ITCommunity #DatabaseManagement #SQLHelp #TechSupport #ITPros #informationtechnology #sqlsolutions

In the off chance that anybody is still using #SQLServer #MDS: a client has tables with millions of rows. They end with the _HS suffix, like " tbl_2_26_EN_HS". Can the data in those tables be purged? #sqlhelp

In place upgrade from SQL 2017 to 2022. Towards the end failed with "Can't create backup directory at K:\MSSSQL\BACKUPS". Drive doesn't exist. When server came back up, it was still 2017. And I can't upgrade to 2022 "No features to upgrade" #sqlhelp

What's the consensus on the fastest method for ETL/ELT on #SQLServer and #AzureSQL these days, #SQLHelp? Is it still tools - like #SSIS, #ADF, or #DBT? Or is it more like #Python scripts, or #Spark, or something else?

Anyone know if there's a way to filter Extended Events CAPTURE by the time the event occurred? There is the timestamp column included in the events output, but I can't seem to reference that as a way to perform a filter on it. #sqlhelp #teamxe Looking at you @erikdarlingdata

#sqlfamily #Sqlhelp I'm looking for an PowerBI contractor or expert that can look at our system of hundreds of reports and make sense of what is there. We had a report guy that was let go. And now it falls on my shoulders, and I am woefully unskilled nowadays in PBI.