Using SELECT INTO with UNION Statements

On occassion, I need to take a number of different result sets and combine them into a single output, which...

Availability Group DMVs Reporting Incorrect Values

In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism for AlwaysOn Availability Groups. Check out the many new...

Different ways to find Data, log and DB Size

Different ways to get the size of the data , log files and Databases
Using CountersQuerying sysaltfiles & sys.databasesQuerying sys.master_files 
SELECT instance_name AS DatabaseName,
[Data...

Extraordinary #1

I’ve seen tables that are referenced by many other tables in MSSQL databases and that number was usually being around...

January MVP – Mike Fal

In case you missed it, back in November I blogged about the importance of nominating individuals within the SQL Server...

Now exactly which proposal is this

Introduction

Oft times we are forced into situations where we clearly need to think outside of the box. A case at...

PASS Cloud Virtual Chapter – Call for Presenters

The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...

SQL Server Backups Are A Business Decision

Blog post #3 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
Read more about Tim’s challenge here.
It’s very easy to think of...

Too many Foreign Keys

I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...

Too many Foreign Keys

I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....