Umachandar Jayachandran

Umachandar Jayachandran works on the SQL Performance Engineering Team at Microsoft. He specializes in online transaction processing and data warehousing, and he is a contributing author of SQL Unleashed, 2nd Edition (SAMS). You can find his contributions at http://blogs.msdn.com/sqltips and http://blogs.msdn.com/sqlperf.

Articles by Umachandar Jayachandran
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 2

There were no winners for the February Reader Challenge, "Check for an Empty Table." Here's a recap of the problem and the solution to the February Reader Challenge.

Check for an Empty Table

The winners for the January Reader Challenge, "Converting a Hexadecimal String to a Varbinary Value" will be announced at a later date. Please watch this article page for updates. Here's a recap of the problem and the solution to the January Reader Challenge.

Converting a Hexadecimal String to a Varbinary Value

Congratulations to John T. Keller, who won first prize of $100 for the best solution to the December Reader Challenge, "Improve T-SQL to Prevent Deadlocks" and to Bill Twomey who won second prize of $50. John is a database developer for Softek Solutions, and Bill is a Microsoft SQL Server DBA for Database Solutions. Here's a recap of the problem and the solution to the December Reader Challenge.

Improve T-SQL to Prevent Deadlocks

There were no winners for the November Reader Challenge, "Parse and Insert Data from Uploaded Image Files." Here’s a recap of the problem and the solution to the November Reader Challenge.

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

Congratulations to Chad Boyd, who won first prize of $100 for the best solution to the October Reader Challenge, "Enforcing Uniqueness Without the Unique Constraint." Chad graciously donated his prize to the Make-a-Wish Foundation (http://www.wish.org). Here’s a recap of the problem and the solution to the October Reader Challenge.

Enforcing Uniqueness Without the Unique Constraint 2

Congratulations to Steve Kass and Lay Chew. Steve won first prize of $100 for the best solution to the September Reader Challenge, "Fixing a Faulty Lookup Query." Lay won second prize of $50. Here’s a recap of the problem and the solution to the September Reader Challenge.

Generating 6-Digit All-Numeric File Numbers for Search - 13 Jul 2006
The July Reader Challenge, "Creating an Easy Query Mechanism for Gathering Customer Data," had no winners. Here’s a recap of the problem and the solution to the July Reader Challenge.
Creating an Easy Query Mechanism for Gathering Customer Data

Congratulations to Ahmad Bahr Mohamed, who recently won the May Reader Challenge. Ahmad Bahr Mohamed, a DBA/Database developer at Applied Industrial Technology (AIT) in Cleveland, Ohio, won an honorable mention for the best solution to the June Reader Challenge, "Writing Efficient Queries to Return Inventory Items." Here’s a recap of the problem and the solution to the June Reader Challenge.

Writing Efficient Queries to Return Inventory Items

Congratulations to Ahmad Bahr Mohamed and Len Binns. Ahmad Bahr Mohamed, a DBA/Database developer at Applied Industrial Technology (AIT) in Cleveland, Ohio, won first prize of $100 for the best solution to the May Reader Challenge, "Running SQL Server 2000 Queries in SQL Server 2005." Len Binns, a Senior Programmer/Analyst at the University at Buffalo's School of Dental Medicine, won second prize of $50. Here’s a recap of the problem and the solution to the May Reader Challenge.

IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×