July Blog Post Wrap-up
SSRS Editor Tip of the Day… CTRL + Arrows Wed, 28 Jul 2021 I learned this from one of my co-workers. A quick tip for… Read More »July Blog Post Wrap-up
SSRS
SSRS Editor Tip of the Day… CTRL + Arrows
I learned this from one of my co-workers. A quick tip for formatting SSRS reports. When you are in the SSRS report editor, and you… Read More »SSRS Editor Tip of the Day… CTRL + Arrows
Using your own RDL as a SSRS Template
This is very useful if you are creating many reports based on a single template. To start with when you use the “Add new Item”… Read More »Using your own RDL as a SSRS Template
This weeks podcast featuring Jessica Moss
This weeks SQL Data Partners podcast, Episode 55, is on (SSRS) Reporting Services Changes in SQL 2016. This episode features Jessica Moss, and the discussion is… Read More »This weeks podcast featuring Jessica Moss
Database Health Monitor – July 2016 Release
I have just released version 2.4.3 the July 2016 version of Database Health Monitor. You can download it now at the Database Health Monitor website.… Read More »Database Health Monitor – July 2016 Release
Database Health Monitor Version 2.4.2 Released Today
Today I released the latest update to Database Health Monitor. Version 2.4.2. It has been about a two weeks since version 2.4.1 release and version 2.4.2… Read More »Database Health Monitor Version 2.4.2 Released Today
CTE to Split a String in a function SplitString
Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a… Read More »CTE to Split a String in a function SplitString
SSRS Report Usage Queries
This last week I had the opportunity to do some work with SSRS, determining some stats on report usage. I ended up digging up some… Read More »SSRS Report Usage Queries
Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs
Last week I had the great opportunity to speak at PASS Summit 2015. My presentation was on Common Table Expressions. Here is the sample… Read More »Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs
Max Server Memory – SQL Server
Max Server Memory Setting Explained
If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more important.
SQL Server attempts to use as much memory as possible, and when there is no more memory available, SQL Server will use much more I/O due to data and index pages having to be read from disk more often. This works great for SQL Server, but what happens is that SQL Server will take almost all the memory leaving very little for the operating system processes or other applications that are running.
The default for this setting is 2147483647 which is probably more memory that your server has, which effectively tells SQL Server to take as much memory as it wants to.