Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]
2020-09-01
9,190 reads
Use this script to calculate MAX memory setting on a dedicated SQL server.
2012-01-27 (first published: 2011-12-14)
3,351 reads
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Comments posted to this topic are about the item The World of Data Science
First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...
Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...
Ask SSC