Ah ok, I didn't get your point 😀

Execute the query a few times, it...

Jeff is correct.

If there are no files in the main folders (except subfolders), you will get the 0 as a result.

If you google around, it is easy to find the T-SQL equivalent functions. Is there anything in particular you're struggling with?

pmadhavapeddi22 (4/3/2014)

---

when we are specifying high range of rows nearing to the exact no of rows then it will return all the rows of the table

like , in the QOD

we...

There must be dozen of examples on the net on how to loop through directories.

First Google result:

How to: Iterate Through a Directory Tree (C# Programming Guide)

Yes indeed, that's the whole point...

Very interesting question, thanks.

TheComedian (4/2/2014)

---

Thanks for the replies. Any suggestions for the reading material? My concern is that in 3 weeks, the exam will be updated to include SQL Server 2014...

TheComedian (4/2/2014)

---

Isn't there a copy available on the Internet? I don't think taking the course is a possibility for me since I'll be hard pressed to convince my employer...

paul.knibbs (4/2/2014)

---

Pah! Everyone knows...

You get the book when you follow the official course.

GilaMonster (4/1/2014)

---

In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the lock-less, latch-less optimistic concurrency. It's not a...

I believe this is a late April Fools topic...

paul.knibbs (4/2/2014)

---

Python? Isn't that the one where the amount of whitespace at the start of each line is part of the syntax of the language? Never even liked the sound...

Good grief, there may be 25 CUs released before they even think about an SP 😉