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. Previously I covered determinism , subqueries and joins. DROP TABLE IF EXISTS dbo. Transactions ; CREATE TABLE dbo.

Best Practices 108

Best Practices Servers Database Azure 108

Smashing Magazine

JULY 12, 2021

However, this simplicity leaves the door open for many potential issues and technical debt — bloated code, specificity hell, duplicated code blocks with very little to no difference, leftover unused selectors, unnecessary hacks, and workarounds, to name a few. Leftover, unused chunks of code from deleted features.

Best Practices 145

Best Practices Website Architecture Media 145

SQL Performance

MARCH 15, 2021

This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data. In my last post , I illustrated one reason you should stop using deprecated system tables like sysprocesses.

Servers 64

Servers Azure Best Practices Monitoring 64

Rigor

JANUARY 13, 2020

These are the bestsellers in the web performance field, including the good old Speed Up Your Site (2003) by Andy King; Steve Souders’ Even Faster Web Sites (2009) ; Ilya Grigorik’s High Performance Browser Networking (2013) ; Tammy Everts’ Time is Money (2016) ; and a handful of more recent publications. Using Webpagetest.

Performance 75

Performance Social Media Website Website Performance 75

SQL Server According to Bob

JULY 13, 2016

Today we are introducing the new Basic Installer experience for SQL Server 2016 Express , SQL Server 2016 Developer , and SQL Server 2016 Evaluation Editions. We actually launched this functionality for SQL Server 2016 Express Edition when SQL Server 2016 RTM was announced but didn’t really promote this.

Servers 40

Servers Media Engineering Virtualization 40

CSS - Tricks

JANUARY 31, 2020

From 2016 (PDF warning) to 2019 , the average mobile download speed in the U.S. Code splitting works. This is the time at which you develop and roll out training, documentation, best practices, and standards the organization can embrace. has increased by 73%. Content compression works. Minification works.

Innovation 50

Innovation Mobile Best Practices Speed 50

CSS - Tricks

APRIL 1, 2021

The code for the site is available on GitHub for reference. It’s is a Google service that audit things performance, accessibility, SEO, and best practices. Feel free to make your own judgement call here as the best route is going to depend on the use case. Many of you may already be super familiar with it.

Cache 92

Cache Social Media Media Network 92