|
|
| Transact SQL [+] Favor-It | |
| |
 |
| | Sort By:
|
In this review, Vyas takes a closer look at this recently released (April 2002) Transact-SQL Book and finds it unique, practical and useful for all levels of database programmers. Author: Narayana Vyas Kondreddi |
This article shows you how to store and validate email addresses, write different types of queries on email addresses efficiently, using computed columns and indexes. It also covers the security aspect of dealing with email addresses. Author: Narayana Vyas Kondreddi |
This article discusses the advantages and disadvantages of SQL Server GUI tools (Enterprise Manager) and the T-SQL administrative commands, with examples. Read up and decide for yourslef, if you want to be a point-and-click DBA or a SQL scripting expert! Author: Narayana Vyas Kondreddi Code: ASP 3.0 & VBScript |
| | |
This book is for SQL Server developers, Database Administrators (DBAs), let them be beginners or advanced. I would strongly recommend this book for anyone who has a bit of T-SQL knowledge, and are looking forward to being a Guru in T-SQL. Author: Narayana Vyas Kondreddi Code: ASP 3.0 & VBScript |
This article shows you how to analyze the data gathered by Profiler, to identify the performance issues. This article also provides four generic stored procedures for analyzing Profiler output. Author: Narayana Vyas Kondreddi Code: ASP 3.0 & VBScript |
Unfortunately, there is no built-in support for arrays in SQL Server's T-SQL. This article provides 5 different techniques to simulate arrays in T-SQL, with working examples. It also provides you with links to additional information and books. Author: Narayana Vyas Kondreddi Code: ASP 3.0 & VBScript |
This article shows you how to implement case sensitive searches in SQL Server, using different techniques like conversion to binary datatype, COLLATE clause, BINARY_CHECKSUM function, computed columns etc. Author: Narayana Vyas Kondreddi Code: ASP 3.0 & VBScript |
| | |
When to or when not to use SET or SELECT? Does it matter? This article shows you how SET and SELECT are different in various scenarios, along with examples, and a test script to identify the performance differences between SET and SELECT
Author: Narayana Vyas Kondreddi Code: ASP 3.0 & VBScript |
In a typical data-driven Web site, many pages include tables of data that have been retrieved from a database. Author: Andrew Novick Code: ASP 3.0 & VBScript |
Icon Key >
 - Recently Updated
 - Showcase Listing
|