Want to optimize your applications that run on SQL Server? Then take advantage of Symantec’s offer for free SQL Server 2005 Application Performance Management whitepapers in eBook format, and get an in-depth education. (R)

(Serdar Yegulalp) Among undocumented DBCC commands in SQL Server, DBCC RESOURCE is one of the few that can be used to report back on SQL Server’s own internal settings rather than reports on detailed information about data structures within SQL Server (such as tables, databases, indexes, etc.) (R)

Twenty-two new webcasts are scheduled for April, covering such topics as SQL Server 2005 Security, Implementing Federated Database Design Patterns, IIS Logs and SQL Reporting Services IIS Log Pack and more.

(Shyam Pather) The goal of performance optimization is to minimize the resources consumed by the application and maximize the volume of events, subscriptions, and notifications it can handle. (pdf)

(Stéphane Faroult and Peter Robson) In this chapter, we are going to take a close look at the SQL query and examine how its construct can vary according to the tactical demands of particular situations. This will involve examining complex queries and reviewing how they can be decomposed into a succe

(Marcin Policht) In the last couple of articles of this series, we have presented a variety of Control Flow tasks of SQL Server 2005 Integration Services, for which the primary purpose was the transfer of server and database objects. Despite versatility intended by their designers, a number of them

When you run a query that uses a hash join in Microsoft SQL Server 2000, a 17883 error may occur. The following error message is logged in the SQL Server error log: Error: 17883, Severity: 1, State: 0 The Scheduler 0 appears to be hung. SPID 52, ECID 0, UMS Context 0x045530B8

(Artur ¯arski) The concept of Trustworthy Computing is based on three pillars: security, confidentiality of data, and reliability. These pillars could be described in the following way: –Security: the systems feature security measures, which simplify protection against attacks originating from t

(Dennis Forbes) I’ve come across this question quite a few times. I have rows with lots of columns, and would like to split it out so that each column is a row.

(Mirko Marovic) By design, the SQL programming language works with data sets, so it is not surprising that for most problems, row by row processing is not nearly as efficient as data set processing. There is a class of problems, however, that is much easier to solve using cursors. A typical “cur