Top Tweets for #SQLHelp
An interesting sql question:
https://t.co/hnMZkGTWRA
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
@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.
Has anyone successfully published a database project (SSDT) to the new #microsoftfabric SQL DB? #sqlhelp
Asking a
#sqlhelp
question. That's so 2014.
How do I add a trusted check constraint quickly? https://t.co/USaRGAVydq
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
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.
Last Seen Hashtags on Sotwe
ΰΈΰΈΰΈ£ΰΈ
Seen from Thailand
nolimit nolimit
Seen from Turkey
ladyboythailand
Seen from United Kingdom
μ±
μ₯μλ²μ€νΉ
Seen from United States
Teenagegirls https
Seen from Singapore
omegle
Seen from Japan
sivastravesti
Seen from Turkey
Zoophilia
Seen from United States
uang
Seen from Indonesia
Slutwife
Most Popular Users
Elon Musk 
@elonmusk
240.7M followers
Barack Obama
@barackobama
119.2M followers
Donald J. Trump
@realdonaldtrump
111.7M followers
Cristiano Ronaldo
@cristiano
110.7M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
97.7M followers
NASA
@nasa
92.2M followers
Justin Bieber
@justinbieber
90.9M followers
KATY PERRY
@katyperry
87.7M followers
Taylor Swift
@taylorswift13
81.6M followers
Lady Gaga
@ladygaga
73.1M followers
Virat Kohli
@imvkohli
70M followers
Kim Kardashian
@kimkardashian
69.8M followers
YouTube
@youtube
68.7M followers
Bill Gates
@billgates
63.9M followers
Neymar Jr
@neymarjr
62.8M followers
The Ellen Show
@theellenshow
62.4M followers
CNN
@cnn
61.9M followers
X
@x
60.8M followers
Selena Gomez
@selenagomez
60.8M followers