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

Content with tags programming, visual basic 6, sql server 7 Rss

<< Newer    Items 21 to 27 of 27   
 

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

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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,232 reads

Review of SQL Comparison and Synchronization Toolkit

This week Andy takes a look at a new product from Red-Gate that gives you even more options than you get with their SQL Compare and SQL Data Compare tools - now you can build your own. Add the features you always wanted. Build automated processes instead of using the GUI. It's an interesting product - read the review and then maybe even enter the contest to win a free copy.   Read more...
By Andy Warren 2002/01/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,361 reads

Worst Practices - Making Databases Case Sensitive (Or Anything Else)

Article number four in this popular series continues exposing Worst Practices! This week Andy continues his tirade by talking about why case sensitive databases should be BANNED from the planet. Is he right or just OUT OF CONTROL? Read the article and join the discussion - your comment may lead to an article, that's what generated this one!   Read more...
By Andy Warren 2005/07/08 (first published: 2001/10/29) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,313 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

Creating Merge Replication Conflict Resolvers

This article describes how to create a Visual Basic application for merge replication that will handle both conflict and non-conflict changes between the affected tables.   Read more...
By Additional Articles 2001/05/01 | Source: Microsoft MSDN | Category: replication
Rating:  Rate this |   Briefcase | 1,635 reads

Index Server COM Object Programming in Visual Basic

Jon Winer talks about his adventures with Index Server and provides some hints to help you avoid some common problems.   Read more...
By Jon Winer 2001/04/22 | Source: SQLServerCentral.com | Category: visual basic 6
Rating: |  Discuss |   Briefcase | 4,122 reads
<< Newer    Items 21 to 27 of 27   
 
Tags
administration (12)    
miscellaneous (12)    
configuring (8)    
t-sql (8)    
ado (7)    
sql-dmo (6)    
dts (4)    
performance tuning (4)    
strategies (4)    
.net (3)    
database design (3)    
replication (3)    
backup / restore (2)    
basics (2)    
stored procedures (2)    
best and worst practices (1)    
distributed queries (1)    
english query (1)    
indexing (1)    
installation (1)    
security (1)    
worst practices (1)    
xml (1)