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

Content with tags T-SQL, System Development Life Cycle, Strategies Rss

   Items 1 to 4 of 4   
 

Build molecular queries from atoms in SQL Server

Every SQL Server developer has a preferred method of doing things; mine is what I call molecular queries. These are queries assembled from atomic queries; by which, I mean that they address exactly one table. By combing atoms, I can create molecules.   Read more...
By Additional Articles 2006/10/19 | Source: Builder.com | Category: advanced querying
Rating:  Rate this |   Briefcase | 3,558 reads

How To Find SQL Server Objects

SQL Server can grow to encompass hundreds of databases on a single server, each having hundreds or thousands of objects within it. A truly scalable RDBMS. However, how many times have you been searching through the Object Browser in QA or the left pane in Enterprise Manager searching for an object? New Author Ashish Kaushal gives us a method to easily search your server for that long lost object.   Read more...
By Ashish Kaushal 2004/08/17 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 16,251 reads

Making Good Use of Sysforeignkeys Table - Part 1: Display table relati

Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.   Read more...
By Jeffrey Yao 2004/06/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,607 reads

Stored Procedure Development Cycle

This month Robert covers the process he uses for developing stored procedures. In many ways it reflects how software is developed, but it does have it's minor differences. This is a high level process discussion, not a line by line example of the entire process - by design of course.   Read more...
By Robert Marda 2003/09/03 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 10,632 reads
   Items 1 to 4 of 4   
 
Tags
advanced querying (3)    
administration (1)    
sql server 7 (1)    
stored procedures (1)