Viewing 15 posts - 31 through 45 (of 1,161 total)
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...
March 19, 2023 at 6:28 pm
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...
February 26, 2023 at 6:15 am
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...
February 18, 2023 at 9:01 am
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...
February 16, 2023 at 3:27 am
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...
February 8, 2023 at 5:33 am
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...
February 8, 2023 at 5:22 am
Much appreciated , thank you for the information.
January 16, 2023 at 8:10 pm
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...
January 16, 2023 at 5:15 am
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....
January 8, 2023 at 2:26 am
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...
January 8, 2023 at 2:16 am
Jeffrey Williams wrote:It might be a better option - if using TRY/CATCH - to THROW the error instead of using RAISERROR.
I'd be interested to hear your reasoning.
This is the main...
November 17, 2022 at 8:12 am
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...
November 17, 2022 at 7:55 am
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...
November 17, 2022 at 7:36 am
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...
November 17, 2022 at 7:28 am
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...
November 17, 2022 at 7:18 am
Viewing 15 posts - 31 through 45 (of 1,161 total)