2019-11-11
759 reads
Administration
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,222 reads
2019-10-28
482 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,207 reads
2019-10-07
535 reads
2019-09-30
537 reads
2019-09-26
514 reads
2019-09-19
444 reads
2019-09-17
1,002 reads
2019-09-12
412 reads
Blogs
Getting Started with SQL Prompt 10
By Steve Jones
This week we released SQL Prompt 10, which is an exciting milestone for us....
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Learn from the Troubles of Others
Comments posted to this topic are about the item Learn from the Troubles of...
Reduce (.ndf) file size after import
When I create a data file (.ndf) and move the previous day's data from...
Ask SSC