Explore tweets tagged as #SQLhelp
#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?
2
1
0
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
1
0
2
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
1
0
1
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
1
0
0
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: But I'm getting the enclosed error message during the certificate creation. What am I doing wrong? #sqlhelp
1
0
0
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
0
0
0
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.
3
1
2
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.
3
2
10
Are unnecessary #joins slowing down your query performance? Optimizing joins can be a huge boost for large datasets. Morgane Rouvroy explains how Yellowbrick's optimizer removes unnecessary joins - read it here. #SQL #SQLHelp #QueryTips.
1
1
2
#sqlhelp @AndyLeonard I'm importing a csv into a db. The date (database time [DT_DBTIME]) are like .6/22/2023 18:30, 9/17/2023 23:18.In the db, they keep the same time, but the date changes to the current one as. 2023-11-28 18:30:50.000.2023-11-28 23:18:50.000.Please guide.
1
0
1
#sqlhelp @kekline @solarwinds I have some AGs where sometime the dbs don't failover and we don't get notified. Is there a specific alert we can set up for that? . [Unable to access availability database 'X' because the database replica is not in the PRIMARY or SECONDARY role.
4
0
1
