SQL Server Magazine

July Challenge Solution: Localizing Language/Region-Based Customer Settings

Localizing Language/Region-Based Customer Settings

A DBA is designing the product catalog functionality of a Web-based order placement application. Your task is to create an appropriate database object that he can use on the client or server and that

Optimizing Queries for Fact Tables

Help a DBA devise a scheme that lets him easily optimize two queries. The indexing scheme or optimization technique that you come up with should be flexible enough to help with the queries use a table.

Check for Objects Created Without SET Options Enabled

Test your SQL Server savvy in this month's Reader Challenge. Submit your solution in an email message to challenge@sqlmag.com by May 10.

Change the Status of Table Items

Solution to February Reader Challenge: Check for an Empty Table

Check for an Empty Table

Converting a Hexadecimal String to a Varbinary Value

Improve T-SQL to Prevent Deadlocks

Enforcing Uniqueness Without the Unique Constraint

Generating 6-Digit All-Numeric File Numbers for Search

Generating 6-Digit All-Numeric File Numbers for Search

Creating an Easy Query Mechanism for Gathering Customer Data

Writing Efficient Queries to Return Inventory Items

Running SQL Server 2000 Queries in SQL Server 2005

Querying Tables and Views on a Linked Server

Enforcing Restricted Uniqueness on Columns

Imposing Data Restrictions

Help Arun select, from a table with a column storing field names, only those items in the field name column containing upper or lowercase letters of the alphabet but no special characters or numbers.

Deploying a Startup Parameter on All Servers

Readers help Charlie add a new trace flag as a startup parameter on all his servers to generate a report in the event of a SQL Server deadlock

Troubleshoot Performance Problems

Readers help Kevin write a query that will identify issues impacting his database performance.