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.
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.
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.
VoltDB
JANUARY 12, 2018
So, in the spirit of things, we’ve laid out a few New Year’s resolutions that all database professionals can take into account as they look to turn over a new leaf in 2018 and build on their successes. The post Database Resolutions for 2018 appeared first on VoltDB. Create Better, Real-Time Customer Experiences.
VoltDB
JANUARY 12, 2018
So, in the spirit of things, we’ve laid out a few New Year’s resolutions that all database professionals can take into account as they look to turn over a new leaf in 2018 and build on their successes. The post Database Resolutions for 2018 appeared first on VoltDB. Create Better, Real-Time Customer Experiences.
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