Project Moriarty

This past weekend I started writing notes for what I’m calling Project Moriarty, what I hope will be five questions...

SQL Server Quickie #15 – Merge Join Operator

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...

How to change TempDB system Database files location?

Steps to change TempDB system Database files location :-
1) Check current file location of TempDB
Exec SP_helpDB TempDB

You can use below...

Tableau Dashboard Cookbook by Jen Stirrup

DISCLAIMER
I received this book through the O’Reilly blogger review program, which I already mentioned in the review of Thinking With...

[BP017] DELETE statement without WHERE clause

Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d innerjoin #ids i...

Collaborated Training: What Legacy Will You Leave?

My very first IT job was a bit daunting for me. I really wanted to do my best but I...

Clustered Columnstore Indexes – part 33 (“Tuple Mover that closes open Delta-Stores”)

Continuation from the previous 32 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
We all love and use Columnstore Segments, but we all kind of...

Reblog: June 27 to July 3

Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...

Happy Independence Day America and 10 Years Packt Publishing!

 
 
If you are in the USA, I hope you take some time today to enjoy your family and friends and...

Friday Followup For July 4, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...