#SQLHelp Etiketinde En Popüler Paylaşımlar
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.
Sotwe'de En Son Görülen Etiketler
なぎメール
Son görüldüğü yer United States
tnmbc
Son görüldüğü yer United States
nolimits #teenagers
Son görüldüğü yer Australia
MaleHot
Son görüldüğü yer United States
站街
Son görüldüğü yer United States
omegle
Son görüldüğü yer Austria
GinAndEarholeMagic
xlii or #exny or #nolimit() #momson() +filter:native_video
Son görüldüğü yer Singapore
尾っ慧な人RT
Son görüldüğü yer United States
SelfSuck
Son görüldüğü yer Turkey
Senin İçin Trendler
En Popüler Kullanıcılar
Elon Musk 
@elonmusk
240.7M takipçi
Barack Obama
@barackobama
119.2M takipçi
Donald J. Trump
@realdonaldtrump
111.7M takipçi
Cristiano Ronaldo
@cristiano
110.7M takipçi
Narendra Modi
@narendramodi
107M takipçi
Rihanna
@rihanna
97.7M takipçi
NASA
@nasa
92.2M takipçi
Justin Bieber
@justinbieber
90.9M takipçi
KATY PERRY
@katyperry
87.7M takipçi
Taylor Swift
@taylorswift13
81.6M takipçi
Lady Gaga
@ladygaga
73.1M takipçi
Virat Kohli
@imvkohli
70M takipçi
Kim Kardashian
@kimkardashian
69.8M takipçi
YouTube
@youtube
68.7M takipçi
Bill Gates
@billgates
63.9M takipçi
Neymar Jr
@neymarjr
62.8M takipçi
The Ellen Show
@theellenshow
62.4M takipçi
CNN
@cnn
61.9M takipçi
X
@x
60.8M takipçi
Selena Gomez
@selenagomez
60.8M takipçi