August, 2007
July Challenge Solution: Localizing Language/Region-Based Customer Settings
SQL Server Magazine
|
May, 2007
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.
SQL Server Magazine
|
May, 2007
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
SQL Server Magazine
|
April, 2007
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.
SQL Server Magazine
|
March, 2007
Change the Status of Table Items
SQL Server Magazine
|
February, 2007
Solution to February Reader Challenge: Check for an Empty Table
SQL Server Magazine
|
January, 2007
Check for an Empty Table
SQL Server Magazine
|
December, 2006
Converting a Hexadecimal String to a Varbinary Value
SQL Server Magazine
|
November, 2006
Improve T-SQL to Prevent Deadlocks
SQL Server Magazine
|
October, 2006
November Reader Challenge: Parse and Insert Data from Uploaded Image Files
SQL Server Magazine
|
September, 2006
Enforcing Uniqueness Without the Unique Constraint
SQL Server Magazine
|
August, 2006
Generating 6-Digit All-Numeric File Numbers for Search
SQL Server Magazine
|
July, 2006
Generating 6-Digit All-Numeric File Numbers for Search
SQL Server Magazine
|
June, 2006
Creating an Easy Query Mechanism for Gathering Customer Data
SQL Server Magazine
|
May, 2006
Writing Efficient Queries to Return Inventory Items
SQL Server Magazine
|
April, 2006
Running SQL Server 2000 Queries in SQL Server 2005
SQL Server Magazine
|
March, 2006
Querying Tables and Views on a Linked Server
SQL Server Magazine
|
February, 2006
Enforcing Restricted Uniqueness on Columns
SQL Server Magazine
|
January, 2006
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.
SQL Server Magazine
|
December, 2005
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
SQL Server Magazine
|