http://www.sqlmag.com/authors/author/author/5777647/rss/5777647en-USFri, 25 May 2012 08:56:29 GMTFri, 25 May 2012 08:56:29 GMThttp://www.sqlmag.com/article/sql-server/july-challenge-solution-localizing-language-region-based-customer-settingsJuly Challenge Solution: Localizing Language/Region-Based Customer Settings]]>Umachandar JayachandranThu, 02 Aug 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/july-challenge-solution-localizing-language-region-based-customer-settingshttp://www.sqlmag.com/article/sql-server/localizing-language-region-based-customer-settingsA 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]]>Umachandar JayachandranWed, 23 May 2007 08:25:45 GMThttp://www.sqlmag.com/article/sql-server/localizing-language-region-based-customer-settingshttp://www.sqlmag.com/article/sql-server/optimizing-queries-for-fact-tablesHelp 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.]]>Umachandar JayachandranWed, 23 May 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/optimizing-queries-for-fact-tableshttp://www.sqlmag.com/article/sql-server/check-for-objects-created-without-set-options-enabledTest your SQL Server savvy in this month’s Reader Challenge. Submit your solution in an email message to challenge@sqlmag.com by May 10.]]>Umachandar JayachandranThu, 19 Apr 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/check-for-objects-created-without-set-options-enabledhttp://www.sqlmag.com/article/sql-server/change-the-status-of-table-itemsChange the Status of Table Items]]>Umachandar JayachandranThu, 22 Mar 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/change-the-status-of-table-itemshttp://www.sqlmag.com/article/sql-server/solution-to-february-reader-challenge-check-for-an-empty-tableSolution to February Reader Challenge: Check for an Empty Table]]>Umachandar JayachandranThu, 15 Feb 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/solution-to-february-reader-challenge-check-for-an-empty-tablehttp://www.sqlmag.com/article/sql-server/check-for-an-empty-table-Check for an Empty Table ]]>Umachandar JayachandranThu, 25 Jan 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/check-for-an-empty-table-http://www.sqlmag.com/article/sql-server/converting-a-hexadecimal-string-to-a-varbinary-valueConverting a Hexadecimal String to a Varbinary Value]]>Umachandar JayachandranThu, 14 Dec 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/converting-a-hexadecimal-string-to-a-varbinary-valuehttp://www.sqlmag.com/article/sql-server/improve-t-sql-to-prevent-deadlocksImprove T-SQL to Prevent Deadlocks]]>Umachandar JayachandranThu, 16 Nov 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/improve-t-sql-to-prevent-deadlockshttp://www.sqlmag.com/article/sql-server/november-reader-challenge-parse-and-insert-data-from-uploaded-image-filesNovember Reader Challenge: Parse and Insert Data from Uploaded Image Files]]>Umachandar JayachandranWed, 11 Oct 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/november-reader-challenge-parse-and-insert-data-from-uploaded-image-fileshttp://www.sqlmag.com/article/sql-server/enforcing-uniqueness-without-the-unique-constraintEnforcing Uniqueness Without the Unique Constraint]]>Umachandar JayachandranWed, 13 Sep 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/enforcing-uniqueness-without-the-unique-constrainthttp://www.sqlmag.com/article/sql-server/generating-6-digit-all-numeric-file-numbers-for-searchGenerating 6-Digit All-Numeric File Numbers for Search]]>Umachandar JayachandranThu, 10 Aug 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/generating-6-digit-all-numeric-file-numbers-for-searchhttp://www.sqlmag.com/article/sql-server-2005/generating-6-digit-all-numeric-file-numbers-for-search-Generating 6-Digit All-Numeric File Numbers for Search ]]>Umachandar JayachandranThu, 13 Jul 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-2005/generating-6-digit-all-numeric-file-numbers-for-search-http://www.sqlmag.com/article/sql-server/creating-an-easy-query-mechanism-for-gathering-customer-dataCreating an Easy Query Mechanism for Gathering Customer Data]]>Umachandar JayachandranWed, 07 Jun 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/creating-an-easy-query-mechanism-for-gathering-customer-datahttp://www.sqlmag.com/article/sql-server/writing-efficient-queries-to-return-inventory-items-Writing Efficient Queries to Return Inventory Items ]]>Umachandar JayachandranThu, 11 May 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/writing-efficient-queries-to-return-inventory-items-http://www.sqlmag.com/article/migration/running-sql-server-2000-queries-in-sql-server-2005Running SQL Server 2000 Queries in SQL Server 2005]]>Umachandar JayachandranThu, 13 Apr 2006 00:00:00 GMThttp://www.sqlmag.com/article/migration/running-sql-server-2000-queries-in-sql-server-2005http://www.sqlmag.com/article/sql-server/querying-tables-and-views-on-a-linked-serverQuerying Tables and Views on a Linked Server]]>Umachandar JayachandranThu, 09 Mar 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/querying-tables-and-views-on-a-linked-serverhttp://www.sqlmag.com/article/sql-server/enforcing-restricted-uniqueness-on-columnsEnforcing Restricted Uniqueness on Columns]]>Umachandar JayachandranWed, 08 Feb 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/enforcing-restricted-uniqueness-on-columnshttp://www.sqlmag.com/article/tsql3/imposing-data-restrictionsHelp 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.]]>Umachandar JayachandranWed, 11 Jan 2006 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/imposing-data-restrictionshttp://www.sqlmag.com/article/sql-server-2000/deploying-a-startup-parameter-on-all-serversReaders 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]]>Umachandar JayachandranThu, 15 Dec 2005 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-2000/deploying-a-startup-parameter-on-all-servers