Did you run that...

Lynn, you have a valid point but if you were to show those times to a client, they would only see the output not the representation. So, for example,...

This one was really bad. I knew something was up when I saw it was worth 3 points. I selected False like everyone else in the forum and...

stewartc-708166 (11/13/2009)

---

beg to differ

refer:

http://www.microsoft.com/windowsserver2003/64bit/x64/datacenter.mspx%5B/quote%5D

The Windows Server 2003 family supports single or multiple CPUs that conform to the symmetric multiprocessing (SMP) standard. Using SMP, the operating system can run...

I almost selected option 6 and then when I double checked my answers, I noticed the tricky char(10) which isn't big enough to fit the whole 'Date is Null' string....

Whew, I got it right this time. I had thoughts about the previous B-Tree question when answering this one.

Also, if I'm rounding a number, I'm trying to reduce the number of digits after the decimal. If it keeps the same number of digits, why round it?

Good example:

Select...

Michael Poppers (10/28/2009)

---

Exactly. ...

I never get trailing zeros on a float unless I use Microsoft SQL Server Management Studio. For the last column, I get 3.6 not 3.6000 when I use any...

Bob Hovious 24601 (10/26/2009)

---

I'm late to the party on this one, but got it right from reading the Inside SQL Server 2005 books. Kalen Delaney stressed that it...

john.arnott (10/16/2009)

---

Yes, hard drives now cost in the range of a dollar a GB, but the line of business I support has to pay the enterprise infrastructure division quite a...

This one got me again. Another trick question.

The question asked, "Which of these data types will be more efficient?"

Had it asked, "Which of these data types take less hard...

Rob Goddard (10/14/2009)

---

Very good question in my book.

All too often you get guys spending hours debugging code and scratching heads when all along it was just someone chuffed up a...

I just did the same thing -- missed the bit datatype.

120 = 01111000

030 = 00011110

040 = 00101000

120 and 30 = 11000 in binary or 8 + 16 = 24

24 or...

Damian Widera-396333 (10/9/2009)

---

Last TechEd Europe (Barcelona, November 2008) I was talking with Kim Tripp - and she is a guru in indexing, and she told about B-trees as BALANCED...