Physical Database Storage
This article provides a guide for physical storage design and gives recommendations and trade-offs for physical hardware design and file architecture.
2006-06-29
3,858 reads
Additional Articles
BlackBelt Administration: Linked Reports in Report Manager
Use Linked Reports to provide multiple "versions" of a single source report, as a mechanism for restricting consumer groups to their respective data in accordance with a "need to know."
2006-06-28
2,200 reads
Creating usable applications
If I had a penny for every person who said "usability is just common sense", I'd have a pretty reasonable stack of pennies – maybe 30 or so. Clearly I'm not going to be able to retire on this, but at least it demonstrates that many people have misconceptions about how usable interfaces are designed.
2006-06-27
2,601 reads
Working with TempDB
This white paper describes how SQL Server 2005 uses tempdb. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. A case study that uses a workload similar to TPC Benchmark H (TPC-H) shows new ways to manage and troubleshoot tempdb resources. This paper also includes items to consider when upgrading to SQL Server 2005 and configuring tempdb
2006-06-26
3,001 reads
Database Geek of the Week - Glenn Johnson
The latest GotW award goes to Glenn Johnson, .NET trainer and author of Programming Microsoft ADO.NET Applications:
2006-06-23
3,168 reads
Building Database Applications with Remote Support in Mind
Although the challenges of designing and developing an embedded software package are obvious, the effort of providing remote support for the deployed application is often underestimated.
2006-06-22
2,581 reads
Web Parts in ASP.NET 2.0
Damon Armstrong demonstrates how to personalize the look-and-feel of multiple pages in your ASP.NET 2.0 applications.
2006-06-21
2,747 reads
Powerful, Flexible Text-Formatting Solutions in SQL Server
You can build very powerful and flexible text-formatting solutions in SQL Server. Learn how to apply techniques that handle the simplest to the more complex text-formatting tasks.
2006-06-20
3,557 reads
SQL Server 2005 - Unattended installation - Part I
Automating the installation of SQL Server was made simple in SQL Server 2005. SQL Server 2005 can be installed using a GUI, an ini file or just run setup.exe with a bunch of parameters.
2006-06-19
2,304 reads
Executing SQL Stored Procedures from inside a Web Application
This article, the last in the Stored Procedure series, will focus on RETURN parameters.
2006-06-16
4,328 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat BCA KCP Central Park Telp:0821°8200°203
Telp/Wa 628218200203 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren,...
Alamat BCA KCP Ruko Swadaya Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23,...
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers