Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, Miscellaneous, ADO, Visual Basic 6 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,164 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,830 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,238 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)