SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Articles with tags T-SQL, SQL Server 6.5 Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 7, 2000 (3)     Administering (1)     Security (1)    
Performance Tuning (2)     Advanced Querying (1)     Stored Procedures (1)    
Performance Tuning and Scaling (2)    

Search for any content tagged T-SQL & SQL Server 6.5

   Items 1 to 4 of 4   
 

Encrypting Data With the Encrypt Function

One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.   Read more...
By Brian Knight 2006/05/29 (first posted: 2001/07/17) | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 27,395 reads

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first posted: 2004/04/02) | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 27,575 reads

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first posted: 2004/04/02) | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 27,575 reads

Using Xp_cmdshell

One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.   Read more...
By Brian Knight 2003/11/14 (first posted: 2001/05/03) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 35,323 reads

Lock View: sp_lock2

An alternative procedure for viewing locks based on sp_lock.   Read more...
By Alexander Chigrik 2001/07/24 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 5,763 reads

Encrypting Data With the Encrypt Function

One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.   Read more...
By Brian Knight 2006/05/29 (first posted: 2001/07/17) | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 27,395 reads

Using Xp_cmdshell

One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.   Read more...
By Brian Knight 2003/11/14 (first posted: 2001/05/03) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 35,323 reads
   Items 1 to 4 of 4   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use