Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Jambu Krishnamurthy

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

A Refresher on Joins

Knowing the various types of joins can greatly expand your T-SQL skills. Jambu Krishnamurthy brings us a refresher article on the various types of joins and how to write them.   Read more...
By Jambu Krishnamurthy 2007/04/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,401 reads

Views and Horizontal Partitioning

Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.   Read more...
By Jambu Krishnamurthy 2007/04/12 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 9,833 reads

Five Realtime DTS Examples

SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server 2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment.   Read more...
By Jambu Krishnamurthy 2007/03/22 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 16,899 reads

Exception handling in DTS

While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.   Read more...
By Jambu Krishnamurthy 2006/12/19 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,009 reads

Data Modeling using ERWIN and SQL Server 2000

Using data modeling tools should be something that all SQL Server DBAs involved in development use, but most of us cannot afford the tools or have the expertise to use them. Jambu Krishnamurthy brings us a new article that shows how you can use Erwin to work with your data model.   Read more...
Rating: |  Discuss |   Briefcase | 12,253 reads

Table Variables

New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000.   Read more...
By Jambu Krishnamurthy 2006/11/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 16,316 reads

Analysis of SQL Server Performance Data

Gathering performance data on your servers can be a cumbersome task without paying for an expensive tool. New author Jambu Krishnamurthy brings us a short tutorial on how you can gather this data from Perfmon and import it into SQL Server for reporting.   Read more...
By Jambu Krishnamurthy 2006/10/30 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 11,117 reads
   Items 1 to 7 of 7