(Greg Low) On a recent consulting job, the performance problems that are easy to get into when using SQL Server Views was again made very clear to me.

(Jim Keogh) Throughout this chapter you learned how to create simple queries to perform operations that are common to commercial web sites. These queries are created in the event handler in your web page and are sent to the DBMS for processing.

(Hilary Cotter) SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient querying when you have large amounts of unstructured data. This is the first of a two-part article that explores the full-text language features that ship with SQL Serve

(Greg Robidoux) Testing is key to ensuring a process actually works when it comes time to implement, rather than finding out when time may be of the essence. This holds true for testing SQL Server restores as well. (R)

When you try to use merge replication to merge Microsoft SQL Server 2005 Mobile Edition data with Microsoft SQL Server 2000 data, you may experience one of the following problems: • The operation appears to be successful. However, the results are incorrect when you examine the subscriber table. Y

(Scott Mitchell) SQL Server 2005 offers a number of new features over its predecessor, including many features aimed at making working with databases more like writing .NET application code. For example, in SQL Server 2005, stored procedures, triggers, UDFs, and so on can be written using any .NET F

(Hilary Cotter) The number of deployed instances of Microsoft SQL Server in the enterprise continues to grow more rapidly than the rollouts for any other database management system (DBMS). The reasons are clear; Microsoft set out to provide a powerful DBMS that meets multiple goals for IT organiza

(Ken Kaufman) As a DBA you try to supply data in a format that is familiar to the audience you’re presenting it to. Many times, you’ll present data in MS Excel to the accounting department, or an HTML report to a standard user. Your system and security administrators are no different; they are used

(Jeremy Kadlec) Properly configuring TempDB in SQL Server 2005 is imperative with some of the system database’s new responsibilities. With SQL Server 2005, TempDB is responsible for managing temporary objects, row versioning and online index rebuilds. Some of this processing has moved from the trans

(Muthusamy Anantha Kumar) A SQL Server 2005 feature that I appreciate and want to demonstrate is the OUTPUT clause. The OUTPUT clause helps in returning the actual data from a table soon after an insert. Applications require return values such as the new identity value, the computed column value or