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

Articles with tag relational databases Rss

Search for any content tagged relational databases

   Items 1 to 4 of 4   

How to Avoid Conditional JOINs in T-SQL

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.   Read more...
By Additional Articles 2015/10/02 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 6,282 reads

The Road To Hell - new article from the DBA Team

Joe Celko & Chris Date guest as the sinister Relational Police in this new DBA Team adventure. Can the DBA Team save another doomed database? Find out.  Read more...
By Additional Articles 2014/08/07 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 10,947 reads

Applying The Scientific Method to SQL Server Performance Tuning

A relational database is a complex machine that is asked to deal with intricate problems. When things go wrong, it usually takes knowledge, deduction and a systematic approach to track down the root core of problems and to determine the best fix, Joshua Feierman illustrates how this can be done.  Read more...
By Additional Articles 2014/03/31 | Source: SimpleTalk | Category: problem solving
Rating:  Rate this |   Briefcase | 6,418 reads

The Longevity of the Relational Database

Waves of NoSQL hysteria come and go but the relational database remains, and Phil Factor admires its sheer ubiquity, and ability to provide data integrity and accessibility for a vast tapestry of data categories.  Read more...
By Phil Factor 2012/09/17 | Source: | Category: database weekly
Rating: |  Discuss |   Briefcase | 226 reads
   Items 1 to 4 of 4