An issue that can arise with non nullable columns is that if at a later time you realise you need them to be null after all , due to some...

Thanks for sharing. If you use Ola Hallengren's scripts for Jobs related to backups and other maintenance, they do the check internally so you dont need to do this check on...

Much appreciated , thank you for the information.

Thank you for the interesting article. I saw the SQL patterns sought had to do mainly with formatting. Woud any of this cause an issue with a git commit ?

Would...

I always had suspicion on the  covid statistics provided by China these last few years. Even if the hard line lockdowns were as effective as claimed, then that can mislead....

The term 'Hacker", derived from 'Hack', began at MIT in the 1950's. These students were fascinated how a change in one part of an electrical system affected another. It wasn't...

This is the main...

Lookup the MERGE command.

Functions perform operations in a row by row manner as opposed to a set at a time. This is slow and not needed.

I am not sure how...

It may fragment some indexes and not others.  You certainly don't want to automatically rebuild every index.  Also, rebuild from smallest to largest of the indexes that do need...

A very good link has been provided.

If you have your log file on its own volume another thought would be , just to put it out there, a powershell script...

Few best practices to optimize SQL DB performance

- Reduce Table Size - Simplify Joins - Use SELECT Fields FROM Instead of SELECT * FROM - Use EXISTS() Instead of...

Since you are on 2017 pressumably , navigate to your database (in explorer) and drill down to the Query Store. There you will find the most expensive queries by cpu...

I cant even make sense of what the data is supposed to render to. I cant make out any columns in the desired output. Please put in time to present...

Please create a entity relationship diagram explaining what the tables are and what certain columns mean. and how they are related/joined.

Provide a simple case of input data and what the...

What section and step within the documentation are you at ? Is this transactional replication ? Is it push or pull subscription ? Where is the distributor  ?