SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tags T-SQL, Basic Querying, Security, Miscellaneous, Stored Procedures Rss

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

Administering (2)     Performance Tuning (2)     Monitoring (1)     SQL Puzzles (1)    
Backup and Recovery (2)     SQL Server 7, 2000 (2)     OpenXML (1)     Strategies (1)    
Configuring (2)     Triggers (2)     Performance Tuning and Scaling (1)     UpdateGrams (1)    
DTS (2)     User-Defined functions (2)     Programming (1)     XML (1)    
Indexing (2)     Distributed Queries (1)     Replication (1)     XSL (1)    
Installation (2)     English Query (1)    
   Items 1 to 4 of 4   
 

Dynamic SQL or Stored Procedure

We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.   Read more...
By Andy Warren 2005/08/26 (first posted: 2003/04/23) | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 42,572 reads

Dynamic SQL or Stored Procedure

We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.   Read more...
By Andy Warren 2005/08/26 (first posted: 2003/04/23) | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 42,572 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 | 17,400 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,303 reads
   Items 1 to 4 of 4