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

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Hi there I have a problem with a dynamicSQL Statement. In this code, I...

Hi, is there are way using sql that brings a list of the ssis...

We are only trying to answer the below questions regarding database connections for an...