Editorials

Blogs

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

By

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

Understanding Columnstore Indexes in SQL Server Part 1

By

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

Basic User Functions in R

By

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

Read the latest Blogs

Forums

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

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers