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

Content with tags Stored Procedures, Triggers, T-SQL Rss

   Items 1 to 5 of 5   
 

Stored Procedure vs Triggers

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.   Read more...
By Gulappa Vijaya Kumar 2006/03/31 (first published: 2004/08/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 38,968 reads

Stored Procedure vs Triggers

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.   Read more...
By Gulappa Vijaya Kumar 2006/03/31 (first published: 2004/08/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 38,968 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

Creating your own sp_MSforeach stored procedure

This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.   Read more...
By Brian Knight 2002/06/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,885 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 6,398 reads
   Items 1 to 5 of 5   
 
Tags
sql server 7 (4)    
administration (3)    
backup / restore (2)    
configuring (2)    
dts (2)    
indexing (2)    
installation (2)    
miscellaneous (2)    
performance tuning (2)    
security (2)    
user defined function (udf) (2)    
advanced querying (1)    
distributed queries (1)    
english query (1)    
monitoring (1)    
openxml (1)    
replication (1)    
updategrams (1)    
xml (1)    
xsl (1)