Redistributing Data Across Files
When adding files to a filegroup, SQL Server doesn't automatically balance the data across the files immediately. See how this works and how you can speed this up.
2019-11-07
3,956 reads
Administration
2019-10-28
515 reads
Fixing MLS Python Services to Load the Runtime
Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]
2019-10-24
1,381 reads
2019-10-07
564 reads
2019-09-30
557 reads
2019-09-26
546 reads
2019-09-19
459 reads
2019-09-17
1,044 reads
2019-09-12
438 reads
2019-09-09
567 reads
Blogs
Use Jupyter Notebooks to Help People on StackOverFlow
By Rob Sewell
I am sat in the PowerShell Saturday in Hamburg. You can see me on...
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Forums
Needed to find all possible Dates Overlaps from a single Table
Hi, I have the following Episode table example: Where DischDate = "2020-02-20" means - client hasn't...
Optimize Cursor
I inherited this script that has a cursor and I know this query can...
Unable to add secondary node existing node due to DCOM is unavaialble
Dear Team, This is Naveen, Hope all are doing well. I need emergency help...
Ask SSC