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

336 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

opia – n. the ambiguous intensity of eye contact The entry for this says...

This was actually a cool tip I saw internally from one of the product...

It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...

Comments posted to this topic are about the item Serverless Gets Faster

I have a task to check the connection managers as part of ssis integration...

Hi, wondering if someone can help me. We're trying to build an application that...

I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?