Blog Posts

Database File Changes

Data professionals around the globe are frequently finding themselves occupied with figuring out why and when a file (data or log) for a database has changed in size. Whether...


6 reads

Joker’s Wild

This past weekend I had a blast presenting Joker’s Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter). Watch it here! Table of contents: What is...

2019-06-25 (first published: )

358 reads

Multiple Identity Inserts

Watch this week’s video on YouTube. This week I want to share something that surprised me about using SQL Server’s SET IDENTITY_INSERT statement. I started with two tables with...


4 reads


SQL Server 2008 and 2008 R2 is end of life on 9 July 2019


Next month, Microsoft is ending five years of extended support on SQL Server 2008...

Understanding Columnstore Indexes in SQL Server Part 1


Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes...

Basic User Functions in R


As I’ve been learning more about the data platform, I’ve been exposed to some...

Read the latest Blogs


Compare Dates

By ssc_san

Hello All, create table #app1 ( custID INT, Seqs INT, eff_dt datetime, term_dt datetime...

StoredProc insert and update multiuser issue

By jason.havelock

Happy to day to all, I am looking into an issue with a stored...

New to SQL - difficulties in SUMing only certain rows of a column, other misc.

By Kai

This is for SQL Server 8.0 and I'm using MySQL Workbench on this.  ...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers