Speaker of the Month: May 2015
When I attend sessions at events, I try to mix it up. I’ll go to a session that, really, I...
2015-06-09
526 reads
The Scary DBA
Parallelism and Columnstore Indexes
Columnstore indexes are fascinating and really cool. Unfortunately, they’re adding an interesting new wrinkle to an old problem.
What’s the Cost...
2015-06-01
814 reads
PASS Board Update: May 2015
I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international...
2015-05-27
542 reads
Database Engine Tuning Advisor
I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that...
2015-05-26
821 reads
Book Review: Connected
I heard about Connected from a show on NPR (Yes, I listen to NPR, why do people keep saying that?)....
2015-05-29 (first published: 2015-05-19)
5,090 reads
Come to Us or We’ll Come to You
No, that’s not a threat. It’s an offer to help out.
Redgate Software is very serious about the efforts we’re putting...
2015-06-01 (first published: 2015-05-18)
1,414 reads
I Am Grateful For…
I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...
2015-05-15
505 reads
Is Performance Better With LEFT JOIN or RIGHT JOIN?
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...
2015-05-20 (first published: 2015-05-11)
7,058 reads
Effects of Persisted Columns on Performance
I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those...
2015-05-13 (first published: 2015-05-05)
5,931 reads
Speaker of the Month: May 2015
I finally got out to some community events last month and got to see a bunch of great speakers. Not...
2015-05-01
508 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers