Question of the Day

Log in to test your SQL Server knowledge with daily questions.


What about orphaned windows users?


I should start off by mentioning that this post is applicable to sql server...

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...

Read the latest Blogs


tuning sql statement which ran for an hour

By vsamantha35

Hi All, Trying to delete rows from a table. it took 1 hour. It...

Frequent disconnectity from Application

By pols

Hi , We have two app servers Aap3 & Aap4.(Microsoft Dynamics app). The Database...

How can I change the credit card numbers during the INSERT ? (e.g.I want all 0s)

By Gamleur84

Hi, I have an application pushing data from source SQL database to an external...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers