Much Ado about nothing: missing data
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.
2021-07-09
SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains 9 best practices for performance tuning.
2021-06-16
In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.
2021-06-14
How to extend the range of SQL code analysis, during database development, to include dynamic analysis of the database metadata. This will allow regular checks for problems with the design of your tables and indexes ("table smells") that can affect database performance and data integrity.
2021-05-10
In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one.
2021-04-29
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
2021-04-22
How to create a batch file that executes any number of database migration tasks across a range of servers and databases, using Flyway.
2021-04-21
Out-of-control tempdb growth must be managed to keep the server running. Monica Rathbun gives her strategy to handle unexpected tempdb growth.
2021-04-12
RAID has been around since the 90s to ensure performance and reliability of storage. Robert Sheldon explains the history and theory behind RAID.
2021-03-11
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
We've got upwards of 40 SSIS solutions all stored in one GIT repository in...
Comments posted to this topic are about the item Improving the Performance of UPDATE...
Comments posted to this topic are about the item 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