Umachandar Jayachandran

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

By Umachandar Jayachandran, 08/02/2007

Localizing Language/Region-Based Customer Settings

By Umachandar Jayachandran, 05/23/2007

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 ...

Optimizing Queries for Fact Tables

By Umachandar Jayachandran, 05/23/2007

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 ...

Check for Objects Created Without SET Options Enabled

By Umachandar Jayachandran, 04/19/2007

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

By Umachandar Jayachandran, 03/22/2007

Solution to February Reader Challenge: Check for an Empty Table

By Umachandar Jayachandran, 02/15/2007

Check for an Empty Table

By Umachandar Jayachandran, 01/25/2007

Converting a Hexadecimal String to a Varbinary Value

By Umachandar Jayachandran, 12/14/2006

Improve T-SQL to Prevent Deadlocks

By Umachandar Jayachandran, 11/16/2006

November Reader Challenge: Parse and Insert Data from Uploaded Image Files

By Umachandar Jayachandran, 10/11/2006

Enforcing Uniqueness Without the Unique Constraint

By Umachandar Jayachandran, 09/13/2006

Generating 6-Digit All-Numeric File Numbers for Search

By Umachandar Jayachandran, 08/10/2006

Generating 6-Digit All-Numeric File Numbers for Search

By Umachandar Jayachandran, 07/13/2006

Creating an Easy Query Mechanism for Gathering Customer Data

By Umachandar Jayachandran, 06/07/2006

Writing Efficient Queries to Return Inventory Items

By Umachandar Jayachandran, 05/11/2006

Running SQL Server 2000 Queries in SQL Server 2005

By Umachandar Jayachandran, 04/13/2006

Querying Tables and Views on a Linked Server

By Umachandar Jayachandran, 03/09/2006

Enforcing Restricted Uniqueness on Columns

By Umachandar Jayachandran, 02/08/2006

Imposing Data Restrictions

By Umachandar Jayachandran, 01/11/2006

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 ...

Deploying a Startup Parameter on All Servers

By Umachandar Jayachandran, 12/15/2005

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