#sqlserver @MSFTLearn @mssqltips @PASSDataComm @SQLServerCentrl @SQLServer #SQLHELP !

A g u s t í n @pagani_cordoVe

a week ago

#sqlserver @MSFTLearn @mssqltips @PASSDataComm @SQLServerCentrl @SQLServer #SQLHELP !

keyboard_arrow_left Previous keyboard_arrow_right Next

2 0 1 89 0

Download Image

An interesting sql question: dba.stackexchange.com/questions/3494… Just in case any one is still here monitoring #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

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

@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

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

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

@MJSwart 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/343858/1782

#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

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.

#sqlhelp Is there a way for a SQLAgent job step to know which schedule started the job at runtime? I know it's logged in the history, but can't tell if it can be determined while running. Thanks.