In the concluding part of the Physical Operators series we look at the Hash operator.

Assumptions

by Steve Jones

SQLServerCentral.com

Editorial

For this Friday poll, Steve Jones asks about assumptions that cause you problems at work.

Dynamic creation of Insert, Update, Delete Stored procedures

by Deepthi Viswanathan Nair

SQLServerCentral.com

Stored Procedures

Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table

Building a Data Warehouse Blueprint for Success

by Additional Articles

Database Journal

Data Warehousing

One of the most integral components and critical success factors of any enterprise data warehousing initiative is the Solutions Architecture document, a high-level conceptual model of a data warehousing solution. Learn why this collaborative effort that addresses the needs of all major stakeholders, including both the business units and Information Technology (IT), is essential.

Developing Modifications that Survive Concurrency

by Additional Articles

SimpleTalk

Sample Chapters

You can create a database under the assumption that SQL looks after all the problems of concurrency. It will probably work fine under test conditions: then, in the production environment, it starts losing data in subtle ways that defy repetition. It is every Database Developer's nightmare. In an excerpt from his acclaimed book, Alex Kuznetsov explains why it happens, and how you can avoid such problems.

How well do you really know your colleagues?

by Geoff Norman

SQLServerCentral.com

Disaster Recovery (DR)

Take your peers out of their comfort zone and do you know how well they'll perform?

SQL Server 2008 Table Valued Parameters Performance

by Scott Zurolo

SQLServerCentral.com

An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.