Coffee and SQL

Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index...

2013-07-10

820 reads

Unlocking “Lock Pages in Memory” Option

Consider this scenario; Your production database server is new and with super configuration of 32 CPUs, 64G RAM, SAN Storage,...

2013-07-08

331 reads

It’s Sunday night now, weekend is almost over and was it just a few moments ago that it was Friday?...

2013-07-07

323 reads

I was reminded this week that I needed to get registered for the Data...

Today’s coping tip is to choose to see your mistakes as steps to help...

Good day reader. This post is coming to you from a busy week in...

We have change tracking enabled on one of our databases and I am looking...

I have two databases on the same server. I have a service account I...

Hi, I'm trying to run the below SQL code but I'm getting this error:...