We had no way of telling if DELETE TABLE meant DELETE FROM or DROP TABLE. Both would have worked though 🙂

No such command as "DELETE TABLE". I thought that was the catch so went for the two truncates (against my better judgement). There was only one correct answer.

If you're trying to store the value of Pi, then they all are 😉

Michel Steiner (1/30/2015)

---

Under which conditions can count(*) be slow? I'm trying with a 5TB DB, several tables having millions of rows and always get the answer in less than 1...

I gave it a go with the Euro...

Not everybody here is an expert. People come here to learn what, to you, may be simple.

I thought it was 10^38 - 1 which works for a DECIMAL(38,0) type. That's a much bigger number than the BIGINT type gives you.

I hope so. If it's still on the "to do" list after six years then the client would be getting a bit twitchy :ermm:

I'm about to jump in the car and drive up the A1 for my first (and hopefully last) attempt at 70-463. I've already got 461/2 and learned from those that...

Sadly my eyesight isn't what it was and I misread "Shirts" as a similar word without an "r" in it.

I quickly reached the conclusion that Steve would have to have...

I'd be more worried about the 22% of people who didn't select the CHTM option but...

momer79 (9/10/2014)

---

No it hasn't retired.

https://www.microsoft.com/learning/en-gb/exam-70-433.aspx%5B/quote%5D

I stand corrected. I thought this one was long gone.

This is a six-year old thread about the 70-445 exam which was retired three years ago. Try reading up on 70-463.

The point that we all missed was that 70-433 was retired in July 2013.