Microsoft releases SQL Server 2014 CTP2

Microsoft has released SQL Server 2014 CTP2 (download):
What’s new in SQL Server 2014 CTP2?
New Mission Critical Capabilities and Enhancements
Enhanced In-Memory...

Architecture Reasons for Putting BLOBs in the Database

I was participating in a Twitter Chat looking at what suggestions and recommendations for developer on how to make the...

MDX #32 – Vincent Rainardi’s blog

I came across Vincent Rainardi’s blog, and thought I’d share it with the readers.
Sherry Li and Tomislav’s 2012 MDX Cook...

SQL #52 – set statistics xml on

When tuning SQL queries, I find that I use the following three SET options quite often. 

set showplan_xml on
When showplan_xml...

SQL #51 – Timeout when updating a big table

A co-worker recently asked me why she would get timeout when updating a column in a big table. This column...

Memory Optimization Advisor – SQL Server 2014 CTP2

SQLServer 2014 CTP2 came with an inbuilt tool called Memory Optimization Advisor which will help you in migrating your normal...

Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance?

Earlier this month, I presented a session for Pragmatic WorksTraining on the T’s on the selecting the clustered index for a...

Webcast Follow-Up: Choosing Your Clustered Index

Earlier this month, I presented a session for Pragmatic WorksTraining on the T’s on the selecting the clustered index for a...

PASS Summit 2014-Networking Dinner & After Hours

Yes, it is early, but I’ve set up the invitation for the fifth annual Monday Night Networking Dinner at the...

Unexpected truncation in FETCH

Yes I’m talking about FETCH as in a cursor, yes everyone hates cursors. But you know cursors are like anything...