TomThomson (9/25/2014)

---

That addition makes it...

Sean Lange (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

SQLRNNR (9/25/2014)

---

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single...

I have used that question during an interview. It is a fun one.

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

SQLRNNR (9/25/2014)

---

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to...

Eirikur Eiriksson (9/25/2014)

---

SQLRNNR (9/25/2014)

---

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around...

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I...

Lesser

TomThomson (9/25/2014)

---

Good question, but two small flaws:

1: the explanation is misleading. It says "The RAND function only produces one value for all calls in a specific connection with a...

amns (9/25/2014)

---

Sorry, but I didn't understand what you mean. The table...

GilaMonster (9/25/2014)

---

SQLRNNR (9/24/2014)

---

And one more test for performance.

declare @string int = 123;

select column1,column2 from table where colString = @string

This should cause an implicit conversion and wouldn't be far fetched when...

EL Jerry (9/24/2014)

---

GilaMonster (9/23/2014)

---

Sean Lange (9/23/2014)

---

Koen Verbeeck (9/23/2014)

---

Melanie.Townsend (9/23/2014)

---

I've just logged a request with the developers to see if they can have a look and see if we can get...

amns (9/24/2014)

---

Thanks for yours answers.

I thought the search by int column was faster, so meanwhile I also performed some tests on a table with a million records.

The values of columnString...

Master Blaster

Big understatement on the quality of queries there.

One could bring a server...

hasta