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

Content with tags stored procedures, miscellaneous Rss

<< Newer    Items 21 to 27 of 27   
 

Worst Practice - Bad Comments

This one is pretty interesting, Andy discusses a few things he sees in comments that not only fail to add value, they end up costing extra time. There's room for discussion here, but definitely a discussion worth having - comments can make you or break you, here's a chance to think about what you think is important in commenting and pass that on to your development team.   Read more...
By Andy Warren 2003/01/23 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,399 reads

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: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,148 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

Attach and Detach..Again

Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!   Read more...
By Andy Warren 2006/06/23 (first published: 2002/04/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,198 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,684 reads

Introduction to the ADO Connection Object

Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?   Read more...
By Andy Warren 2006/05/26 (first published: 2001/11/08) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 30,956 reads

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.   Read more...
By Andy Warren 2001/06/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,568 reads
<< Newer    Items 21 to 27 of 27   
 
Tags
t-sql (20)    
programming (12)    
sql server 7 (8)    
administration (6)    
configuring (4)    
security (4)    
strategies (4)    
xml (4)    
installation (3)    
performance tuning (3)    
visual basic 6 (3)    
ado (2)    
advanced querying (2)    
backup / restore (2)    
database design (2)    
dts (2)    
indexing (2)    
sql-dmo (2)    
triggers (2)    
user defined function (udf) (2)    
basics (1)    
best and worst practices (1)    
dba code (1)    
distributed queries (1)    
english query (1)    
function (1)    
monitoring (1)    
naming standards (1)    
openxml (1)    
replication (1)    
semaphore (1)    
sql puzzles (1)    
updategrams (1)    
views (1)    
worst practices (1)    
xsl (1)