A SQL Server Hardware Nugget A Day – Day 7
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
2011-04-11
1,791 reads
Getting More Hardware Information from SQL Server Denali DMV Queries
As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly....
2011-04-08
1,487 reads
A Small Collection of SQL Azure Queries
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-15
1,831 reads
Some Suggested SQL Server 2008 R2 Instance Configuration Settings
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
2011-03-02
2,690 reads
Is CPU-Z Risky To Run on a Production Server?
There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the...
2011-02-23
2,324 reads
New Version of CPU-Z (1.57) has Been Released
On February 18, Franck Delattre released version 1.57 of the very useful CPU-Z Utility. Here is a list of the...
2011-02-23
2,996 reads
Windows Instant File Initialization and SQL Server
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
2011-02-15
1,312 reads
February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
2011-02-10
2,126 reads
Five DMV Queries That Will Make You a Superhero in 2011!
Way back in January, 2008, I wrote a blog post called “Five DMV Queries That Will Make You A Superhero!”...
2011-02-09
4,981 reads
Microsoft Support Policies for Windows Server and SQL Server
Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack...
2011-02-04
2,138 reads
Blogs
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Forums
SSIS how to manage source control with multiple packages / projects
We've got upwards of 40 SSIS solutions all stored in one GIT repository in...
Improving the Performance of UPDATE Statements in SQL Server
Comments posted to this topic are about the item Improving the Performance of UPDATE...
Replacing a Null
Comments posted to this topic are about the item Replacing a Null
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers