Thanks Paul for your comment. It's true that only committed data is read, no doubt. My intention was only to underline that the SELECT "got only a subset of the...

• This reply was modified 3 years, 1 month ago by  Alessandro Mortola.

I agree with you Jeff and with your "ERROR in ACCURACY" definition 🙂

Hi blehnig,

thanks for your comment. Keep in mind that for DateTime data type, the third digit after the decimal point can be only: 0, 3 or 7. Every other numer is...

• This reply was modified 3 years, 1 month ago by  Alessandro Mortola.

Thanks you Jeff for your accurate post; I will keep your observations in mind and I will consider them in they more general meaning. At the moment I am going...

Very interesting! Thanks for sharing!

Very interesting sir. Thanks for sharing

Great job Erin, I'm looking forward to read next levels

Mr or Mrs. 500,

first of all thanks for your considerations.

1. You are right; I used a recursive CTE in order to keep the code related to the article more...

Regarding "Parent" and "Child" definition, you are right; though I have used these definitions because they are often used in articles, blogs and videos (regarding FKs) like the one of...

Hi, I have submitted the article a few moments ago. The tile is "Indexing Foreign Keys".

I hope it fits

Hi, I think I can go deep into this topic. Though, I need some weeks to gather examples, script and tests

Hi John,

excuse me if I have misunderstood your question.

Actually S1 is not a formula, but it is the selectivity of the first predicate and it is defined as “Number of...

Thanks Gianluca, I hope to meet you at SqlSaturday in Torino on 23th May