If you're interested in...

FreeHansje (6/2/2009)

---

Very educational article. Lately I have to deal with performance issues created by similar queries as given in this article. I like to read more about subqueries and their...

Jeff Moden (6/9/2009)

---

Mike C (6/9/2009)

---

Jeff Moden (6/9/2009)

---

Mike C (6/9/2009)

---

Another minor quibble - each instance of RAND() is invoked once per query.

SELECT RAND(), RAND()

Generates two different random numbers because RAND() is...

Jeff Moden (6/9/2009)

---

Mike C (6/9/2009)

---

Another minor quibble - each instance of RAND() is invoked once per query.

SELECT RAND(), RAND()

Generates two different random numbers because RAND() is actually called twice. ...

drogers (6/9/2009)

A minor quibble with the article: the problem is not that RAND() is called multiple times with the same seed, once per row. The problem is that RAND() is...

Someguy (6/9/2009)

---

Mike C.

Thank you for your answer to a slightly lazy question - Yes, I should have simply run the query SELECT Rand() and pushed the start button several times...

sqlservercentral (6/9/2009)

---

I don't know the properties of newid, and any function on an unknown source of entropy can cause problems if you'll looking for true randomnous rather than just a...

Jeff Moden (6/9/2009)

---

Mike C (6/9/2009)

---

In T-SQL you can use RAND() without a seed. If you want better random numbers check out one of my favorite random number generators with...

Someguy (6/9/2009)

---

OK. I'll be the one to ask the dumb question:

Most languages have a random function that does not require you to add seeds and/or do other things to make...

timothyawiseman (6/9/2009)

---

Good article, Chris.

If you truly need it to be random then the method you have is probably the way to go, but if you just want 20% of the...

Here's an interesting twist:

SELECT TOP (100) ABS(CHECKSUM(NEWID())) % 100

FROM dbo.syscolumns

WHERE ABS(CHECKSUM(NEWID())) % 100 BETWEEN 1 AND 5

Notice that the values returned are way outside the range 1..5 since the NEWID()...

Hi Oleg,

You could use the sys.dm_fts_parser to retrieve the expansion sets from SQL Server and use that to recreate a query string that includes all your inflectional and thesaurus word...

wbrianwhite (5/13/2009)

---

Mike C (5/13/2009)

---

There's always more than one way to skin a cat. The question is twofold: (1) What's the performance of the alternative solution and (2) is...

wbrianwhite (5/12/2009)

---

In what way was simple set logic unable to perform this operation? It looks like this could be solved with left outer joins and is null tests. ...

Vicky (5/4/2009)

---

Hi Friends,

This is first time I'm asking a question here. I'm trying to encrypt...