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

Guest Columnist: Stefan Popovski

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Be Prepared - Part 2

Error handling in SQL Server 2000 is tricky. And it isn't the most robust system in the world. Stefan Popovski started a series on error handling using @@error and xact_abort. Here's the second installment of this series looking at error handling in nested stored procedures.   Read more...
By Stefan Popovski 2004/06/08 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 9,957 reads

Be Prepared

The error handling in SQL Server leaves something to be desired, especially compared with other RDBMSes and languages. The standard method of testing for errors can leave your code bloated and hard to read. Stefan Popovski looks at another method of handling errors.   Read more...
By Stefan Popovski 2004/04/21 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 8,249 reads

Viewing the Hierarchy of Stored Procedures

In this short article that follows up on an earlier one that discussed dependency issues we have some code that will generate simple treeview type view of the relationships between procs. Mostly code, more so than usual, but we thought you might find the idea useful!   Read more...
By Stefan Popovski 2004/02/09 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,304 reads

Finding Real Dependencies

Sysdepends is a neat idea, but in practice it's not always accurate. This article talks about why it's not always reliable and presents some code (recursive even!) that will let you find all the dependencies by querying the system tables.   Read more...
By Stefan Popovski 2003/12/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,108 reads

Replacing BCP with SQLBulkLoad

New Author! Stephan writes about why he thinks the bulk load capabilities added in the SQLXML3 addition are a great way to handle imports - maybe so good that you'll stop using BCP.   Read more...
By Stefan Popovski 2003/07/21 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,986 reads
   Items 1 to 5 of 5