SQL Azure requires a clustered index on every table. This article provides a query to identify tables missing one.
Explains how using setTimeout with a 0ms delay can speed up window.onload by preventing JavaScript from blocking the event.
Advocates for a user-centric approach in tech projects, prioritizing user needs over company goals for better outcomes.
Developer details converting the startup-notification library to use XCB instead of Xlib, including benchmarks showing performance gains.
Argues that PyPy, a Python interpreter written in Python, will replace CPython due to superior speed, flexibility, and being a better platform for growth.
A developer's experience using Opera browser with Oracle Enterprise Manager, highlighting its speed and tab management benefits.
Explores the size threshold for using inline scripts/styles vs. external files, considering HTTP overhead, caching, and performance trade-offs.
A presentation overview on writing efficient, high-quality JavaScript code, aimed at developers with a Python background.
Explores whether programming languages inherently have performance characteristics by comparing Python and C implementations.
Analyzes the performance difference between JavaScript's strict (===) and loose (==) equality operators, finding minimal practical impact.
Explores the evolving role of the 'DevBA'—a database developer who incorporates DBA skills like performance tuning and using DMVs to build better systems.
Explores the minimum delay for JavaScript timers like setTimeout, revealing browser-specific limits and implications for accurate timing.
Announcement and preview of SQLBits VI, a free SQL Server conference in London focused on performance and scalability.
Explains how to optimize SQL query performance by avoiding functions in WHERE clauses, using date filtering as a key example.
Performance comparison of three methods for sorting in-memory DataTables in C#/.NET, with LINQ to DataSet emerging as the fastest.
A developer shares their anticipation and planned schedule for the QCon London 2010 conference, focusing on architecture, .NET, and scalability.
Explains the importance of clearing SQL Server's data and execution plan caches for fair query performance comparisons during tuning.
Explores solving the running median problem in Python, comparing clever, educational, and research approaches, and presents an indexable skiplist solution.
Analysis of Facebook's HipHop PHP compiler, discussing its design, performance goals, and limitations compared to dynamic language implementations.
A technique to preload JS and CSS files as print stylesheets to improve page load times, with a warning about Chrome compatibility issues.
