Microsoft SQL Server is able to create very efficient query plans in most cases. However, there are certain query patterns that can cause problems for the query optimizer; this article describes four of these patterns.
The cloud changes the way that we can administer and deploy changes to our systems. Steve Jones highlights an interesting idea, and hopes we get similar techniques applied to databases in the cloud.
A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.
The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and attributes within XML have been so foreign to the SQL language as to be somewhat of a barrier to their use. Fortunately, Robert Sheldon has once more managed to make the subject accessible to those of us who just need to get the job done.
Learn how to get setup with PowerShell and SQLPSX from MVP Aaron Nelson, one of the experts teaching us how to use Powershell for SQL Server.
A reflective editorial on how SharePoints and other collaborative work spaces are getting used.
The SQL Server Luxembourg User Group will be holding its first major event of 2012 on Tuesday 17th January, starting at 4:30pm. The venue will be Microsoft's offices at Cloche d'Or.
In which Phil Factor argues that Domain Constraints are a fundamental part of the relational database. If he had to sacrifice a feature of relational databases, it wouldn’t be domain constraints.
Is there an easy/automated way to get information on SQL Server Agent jobs instead of connecting to each server and manually getting the information through the SSMS GUI?
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:08218200205 Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia Garden No.001...
WhatsApp:08218200205 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers