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 the United States. This marks the first time for...
2014-07-07
5 reads
Blog Posts
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
14,940 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
10 reads
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
384 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
430 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,089 reads
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...
2014-07-07
2,784 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,049 reads
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...
2014-07-07
1,760 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
144 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers