---

Filter by type:

• All
• Articles
• Blog Posts
• Scripts

SQL Server Infernals – Circle 5: Inconsistent Baptists

• by Gianluca Sartori

• SpaghettiDBA

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,915 reads

SQL Server Infernals – Circle 3: Shaky Typers

• by Gianluca Sartori

• SpaghettiDBA

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,207 reads

SQL Server Infernals – Circle 4: Anarchic Designers

• by Gianluca Sartori

• SpaghettiDBA

Constraints are sometimes annoying in real life, but no society can exist without rules and regulations. The same concept is...

2015-07-07

805 reads

SQL Server Infernals – Circle 2: Generalizers

• by Gianluca Sartori

• SpaghettiDBA

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)

959 reads

SQL Server Infernals – Circle 1: Undernormalizers

• by Gianluca Sartori

• SpaghettiDBA

There’s a special place in the SQL Server Hell for those who design their schema without following the Best Practices....

2015-06-17

854 reads

Announcing SQL Server Infernals

• by Gianluca Sartori

• SpaghettiDBA

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

636 reads

Native Client Aliases don’t like Trailing Spaces

• by Gianluca Sartori

• SpaghettiDBA

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,548 reads

Counting the number of rows in a table

• by Gianluca Sartori

• SpaghettiDBA

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,139 reads

Tracking Table Usage and Identifying Unused Objects

• by Gianluca Sartori

• SpaghettiDBA

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)

12,204 reads

How to post a T-SQL question on a public forum

• by Gianluca Sartori

• SpaghettiDBA

If you want to have faster turnaround on your forum questions, you will need to provide enough information to the...

2015-04-24

2,093 reads

Filter by type:

• All
• Articles
• Blog Posts
• Scripts