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...

Last Weeks Top “Reading” Links #91

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

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...

SSRS reports in SharePoint mode, Saga #2: PowerShell generates email subscriptions

Life is full of opportunities, it only takes to notice and use them. About 3 months ago I wrote a...

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...

T-SQL Window Functions – Part 3: Aggregate Functions

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...

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...

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...

Happy Birthday, America!

IN CONGRESS, July 4, 1776.
The unanimous Declaration of the thirteen united States of America,
When in the Course of human events,...