Archives par mot-clé : 3FN

La normalisation

Voir le diaporama du cours forme_normale Le support du cours  normalisationShemaRelationnelSIO Exercice « Le centre Les lilas bleus »  ExNormalisation Lecture sur le site développez.com  

Publié dans THEORIE | Marqué avec , , , | Commentaires fermés sur La normalisation

Listing Duplicate Values by Group

Without question, one of the most common tasks performed by Database Administrators (DBAs) is identifying and weeding out duplicate values in tables. Despite the inordinate number of queries written by other DBAs to locate duplicate values in their database tables, … Continuer la lecture

Publié dans Informations | Marqué avec | Commentaires fermés sur Listing Duplicate Values by Group

Azure SQL Database – Authenticating Application Access by Using Azure AD Tokens

Learn how to leverage Azure Active Directory when connecting to Azure SQL Database from applications or services in a non-interactive manner, by relying on token-based authentication. Source: databases news

Publié dans Informations | Marqué avec | Commentaires fermés sur Azure SQL Database – Authenticating Application Access by Using Azure AD Tokens

How to Get the Output of a Stored Procedure into a Table

Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more. Source: databases news

Publié dans Informations | Marqué avec | Commentaires fermés sur How to Get the Output of a Stored Procedure into a Table

Which Indexes are not Used?

During the development cycle, indexes will be placed on SQL Server tables to speed up performance when searching for records. Lots of thought probably has gone into creating just the right mix of indexes based on how developers think customers … Continuer la lecture

Publié dans Informations | Marqué avec | Commentaires fermés sur Which Indexes are not Used?

Oracle 12c In-memory Column Store Has An Unexpected Surprise

Oracle’s in-memory column store in 12.1 can provide better performance for large data sets.  Read on to see the added ‘bonus’ it can provide. Source: databases news

Publié dans Informations | Marqué avec | Commentaires fermés sur Oracle 12c In-memory Column Store Has An Unexpected Surprise