Christian Buettner-167247 (4/13/2010)

---

Hugo Kornelis (4/13/2010)

---

[wrote lots of good stuff...]

Thanks for this excellent clarification which deserves an Article on its own! So you better get started! 😀

Joy Smith San (4/11/2010)

---

haaaa..very good question.. fortunately I got it right.

Wel, I would like to know...

1. When a query will timeout.?

2. When execution of something will run out of memory.?

thanks.

CirquedeSQLeil (4/8/2010)Is 0/0 = 1 or is 0/0 an error?

Paul White NZ (4/8/2010)

---

Hugo Kornelis (4/8/2010)

---

...hard question list...

I got all those questions wrong - except the 15% one :blink:

Tom Garth (4/8/2010)

---

I stand corrected. After rereading Hugo's answer I may have gottem it right for the wrong reason.

So is 2005 the endpoint's port number?

Paul White NZ (4/8/2010)

---

Hugo Kornelis (4/8/2010)

---

...hard question list...

I got all those questions wrong - except the 15% one :blink:

RBarryYoung (4/7/2010)

---

Paul:

Now I'm curious to know how you did on mine...? (here: http://www.sqlservercentral.com/questions/T-SQL/63632/) Its still got one of the lowest correct percentages that I know of.

parthenitin (4/3/2010)

---

When we creates the primary key it alwas enforce to create as Clustured.

how it will enforce to create as NonClustered.

Please Can u tell me.

bigM (4/2/2010)

---

When I insert the datatime row into a table as below, I get different result. Any idea?

use tempdb

go

create table test1 (dat datetime)

go

insert into test1 values('1753-01-01')

select * from test1

RESULT:

1753-01-01 00:00:00.000