Tip: Concatenate rows with XML, or COALESCE
Edit: I went and changed the first query without paying close enough attention. I’ve fixed the explanation and the query....
2014-10-08
846 reads
Learning About Journalism
One of my current projects is PASSWatch. Right now it’s mostly aggregation which I think has value, but I hope...
2014-10-08
887 reads
Slides and Code for SSIG Talk
Thank you for those who made it out to the SQL Server Innovators Guild last night in Greenville, SC. I...
2014-10-08
609 reads
Notes on SQLSaturday Admin Tools
Introduction
One of the items I’ve had on my todo list for a while is to write up notes on the...
2014-10-08
751 reads
October 2014 Las Vegas UG Meeting
The Las Vegas User Group is happy to announce our monthly meeting. The meeting is available for in person and webinar style. The start time is 6:30 PM Pacific...
2014-10-08
8 reads
October 2014 Las Vegas UG Meeting
The Las Vegas User Group is happy to announce our monthly meeting. The meeting is available for in person and...
2014-10-08
635 reads
Required reading before upgrading SQL Server.
I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q...
2014-10-08
1,302 reads
Fill Factor vs Page Splits – Measure It..!!
I have been trying to solve the puzzle of “How to evaluate my current Fill Factor setting?”, and there have...
2014-10-08
1,349 reads
Invite for #TSQL2sday #59 – My Hero!
It is T-SQL Tuesday again, for the 59th month in a row. Next month marks FIVE YEARS of T-SQL Tuesday,...
2014-10-13 (first published: 2014-10-08)
5,219 reads
Non-obvious APS/PDW benefits
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has a lot of obvious...
2014-10-07
1,078 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers