#SQLHelp #AzureSynapse What do I need to do so that the view I created (with a SQL Script in Synapse) show up in the Views in the Synapse Studio UI? I can see it from SSMS?

Does Oracle support sorting dates with a sense of humor, or do they strictly prefer chronological sarcasm? Source: https://t.co/AjId6kOsWN #Database #TechTips #SQLHelp #OracleHelp #oracle #date

How do I fix this? Can't get to the top of the pane. #SQLHelp

Has anyone tested to enable 'max RPC request params (KB)' on their SQL 2019 CU 26 or 2022 CU13, and what specific issue did you solve? I am not seeing a memory problem on the app side now and I don't have a spare server to test this in. #sqlhelp

Anyone know where I can grab the Synapse Spark pool icon in lossless format such as png? Tried the usual places (az glyphs and icon packs) and haven't found it yet #sqlhelp cc. @MarkPM_MSFT

Does anyone know which command you should use to override a default Lakehouse in a Notebook in #microsoftfabric? So you can parameterize it in an easy way. You can see it in DevOps, but how to overrule this data. #sqlhelp #mvpbuzz

Synapse pipeline most useless error message ever! Pipeline validates but debug results in this!!! Anyone have any idea how to figure out what it's mad about! It worked before and then I made some changes. I really don't want to undo all I did. #SQLHelp

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

I'm trying to import the Azure-trusted root certificate authority keys to #sqlserver to set up a SQL Managed Instance Link as described here: https://t.co/h5rAOs2qA0 But I'm getting the enclosed error message during the certificate creation. What am I doing wrong? #sqlhelp

in a powerbi report, i used conditional formatting with icon on the values of 0 and 1, coloring them red and green. Most fields work. A few simply refuse to work. I cannot determine why. They are all configured the same way. Some seemingly ignore the values #sqlhelp

#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

#sqlhelp Anyone else using a business-critical managed instance on Azure? When I go to the compute & storage tab it's showing that we have 4 vCores and 1tb of storage. Both of which are very much not true.

I noticed avg write stalls on tempdb of over 100ms. I raised the issue and was told it doesn't hurt user queries because those writes happen in memory. I always thought writes to data files were physical IO that happen during working in tempdb. Can someone clarify? #sqlhelp

#sqlhelp log_reuse_wait_desc is showing XTP_CHECKPOINT. Can't shrink the tlog...also did set it to simple then shrink but still can't release space. Any tricks on this? SQL 2022

SQL folks, what has been your most practical use of Extended Events? #sqlhelp

Is there a set of sample end user queries that can be used to simulate a workload on WideWorldImportersDW similar to what is available from the TPC datasets? I need to simulate a user load but can't seem to find anything to use as a starting point. #SQLhelp

#sqlhelp does anyone know how the index usage data is reset in azure sql? on prem it's since last restart. in one DB I checked I only see scan times going one day back but haven't checked every DB

Should a SQL Server VM be configured for dynamic memory? #sqlhelp

In the #ORACLE world a quick and dirty way to create arbitrary rows is insert<stuff> select <stuff> from dual connect by level < desired_row_count; How do people do this in the #sqlserver #sqlhelp world? cartesian join sys.all_objects?