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...
2014-07-07
396 reads
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...
2014-07-07
25 reads
Project Moriarty
This past weekend I started writing notes for what I’m calling Project Moriarty, what I hope will be five questions...
2014-07-07
437 reads
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...
2014-07-07
1,091 reads
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...
2014-07-07
15,036 reads
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...
2014-07-07
1,057 reads
[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...
2014-07-07
676 reads
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...
2014-07-07
555 reads
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...
2014-07-04
147 reads
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...
2014-07-04
893 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers