The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Filled with performance tips on database design, application building, and SQL Server tuning, this is the essential guide to maximizing SQL Server performance.
By Michael D. Reilly
Answers to December practice questions on constraints and integrity.
List of roles and their internal names
Three practice questions
By Russ Whitney
January MDX Puzzle question
Answer to December MDX Puzzle question
By Rick Dobson
Microsoft Database Engine (MSDE) operates as a database server for a local workgroup in a peer-to-peer network or on a Windows NT computer.
SQL Server data field types are similar to those for Jet databases, but with some distinct differences.
By Ted Daley
In "Merge Zone" (November), the database diagram contained an error. The correct diagram has an additional table, field_user, that is used for the dynamic filtering criteria.
By Michael Otey
Here’s an efficient way to write a query to retrieve members with an attribute belonging to all members in one or many groups.
Microsoft Office has always had strong BackOffice connectivity. Office 2000 continues this trend with strong SQL Server connectivity. Here are the seven coolest SQL Server integration features in Office 2000.
By Richard Waymire
Answers from Microsoft
By Stephen Wynkoop
Is the introduction of XML in SQL Server a good thing?
By Tibor Karaszi
The winner and answer to last month's reader challenge plus this month's question.
Security is a matter that concerns database designers and administrators alike. A database's design must address security issues, which can influence table design or the use of views and stored procedures to restrict user access to the tables.
The latest TPC results
By Michelle A. Poolet
If everyone in a company who needs information can get to the corporate data in a timely manner and can understand what the data means, everyone can be more responsive to customer and industry challenges and can do a better job.
OLAP Services’ performance tradeoffs occur between cube build time and query time. Here’s how to optimize OLAP performance.
By Ken Spencer
Store session information on a Web server easily with Session and Application variables.
With the release of Access 2000, the time is right to start using Access to develop solutions for SQL Server. The time is right also for a column targeting SQL Server development for Access developers, particularly those using Access 2000.
By Kalen Delaney
The Transact SQL (T-SQL) language provides options for controlling SQL Server’s behavior on an individual-connection basis.
By Ron Talmage
Sylvain Faust’s SQL-Programmer, a third-party, general-purpose SQL Server utility development tool, provides cross-platform capability for any combination of SQL Server, Sybase Adaptive Server, and Oracle.
Access 2000’s new data definition capabilities for SQL Server databases will empower your organizations to build SQL Server applications faster and more easily than ever before.
By Dusan Petkovic
It can be difficult to determine whether a table scan or an index will provide better query performance. The answer depends in part, on the percentage of rows returned, but another important factor is whether you use a clustered or nonclustered index.
By Morris Lewis
What a difference an index can make! You can get better performance by configuring everything from your hardware to your database options. Here are my top nine ways to performance-tune SQL Server 6.5.
An application’s performance depends on your database’s design and query structure. A few simple tweaks of your database and queries can give you optimal performance.
advertisement