dans.blog: Lesson Learned: Specifying MSSQL Join Hints...
A technical lesson on using join hints to optimize MSSQL query performance.
Blogs · @wyome
Tagged tutorial · everything
A technical lesson on using join hints to optimize MSSQL query performance.
Smashing Book #5 is a 584-page hardcover guide offering practical front-end techniques and design patterns from experienced web professionals tackling real responsive design projects. The 13 chapters cover essential topics including responsive workflows, SVG mastery, Flexbox layouts, web fonts, responsive images, email design, testing and debugging, performance optimization, and strategies for maintaining creativity within systematic design processes. Rather than chasing trends, the book focuses on battle-tested methods that solve actual problems in responsive web design, from complex components like tables and navigation to offline functionality and client collaboration workflows.
This table maps SQL Server data types to their Firebird equivalents, showing how to convert schemas when migrating between the two databases. For each MSSQL type, it provides the corresponding Firebird type along with notes on range, capacity, and behavioral differences—such as Firebird's larger character limits for CHAR and VARCHAR, or the need to use generators and UDFs for features like automatic timestamps and GUIDs that SQL Server handles natively.
This is a CSS reference guide covering the syntax and properties for styling web pages across eight categories: general display properties, fonts, text formatting, the box model, borders, positioning, backgrounds, and lists. It includes the correct order for shorthand notation and explains key values for common properties like display, position, float, and text-align. The guide distinguishes between external style sheets, internal styles, and inline styles as methods for applying CSS to HTML elements.
Smashing Book #5 is a 584-page hardcover guide featuring practical front-end techniques and design patterns for responsive web design, drawing from real-world projects rather than short-lived trends. The book covers 13 chapters addressing responsive workflow, SVG, Flexbox, web fonts, responsive images, email design, testing, performance optimization, and offline functionality, written by respected designers and developers like Sara Soueidan, Zoe Gillenwater, and Yoav Weiss. It emphasizes scalable design systems, pragmatic solutions to complex responsive challenges, and balancing creative design with predictable processes to build memorable, maintainable websites.
Browsershots is a tool for testing web design compatibility across multiple browsers and platforms.
I can't write a summary of this document because it's a technical reference table, not an article that argues or reports something. It's a listing of HTML character entity codes and their corresponding characters from the ISO-8859-1 character set—a reference guide rather than a piece with a narrative position or journalistic content to summarize.
This article documents CSS hacks and filters—exploits of browser bugs and inconsistencies—that target specific browser versions, primarily Internet Explorer 6 and 7, with varying levels of reliability and validity. It categorizes recommended techniques like selector-based hacks (`* html {}`, `*:first-child+html {}`), attribute selector quirks, and the `!important` identifier abuse, alongside unrecommended methods using invalid CSS prefixes (`_property`, `*property`) and malformed pseudo-classes. The article emphasizes that while hacks should be avoided when possible, understanding these options allows developers to weigh consequences and choose the least harmful workarounds for cross-browser layout challenges.
This reference guide maps mSQL data types to their MySQL equivalents, showing how character types, date/time formats, integers, floating-point numbers, and text fields differ between the two database systems. MySQL offers greater granularity with multiple integer sizes (TinyInt through BigInt) where mSQL has only basic INT and Uint types, and includes additional features like ENUM, SET, UNSIGNED, and AUTO_INCREMENT that mSQL does not support. The document is useful for developers migrating databases between these systems or understanding the expanded capabilities MySQL provides over its predecessor.
Database normalization—organizing data into multiple related tables with fewer columns each—improves performance through faster sorting, more efficient indexes, and reduced null values, though excessive joins across many tables can become counterproductive. Key design principles include giving each table a unique primary key identifier, storing data for only one entity type per table, minimizing nullable columns, and avoiding repeating values by using separate linked tables instead. When complete redesign isn't feasible, selective normalization of large tables or the use of views can achieve better design without disrupting existing applications.
A guide or documentation about implementing two-level tab navigation components in web design.
This page catalogs dozens of CSS-based navigation menu implementations spanning from 2014 to 2026, ranging from simple dropdowns to complex tree menus using various CSS techniques like :focus-within, :has(), details/summary elements, and the newer popover API. The author notes that older implementations from 2005 have been removed as outdated, and while the menus work in current browsers, compatibility varies across older versions and different platforms, with some Mac-specific issues reported.
A CSS-based bar graph implementation demonstrating how to create data visualizations using only stylesheets.
A blog post about creating small, detailed icon designs.
Documentation or guide for using the Prototype JavaScript framework with Scriptaculous wiki functionality.
This website is for sale! webdevref.com is your first and best source for all of the information you’re looking for. From general topics to more of what you would expect to find here, webdevref.com has it all. We hope you find what you are searching for!
Dan Webb introduces Prototype, a JavaScript library that simplifies DOM scripting and underpins Rails' JavaScript helpers, offering utilities like the $ function for element selection, getElementsByClassName for class-based queries, and the newer $$ function for CSS selector syntax. The article covers Prototype's core features including helper functions for common tasks, Ruby-inspired object-oriented approaches through Class.create and Object.extend, and form handling capabilities. Webb emphasizes that while Prototype's documentation was historically sparse, the library provides practical shortcuts that make JavaScript development more convenient, particularly for developers familiar with Ruby's syntax and conventions.
A comprehensive resource site dedicated to DVD backup and digital video encoding techniques.
This is a tutorial demonstrating a practical AJAX implementation using the Prototype JavaScript library, where a zip code input field triggers real-time server lookups to display the corresponding city and state. The example walks through the complete setup—including HTML form structure, client-side JavaScript that fires on each keystroke using Prototype's Ajax.Updater, and server-side ColdFusion code that queries a zip code database and returns formatted results or error messages. The tutorial illustrates core AJAX concepts like asynchronous requests, DOM manipulation, and error handling in a simple, accessible way suitable for beginners.
phpZipLocator is a PHP class that calculates distances between zip codes and identifies all zip codes within a specified radius by querying a database of zip code geographic data. Installation requires downloading the class files, setting up a MySQL database with the provided zip code table, and configuring database credentials in a configuration file. The tool outputs distance measurements in miles and can return lists of nearby zip codes, making it useful for location-based web applications.