Default Value
37 Stories
Make Windows XP file system run faster
Insight Want to squeeze the last ounce of performance out of your Windows XP workstation? Try tweaking NTFS.
Tutorial: Enforce data integrity with constraints and Enterprise Manager
Insight Data integrity is essential to the effectiveness of a Microsoft SQL Server database. Enforcing data integrity is achieved with data constraints, which can be implemented through the Enterprise Manager client.
Constrain your SQL Server data with T-SQL
Insight The SQL Server version of SQL, T-SQL, provides ample commands to create all the constraints necessary in a database application. This article examines the syntax of using these commands.
Two ways to return a unique list in Excel
Techguide Filtering data to produce a unique list of entries is a common task in Excel. Here are two methods of getting the job done: manually and with a bit of VBA automation.
Tags: Microsoft Office, Microsoft Corp., Data, List, Cell, Database, AdvancedFilter Method, Default Value, Mouse, Microsoft VBA
Configure the screen saver timeout in Windows Server 2008 Core Edition
Techguide Managing the display settings in the Core Edition is a little less intuitive than its full install counterparts. Here's how to set the screen saver timeout in the registry.
Tags: Microsoft Windows, Server platforms, Value, Registry, Password, Ohio, Windows registry, group policy object, Rick Vanover, Microsoft Windows Server 2008
Move files faster in Windows 2000
Insight tutorial To speed up file copying and moving in Windows 2000 Pro, you can add commands to the context menu. This tip shows you how.
Tags: Software, Windows 2000
Vertically center graphics and text on one page
Techguide You don't need to hit the [Enter] key over and over again to get the body of your Word document to line up--have Word do it for you. Mary Ann Richardson brings the tip front and center.
Copy folders and files with Windows 2000 Pro's context menu
Techguide If you regularly move and copy folders or files to a specific folder and want to be able to do so through the item's context menu, you can add commands to the context menu for that purpose.
Style table borders with CSS
Techguide Web developer Tony Patton examines how to use CSS to style the borders of HTML tables. He also offers examples that show how the CSS border property can specify the size of the border along with its color and type.
Find sequence gaps using Oracle's analytic functions
Techguide Oracle's analytic functions provide a clean way to do gap checking. These functions allow you to see the value in an upcoming row or previous row, while still using the full set-oriented processing of SQL.
Tags: Databases, Database management
Find sequence gaps using Oracle's analytic functions
Techguide Oracle's analytic functions provide a clean way to do gap checking. These functions allow you to see the value in an upcoming row or previous row, while still using the full set-oriented processing of SQL.
Find sequence runs using Oracle's analytic functions
Techguide Bob Watkins addresses the issue of detecting sequence runs within a group of rows, and provides a sample script that selects the first and last value in each run.
Use Word to create an organizational chart in minutes
Techguide You don't need special software or advanced design abilities to create an organizational chart. Here's how.
Create an XML-based shopping cart in PHP
Techguide Shopping cart applications are usually pretty straightforward. When a user adds an item to the shopping cart, you store the item's unique identifier plus the quantity for that particular item with a default value of one item.
Use sitemap standards to help search engines
Techguide Sitemaps provide a way for Web sites to specify what pages within the site should be indexed and what new content has been added. Tony Patton offers an overview of the sitemap standard.
Tags: Search
