Space issues with SSIS temp files
The page came at a reasonable hour. All of the overnight ETL and processing jobs were just winding up before...
2015-01-21 (first published: 2015-01-15)
9,377 reads
Blog Posts
Statistics Parsing
Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when...
2015-01-21
209 reads
The Data Loading Performance Presentation
This Monday, at SQLSaturday Israel, I presented my new session, “The Data Loading Performance Presentation”.
I worked on the session a...
2015-01-21
558 reads
Your tech lab just changed forever
The VMware Users Group VMUG just announced a partnership with VMware, called the EVALExperience, to offer VMware technology pre-production 365-day licenses...
2015-01-21
553 reads
A Reason To Smile! - Deep Dives II
Over this past weekend, SQL MVP Kalen Delaney sent an inspiring note to the MVP email thread, and I wanted to...
2015-01-20
1,962 reads
Collation Conflicts
I have recently seen some “bad plans” being generated by the optimiser and from investigation, the cause came down to...
2015-01-20
1,715 reads
Common Table Expressions Are Not Tables
There’s power in naming things. Supposedly some types of magic are even based on knowing the correct names for things....
2015-01-20 (first published: 2015-01-14)
8,480 reads
It’s a Problem When a SysAdmin Can’t Log In
I showcased a demo recently that looked at a potential issue with an application where a user used a simple...
2015-01-20 (first published: 2015-01-12)
6,540 reads
Outlier Detection with SQL Server, part 3.3: The Limitations of the Tietjen-Moore Test
By Steve Bolton
…………The Tietjen-Moore test may have the coolest-soundest name of any of the outlier detection methods I’ll be surveying...
2015-01-20
1,281 reads
SQL Script to find the databases size
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used...
2015-01-20
598 reads
Blogs
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers