Gianluca Sartori

Gianluca Sartori is an independent SQL Server consultant and a performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. Currently he is working as Senior DBA for a famous Italian Formula1 team. Besides consulting projects, he works as a SQL Server trainer and in his spare time he contributes to the SQL Server forums. He is also a speaker at several conferences in Italy and in Europe.

Twitter: @spaghettidba
Website: https://spaghettidba.com

All authors

TempDB usage per active session

by Gianluca Sartori

SQLServerCentral.com

tempdb

Lists the TempDB usage per each active session.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(14)

You rated this post out of 5. Change rating

2014-09-25 (first published: 2010-12-23)

26,062 reads

Discuss

Database Free Space Monitoring – The right way

by Gianluca Sartori

SpaghettiDBA

Lately I spent some time evaluating some monitoring tools for SQL Server and one thing that struck me very negatively...

2014-09-05

458 reads

Announcing ExtendedTSQLCollector

by Gianluca Sartori

SpaghettiDBA

I haven’t been blogging much lately, actually I haven’t been blogging at all in the last 4 months. The reason...

2014-07-22

625 reads

Hangout #18 with Boris Hristov

by Gianluca Sartori

SpaghettiDBA

Yesterday evening I had the honour and pleasure of recording one of his famous SQL Hangout with my friend Boris Hristov (b|t).
We...

2014-04-18

257 reads

Uniquifiers: all rows or the duplicate keys only?

by Gianluca Sartori

SpaghettiDBA

Some days ago I was talking with my friend Davide Mauri about the uniquifier that SQL Server adds to clustered...

2014-03-14

899 reads

Verdasys Digital Guardian and SQL Server

by Gianluca Sartori

SpaghettiDBA

I’m writing this post as a reminder for myself and possibly to help out the poor souls that may suffer...

2014-02-03

1,043 reads

Non-unique indexes that COULD be unique

by Gianluca Sartori

SpaghettiDBA

In my last post I showed a query to identify non-unique indexes that should be unique.
You maybe have some other...

2014-01-30

1,003 reads

Understanding T-SQL Expression Short-Circuiting

by Gianluca Sartori

SQLServerCentral.com

T-SQL

Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(154)

You rated this post out of 5. Change rating

2013-06-21 (first published: 2010-12-30)

33,816 reads

Discuss

Dealing with custom date formats in T-SQL

by Gianluca Sartori

SQLServerCentral.com

T-SQL

Should I be formatting dates on the database side? What tools can I use in SQL Server to format and parse dates? This article helps you decide which one best suits your needs.