Top Tweets for #SQLhelp
#SQLHelp @BrentO
Sorry to bother! Just implemented TDE. Another department wants a copy of their db to restore to their SQL server. If I provide backup and certificate, even if the latter exported with different password, they could theoretically restore other database backups couldn't they? So is the better way to unencrypt the DB, take backup, re-encrypt? That seems bad too! A lot of overhead, plus database unencrypted for a period of time, particularly if large. Thanks for your help!
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
Last Seen Hashtags on Sotwe
Most Popular Users
Elon Musk 
@elonmusk
240.2M followers
Barack Obama
@barackobama
119.3M followers
Donald J. Trump
@realdonaldtrump
111.6M followers
Cristiano Ronaldo
@cristiano
109.1M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
97.3M followers
NASA
@nasa
92.1M followers
Justin Bieber
@justinbieber
90.6M followers
KATY PERRY
@katyperry
86.9M followers
Taylor Swift
@taylorswift13
80.7M followers
Lady Gaga
@ladygaga
72.2M followers
Kim Kardashian
@kimkardashian
69.4M followers
Virat Kohli
@imvkohli
68.6M followers
YouTube
@youtube
68.6M followers
Bill Gates
@billgates
63.5M followers
The Ellen Show
@theellenshow
62.5M followers
CNN
@cnn
61.9M followers
Neymar Jr
@neymarjr
61.2M followers
X
@x
60.9M followers
Selena Gomez
@selenagomez
60M followers