I SCHEMABOUND my scalar UDF and you won’t believe what happened next.
Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this...
2014-09-15
1,189 reads
Blog Posts
Outstanding PASS Volunteer
Hello Dear Reader! In June this year I was recognized by PASS as with an Outstanding Volunteer Award. In an...
2014-09-15
666 reads
PASS SQL Saturday Events: October 2014
DateEventOctober 4 SQLSaturday #335 – Athens 2014October 4 SQLSaturday #336 – Holland 2014October 4 SQLSaturday #344 – Tirana 2014October 4 SQLSaturday #315 – Pittsburgh...
2014-09-15
588 reads
Podcast on Devops and the Database
I’ve been attempting to expand my reach to get back to my roots in development. I’m doing this because I...
2014-09-15
694 reads
Statistics in SQL Server
I’ve put together a new Curah! of links to some of the better articles on SQL Server Statistics, specifically those...
2014-09-15 (first published: 2014-09-10)
7,399 reads
Thoughts On the NomCom Process
We’ve just wrapped up the interviews and I wanted to jot down a few thoughts on what I’ve seen from...
2014-09-15
516 reads
To be brief. What to do when PATH variable is too long to be real PATH.
Sometimes after installing pretty useful addins when starting SSMS you can see error message like "Exception has been thrown by...
2014-09-15
850 reads
Clustered Columnstore Indexes – part 41 (“Statistics”)
Continuation from the previous 40 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Note: This article is in’s 2nd version, after correcting comments done by...
2014-09-13
240 reads
Houston TechFest 2014: SQL Admin Best Practices with DMV's
Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014, thanks very much...
2014-09-13
571 reads
Friday Followup For September 12, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-09-12
571 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Forums
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers