2017 Best Practices Database 
SQL Performance
AUGUST 14, 2019
This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices. The focus of this month's article is bugs, pitfalls and best practices related to window functions. In my examples I'll use a sample database called TSQLV5. 2017-07-04 10248 440.00 2017-07-05 10249 1863.40
SQL Performance
SEPTEMBER 12, 2019
This article is the fifth part in a series about T-SQL bugs, pitfalls and best practices. In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Previously I covered determinism , subqueries , joins and windowing.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Scalegrid
JULY 13, 2020
Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Not available.
SQL Performance
JUNE 14, 2019
This article is the third installment in a series about T-SQL bugs, pitfalls and best practices. Some of the bugs and best practices that I cover here are a result of a survey I did among fellow MVPs. In my examples I’ll use a sample database called TSQLV5. Previously I covered determinism and subqueries.
Percona
SEPTEMBER 1, 2023
This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Database architects working with MongoDB encounter specific challenges related to database systems and system growth.
SQL Performance
DECEMBER 11, 2019
Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.
MachMetrics
DECEMBER 14, 2019
In 2017, mobile internet usage passed desktop as the majority. Google’s best practice is to have a speed index under 3 seconds. Google’s best practice is to be below 0.5 However, Google’s best practice is to keep the number of requests below 50, so there is still work to be done.
Expert insights. Personalized for you.
108 
Let's personalize your content