Free SQL Training In Sacramento

In a few short days the newest SQL Saturday event.  This one will be on the far West coast of...

Editorial: Cloud Skills

Cloud Skills is the editorial today, thinking about the changes we see in the boxed product versus the cloud and...

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

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

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 query as well for file location...

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