Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:

...

• This reply was modified 2 years, 9 months ago by MMartin1.

Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:

• <b>....</b>
• ...

...

My thoughts on this are that this article is quite shallow and lacks breadth.

1. Indexes -- Yes they can always create the potential to speed things up but will slow...

Thank you for breaking things down so well. This is well put. I do recall coming across the ability to email HTML reports from the SQL Server agent in the...

The verical resutls feature is a nice one to have. Though I have seen this in powershell with the invoke sql command(let).  Powershell seemingly decides for you to present in...

I have a feeling people want to test with real data because I suspect the database is not in a normalized state. That is, there is probably a repeat of...

This is not much to go on as the schema of your tables is unknown. I suspect you would benefit from a classic Calendar table which comes with columns for...

If you have Query Store turned on maybe this is what you are looking for?

SELECT distinct top 10 
    qt.query_sql_text
    ,...

For any data you had to delete, anything with personally identifiable information, there are a couple of tools that can generate data for you to use in testing and development.

I've...

Msg 15274, Level 16, State 1, Line 6 Access to the remote server is denied because the current security context is not trusted.

I am getting the same error for...

Good article,  and it does brign up the question of why a database is in full recovery model with no backups being made to keep the log file contained.

This process...

At a high level , reagardless of database platform, a view is simply a stored SQL statement. The statement is encapsulated with a label (what you refer to as the...

I am not sure if it is worth mentioning but the Average function is a Mean average. In certain situations you may want to find a median average, for which...

In Redshift, which is a cousin of PostgreSQL, you can have both a "temporary" table and a "#" table as in Sql Server. Both are temporary tables. Is this the...

I appreciate you taking the time to provide examples to explain triggers.

You did mention "Try to avoid time-consuming operations in the trigger" yet you make use of creating temporary tables...