SQL Server Infernals – Circle 5: Inconsistent Baptists
There’s a place in the SQL Server hell where you can find poor souls wandering the paths of their circle,...
2015-07-23 (first published: 2015-07-17)
2,934 reads
Gianluca Sartori
- Twitter: @spaghettidba
- Website: https://spaghettidba.com
SQL Server Infernals – Circle 3: Shaky Typers
Choosing the right data type for your columns is first of all a design decision that has tremendous impact on...
2015-07-10 (first published: 2015-07-02)
2,226 reads
SQL Server Infernals – Circle 4: Anarchic Designers
Constraints are sometimes annoying in real life, but no society can exist without rules and regulations. The same concept is...
2015-07-07
818 reads
SQL Server Infernals – Circle 2: Generalizers
Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies...
2015-06-29 (first published: 2015-06-24)
977 reads
SQL Server Infernals – Circle 1: Undernormalizers
There’s a special place in the SQL Server Hell for those who design their schema without following the Best Practices....
2015-06-17
868 reads
Announcing SQL Server Infernals
Today I’m starting a new blog series called “SQL Server Infernals”.
Throughout this series, I will take your hand and walk...
2015-06-09
670 reads
Native Client Aliases don’t like Trailing Spaces
I usually don’t post small things like this, but today I fought with this obnoxious problem long enough to convince me that...
2015-06-02 (first published: 2015-05-26)
1,559 reads
Counting the number of rows in a table
Don’t be fooled by the title of this post: while counting the number of rows in a table is a...
2015-05-25 (first published: 2015-05-18)
9,257 reads
Tracking Table Usage and Identifying Unused Objects
One of the things I hate the most about “old” databases is the fact that unused tables are kept forever,...
2015-04-29 (first published: 2015-04-20)
16,396 reads
How to post a T-SQL question on a public forum
If you want to have faster turnaround on your forum questions, you will need to provide enough information to the...
2015-04-24
2,281 reads
Blogs
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...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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