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
7,873 reads
Use this script to calculate MAX memory setting on a dedicated SQL server.
2012-01-27 (first published: 2011-12-14)
3,302 reads
Back in December 2019, I started presenting my session on mental health with lots...
By Steve Jones
Today’s coping tip is to discover the joy in the simple things in life....
By Steve Jones
I have been experimenting a bit with graph databases, trying to learn more about...
We have a stored procedure that can load up a JSON file and process...
I have my SQL servers name, UserID (UID) and Password (PWD) in a table...
Hi All, I want to extract the string before and after the given characters....
Ask SSC