Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Random selection
Message
 
 
À
27/06/2011 12:09:01
Thomas Ganss (En ligne)
Main Trend
Frankfurt, Allemagne
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01516199
Message ID:
01516283
Vues:
34
>Sergey,
>
>I have seen this mentioned in some SQL tips, but in "official" docs I had not seen
>stated that NewID produces random data
>(in the statistical meaning - usable for sampling&testing)
>or the scale level it can be used at (more than ordinal ?)
>
>Did you read some MS doc certifying fitness for that usage
>or a test on the robustness when used this way ?
>Any links to throw my way ?
>
>thx
>
>thomas
>
>
I've seen a very good link where this concept was used by Paul White

Advanced T-SQL Tuning - Why Internals Knowledge Matters

BTW, you can also check TABLESAMPLE in BOL (it does show NewID() approach).
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform