Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  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   next page 


ADS BY GOOGLE SPONSORED LINKS FEATURED LINKS

Microsoft Exchange & Windows Connections event returns to Las Vegas Nov 10 - 13
Connections returns to Las Vegas for this exciting event where each attendee will receive SQL Server 2008 standard with 1 CAL. Co-located with Microsoft ASP.NET, SQL Server, and SharePoint Connections with over 250 in-depth sessions.

Free Online Event! Virtualization:Get the Facts!
Register now and attend this free, live in-depth online conference on November 13 and 20, 2008, produced by Windows IT Pro. All registrants are eligible to receive a complimentary one-year digital subscription to Windows IT Pro (a $49.95 value)!

Check Out Hyper-V Video on ITTV
Watch Karen Forster's interview on Hyper-V's performance on ITTV.net.

Ease Your Scripting Pains with the Flexibility of PowerShell!
Join MVP Paul Robichaux on December 11, 2008 at 11:00 AM EDT as he equips you with PowerShell basics in 3 introductory lessons, each followed by a live Q&A session—all on your own computer!

Latest Advancements in SSL Technology
There are a variety of different kinds of SSL to explore to ensure customer data is kept confidential and secure. In this paper, we will discuss some of these SSL advances to help you decide which would be best for your organization.

PASS Community Summit 2008 in Seattle on Nov 18-21
The don’t-miss event for Microsoft SQL Server Professionals. Register now and you’ll enjoy top-notch Microsoft and Community speakers and more.



Solving PST Management Problems
In this white paper, read about the top PST issues and how to administer local/network PST Files.

Get Protected -- Data Protection Manager 2007
Protect your virtualized environment with Data Protection Manager

Order Your SQL Fundamentals CD Today!
Learn how to use SQL Server, understand Office integration techniques and dive into the essentials of SQL Express and Visual Basic with this free SQL Fundamentals CD.

Maximize Your SharePoint Investment: Get Your Data Moving
Watch this web seminar now to learn how to maximize your SharePoint investment! Join us as we take a look at the complex business of securing, accessing and managing vast amounts of information in a global network and various ways to get your data moving.
Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service 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 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing