Why is my SQL Server using all of the RAM on the server?
The TL;DR on this is simple:
"BECAUSE IT'S SUPPOSED TO!"
A frequent complaint we receive comes from a client that has an...
2016-01-14 (first published: 2016-01-08)
7,742 reads
Blog Posts
Alter Event Session
Ready for a change of pace? Good! Today is a really good time to start looking into one of the...
2016-01-13 (first published: 2016-01-08)
2,523 reads
Learning R: Hitting the Books
I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several...
2016-01-13
592 reads
Parallelism setting in SQL Server – reduce CXPACKET waits?
This is one of the hot topic within the DBA community, what should be the best setting for parallelism in your environment? The answer is – it depends! J
Let’s...
2016-01-13
84 reads
Trace Flag 3226 - Suppress all successful backups in SQL server error log
SQL server error log contain all information about how a SQL server is running, what is happening and occurring for...
2016-01-13 (first published: 2016-01-08)
22,384 reads
T-SQL Code Coverage in SSDT using the SSDT Dev Pack
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that...
2016-01-13
71 reads
T-SQL Code Coverage in SSDT using the SSDT Dev Pack
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that...
2016-01-13
56 reads
T-SQL Code Coverage in SSDT using the SSDT Dev Pack
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that you have tested the whole thing? Code coverage gives...
2016-01-13
15 reads
Verifying Instant File Initialization
Verifying Instant File Initialization
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization...
2016-01-13
256 reads
Verifying Instant File Initialization
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but...
2016-01-13
325 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers