You are here: Re: SELECT a random 10 records from table....easy newbie question « MsSQL Server « IT news, forums, messages
Re: SELECT a random 10 records from table....easy newbie question

Posted by Sψren Reinke on 08/17/07 22:50

Erland Sommarskog wrote:
> SΓΈren Reinke (soren@REMOVE.reinke.dk) writes:
>> Hugo Kornelis wrote:
>>> Marcin's answer is correct. However, if you're on SQL Server 2005 you
>>> can also use the new TABLESAMPLE option (see Books Online for the
>>> details); this will probably perform better on large tables.
>
> See my signature. Or your hard disk (if you have SQL Server installed).

Lol thanks :)

Never thought about looking there, found them :)

>
>> p.s. You blog is to large for pageflakes :( (max 512000 bytes) could you
>> maybe cut down the articles in the feed ?
>
> Pageflakes?
>
http://www.pageflakes.com/

A great way to handle a lot of RSS feeds, and it does not keep
forgetting like Google's does, and is faster than the one from microsoft.

/SΓΈren

 

Navigation:

[Reply to this message]


УдалСнная Ρ€Π°Π±ΠΎΡ‚Π° для программистов  •  Как Π·Π°Ρ€Π°Π±ΠΎΡ‚Π°Ρ‚ΡŒ Π½Π° Google AdSense  •  England, UK  •  ΡΡ‚Π°Ρ‚ΡŒΠΈ Π½Π° английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Π‘Π°ΠΉΡ‚ ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ Π² Π‘Ρ‚ΡƒΠ΄ΠΈΠΈ Π’Π°Π»Π΅Π½Ρ‚ΠΈΠ½Π° ΠŸΠ΅Ρ‚Ρ€ΡƒΡ‡Π΅ΠΊΠ°
ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ΠΈΠ΅ ΠΈ ΠΏΠΎΠ΄Π΄Π΅Ρ€ΠΆΠΊΠ° Π²Π΅Π±-сайтов, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚ΠΊΠ° ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ½ΠΎΠ³ΠΎ обСспСчСния, поисковая оптимизация