Want to write code faster–and write faster code? This issue gives you tips for tuning your code to get the best performance from your ADO applications and your development team. Also learn about multifaceted relationships, programming with SQL-DMO, and how to code fake temporary tables.

This is the first installment in a monthly, Web-only series of SQL Server tips brought to you by the Microsoft SQL Server Most Valuable Professionals (MVPs). Microsoft introduced the MVP program in the 1990s to recognize members of the general public who donate their time and considerable computing

Quoted identifiers are used by default in SQL Server 2000, that is, they are set to ON. This is different from SQL Server 7.0 where they were set to OFF by default. Read on to see what this means for you.

This document introduces SQL Server administrators and developers to the new security features of SQL Server 2000. In addition to outlining the new features, there is a detailed discussion about how to best implement security in a Microsoft Windows® 2000 domain environment as well as source code exa

Marquis Howard tells us…I just finished a project in which my company did some things with XML and Extensible Style Language Transformations (XSLT) that no one on the team had done before. The task at hand was to convert some existing Cold Fusion reports to Active Server Pages (ASP) reports.

SQL Server 6.5 is a successful database for building, managing, and deploying business applications. SQL Server 7.0 builds on this foundation, while responding to new customer demands. This document states the goals of SQL Server 7.0, explains SQL data query processing, and discusses specific improv

When you create a table in SQL Server you can add various constraints to the table. One of the constraints you can add is a default contstraint.

General online performance shouldn't be impacted either by using one large database or a series of smaller databases. SQL Server doesn't cache entire databases, it caches data pages, and it doesn't matter if all of the pages in memory are in one database or if they're spread out acro

From SQL Team……We've got another article chock full of SQL goodness from Garth. This one covers creating a dynamic ORDER BY clause for your SELECT statements. It's a follow up to his earlier article on dynamic WHERE clauses.

This paper describes how to effectively develop custom applications using Decision Support Objects (DSO) in Microsoft SQL Server 2000 Analysis Services by providing practical advice in real-world situations.