Why does SQL Server warn that Null value is eliminated by an aggregate or other SET operation? I show when it appears and how it can be suppressed.
SQL SERVER – The Basics of the Execute Package Task – Notes from the Field #067
SSIS expert Andy Leonard covers the basics of the Execute Package Task, how to configure it and how one SSIS package can call another.
SQL SERVER – Script to Find Leap Year
A simple T-SQL script to check whether a year is a leap year, using DATEADD and EOMONTH to find the last day of February for that year.
SQL SERVER – Error: Fix for Error Msg 3906 – Failed to update database because the database is read-only
Getting Msg 3906, Failed to update database because the database is read-only? The message says it all. Here is how to make the database writable again.
SQL SERVER – Viewing User Configurable Info in SQL Server
A reader asked about sp_user_counter1 to 10 for debugging. I show how sp_trace_generateevent raises events you can watch as User Configurable info.
Interview Question of the Week #006 – Is Shrinking Database Good or Bad?
Decide whether shrinking database good or bad advice fits your case, inspect fragmentation, and use low-priority shrink cautiously.
SQL SERVER – What are the Different Ways to Script Procedure with T-SQL
What are the different ways to script procedure code with T-SQL? There are four, including sp_helptext and INFORMATION_SCHEMA.ROUTINES. Here is each one.