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

Content with tags T-SQL, Miscellaneous, Visual Basic 6, ADO Rss

   Items 1 to 3 of 3   

Default Values and Named Parameters for Stored Procs

Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer.   Read more...
By Andy Warren 2003/01/08 | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,154 reads

Generating HTML Tables

In this article Andy looks at one way you can separate your presentation code from your data when you generate HTML tables for simple reports. Lots of code examples so you can see how it works.   Read more...
By Andy Warren 2002/08/05 | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,808 reads

Reducing Round Trips - Part 2

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!   Read more...
By Andy Warren 2002/02/06 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,235 reads
   Items 1 to 3 of 3   
programming (3)    
advanced querying (1)    
basics (1)    
database design (1)    
performance tuning (1)    
sql server 7 (1)    
stored procedures (1)    
xml (1)