Common Table Expressions (CTE)
Common Table Expresseion (CTE)
A common table expression (CTE) is a derived table that is defined and only stored for the...
2014-10-08 (first published: 2014-10-03)
9,016 reads
Blog Posts
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,323 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
874 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
744 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
625 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
1 reads
Optimizing Power BI Q&A with Synonyms and Phrasing using Cloud Modeling
If you’ve have used or even just seen a demo of Power BI Q&A you’ve likely seen there’s great potential...
2014-10-08 (first published: 2014-10-01)
7,554 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,299 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
601 reads
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
836 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers