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
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
Creation & Deletion of Database Snapshot by SQL Agent Job
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want...
2014-09-15
498 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
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
SQLSaturday Orlando Marketing Plan-Part 42
Reg count at 479. Looking very good for hitting 500!First sponsor sent out a geo-targeted message for us, another one...
2014-09-12
641 reads
Reblog: September 5 to September 11
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-09-12
806 reads
Professional Microsoft SQL Server 2014 Administration
Hello Dear Reader! Last September I was approached with a tremendous opportunity to become the Managing Author for the Professional...
2014-09-12
2,061 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
Schema on Read vs Schema on Write
Schema on Read vs Schema on Write in Business Intelligence
When starting build out a new BI strategy. There are more...
2014-09-12
1,212 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