#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
#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?
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 Does anyone know of any downsides to using OPTIMIZE_FOR_SEQUENTIAL_KEY?
Hiya #sqlhelp, I have a contact who's looking for SQL container-related groups/communities/online resources. Who's got STUFF for them? And by stuff I mean recommendations. #sqlfamily
#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 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?
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
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
#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.
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
What is the smallest entity read into cache is it a page or an extent (or something different) google isn’t much help. Thanks #sqlhelp
How do I write a query that will get me a list of workers that earn above average salary? #sqlhelp #DataAnalysis
#sqlhelp Howdy! Anyone run two (or more) concurrent DiskSpd tests to simulate a workload? Wonder if there are any special considerations.
So when you update a varbinary value in SQL Server is is writing over it in the same storage location or just writing a new one and updating the pointer #sqlhelp
@SQLServer I have tried and done all things to install SQL server but unable to install, the same problem comes again and again . Please help me #sqlhelp
#sqlhelp Does anyone know of any downsides to using OPTIMIZE_FOR_SEQUENTIAL_KEY?
You can only adjust that upon creation. In order to change it you have to nuke the MI and start over IIRC. I do not know of any way to change it after it's been created. learn.microsoft.com/en-us/azure/az… #sqlhelp
#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?
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
Hi #SQLHelp. MS state that they have only ever tested an Always On SQL instance with 100 databases. Anyone out there have experience of having more than that? I know the general limitation is 32K databases on an instance. We have powerful hardware and SQL 2022 Enterprise. Thanks
Right off the top of my head back up to URL is not supported in Azure SQL DB or in Fabric SQL DB. However, back up to URL is supported on Azure SQL MI or in SQL Server if you have a configuration to Azure or if you are in an Azure SQL VM #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
l am testing @Veeam plug-in for #sqlserver . lt seems like their concept of full and different restore is the same. #sqlhelp community am l doing something wrong ?
#sqlhelp Howdy! Anyone run two (or more) concurrent DiskSpd tests to simulate a workload? Wonder if there are any special considerations.
Looking for a SQL Server expert to help boost your company's performance? Look no further! Contact us today for more information and let's take your database to the next level. #ContactUs #TechSolutions #SQLHelp #DatabaseConsultant #SQLPerformance #TechSupport #SQLOptimization
Database giving you trouble? SQL, MySQL, PostgreSQL — I design, fix, and optimize databases for you. DM today. #DatabaseHelp #SQLHelp #ProgrammingExpert
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/8zDyPZv #PythonDeveloper #CSharp #SQLHelp #CodeHelp #FreelancerForHire #WebDev
Yes. That is the DMV I was using. If I can consistently cause spills, I expect to see the write values on data files change. If that's the cause of the latency, I can probably use xEvents to find when the spills are happening. #sqlhelp
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
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
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
SQL Functions goo.gl/iiLe7V #SQL #sqlhelp #Database #PHP #javascript #Java #webdev #appdev #AppDevelopment #tech #softwaredevelopment #SoftwareEngineering #mysql #Backend
anyone in @AzureDataStudio land or #sqlhelp land know where to find a missing provided jupyter book? it's linked to by several other provided books but it doesn't appear to exist on my system
I exported ssis packages to .ispac file. When I import that in VS 2019, it goes into Misc. folder and doesn't show packages but like the attached image. #sqlhelp #ssishelp what am I doing wrong?
Trying to dynamically create tables using parameters in a way that prevents SQL injection, can't find an answer #sqlhelp
All About SQL: Structured Query Language myfrugalbusiness.com/2019/06/sql-st… #SQL #SQLServer #SQLHelp #Databases
Strange finding on a SQL Server running on vmware. Server is configured as 4 sockets, 10 cores each. SQL Server Properties > Processors shows all 40 cores, but 8 each on Node 0, 2, 4, 6 and 2 cores each for Node 1, 3, 5. What gives? #sqlhelp #sqlfamily @sqL_handLe
I don’t understand the max grant percent query hint. Every website reference regurgitates the docs without any real value. The docs say if the max is less than a query needs, the full query memory is granted (so it does nothing). Then what does it do?! #sqlhelp
SQL BETWEEN Operator goo.gl/P9aVl4 #SQL #SQLServer #sqlhelp #webdev #DevOps #tech #Programming #coding #Java #javascript #Database #softwaredevelopment #webdev #appdev #appdevelopment #MySQL
Day 35 Continuing an SQL course on Udemy. I'll just leave a cheat sheet here. #100DaysOfCode #sqlhelp
Daily Tutorial: Easy Way to Understand Inner vs Outer Joins in SQL #SQL #sqlhelp youtu.be/FPqXPkQkMP0
SQL For Data Science With Google Big Query #DeepLearning #DataScience #sqlhelp #Analytics couponed12.com/2020/10/sql-fo…
SQL Gurus - help required please! Two big tables (SQL 2012 SP4 Ent), matching indexes. Join the two and SQL refuses to use merge join without a sort?! What am I missing people? #SQLHelp #CallingSQLGeniuses #AmIBeingStupidHere?
I have a SQL instance that connects using domain admin details successfully whilst on the server itself. When I try connecting from my locally installed SSMS with the same admin credentials I get this error. Anyone know my probably obvious mistake?! #sqlhelp
Something went wrong.
Something went wrong.
United States Trends
- 1. Branch 37.7K posts
- 2. Chiefs 112K posts
- 3. Red Cross 56.1K posts
- 4. #njkopw 9,434 posts
- 5. Lions 90K posts
- 6. Exceeded 5,885 posts
- 7. Binance DEX 5,174 posts
- 8. Rod Wave 1,707 posts
- 9. Mahomes 34.9K posts
- 10. Air Force One 58.8K posts
- 11. Eitan Mor 18.4K posts
- 12. #LaGranjaVIP 84K posts
- 13. #LoveCabin 1,399 posts
- 14. Ziv Berman 21.5K posts
- 15. #TNABoundForGlory 60.3K posts
- 16. Knesset 16.1K posts
- 17. Alon Ohel 18.9K posts
- 18. Tel Aviv 61.1K posts
- 19. Matan Angrest 17K posts
- 20. Omri Miran 16.9K posts