Umachandar Jayachandran

Advanced Search

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. Email address: umachandar@yahoo.com Web site: http://www.umachandar.com/resources.htm
78 results found for Umachandar Jayachandran, displaying items 1 - 20

August 2, 2007

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

May 23, 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

June 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

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

April 2007

Change the Status of Table Items
SQL Server Magazine

February 15, 2007

Solution to February Reader Challenge: Check for an Empty Table
SQL Server Magazine

January 25, 2007

Check for an Empty Table
SQL Server Magazine

December 14, 2006

Converting a Hexadecimal String to a Varbinary Value
SQL Server Magazine

November 16, 2006

Improve T-SQL to Prevent Deadlocks
SQL Server Magazine

October 11, 2006

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

September 13, 2006

Enforcing Uniqueness Without the Unique Constraint
SQL Server Magazine

August 10, 2006

Generating 6-Digit All-Numeric File Numbers for Search
SQL Server Magazine

July 13, 2006

Generating 6-Digit All-Numeric File Numbers for Search
SQL Server Magazine

June 7, 2006

Creating an Easy Query Mechanism for Gathering Customer Data
SQL Server Magazine

May 11, 2006

Writing Efficient Queries to Return Inventory Items
SQL Server Magazine

April 13, 2006

Running SQL Server 2000 Queries in SQL Server 2005
SQL Server Magazine

March 9, 2006

Querying Tables and Views on a Linked Server
SQL Server Magazine

February 8, 2006

Enforcing Restricted Uniqueness on Columns
SQL Server Magazine

January 11, 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 15, 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

[1] 2 3 4

ADS BY GOOGLE

SPONSORED LINKS		FEATURED LINKS
Download Data Protection Manager 2007 Disaster recovery at a low cost Maximize speed, performance and reliablity of your PCs and servers—automatically! Speed Up Your PC! Try Diskeeper 2008 with InvisiTasking Free Now! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. Order Your Fundamentals CD Today! Register today for your in-depth copy of one of three Fundamental CDs on the following topics – Exchange, SQL, and SharePoint. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization.		Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Empower Your Processes with PowerShell 201 Paul Robichaux delves deep into PowerShell how-tos in 3 informative lessons, each followed by live Q&A—all on your own computer! Register today! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. New Release: Windows IT Pro Master CD 13 years of content archives, fast answers with advanced search tools, and full access to WindowsITPro.com—order today!

Windows IT Pro Home

FAQ for Windows

WinInfo News
Europe Edition

About Us

Media Kit

Affiliates / Licensing

SQL Server Magazine

Office & SharePoint Pro

Windows Dev Pro

IT Job Hound

ITTV
IT Library

Technology Resource Directory

Connected Home

Windows Excavator

Windows SuperSite