Tom.Thomson (1/7/2011)

---

Cengland, are you doing any replication (that can cause transaction logs to get big if you have a poor network and/or the wrong sort of log synchronisation)? Do...

mtassin (1/7/2011)

---

I disagree -- it is a major change. If it doesn't...

WayneS (1/7/2011)

---

Exactly. Doing a t-log backup will clear the VLFs (if possible), so that they can be reused. The t-log grows when it's out of VLFs. You should be able...

WayneS (1/7/2011)

---

Have you ever thought that the two of these are related? With too large of a VLF, it makes it harder for SQL toever get that VLF empty, where...

Tom.Thomson (1/7/2011)

---

Nice question, but: why would anyone create a 50GB log file in one fell swoop, rather than say making a logfile of 7142 MB and then extending it by...

I thought it was Croation at first but now I have my doubts because I cannot find all the words in that...

Awesome question but very difficult.

Another way to put this is if the question said:

In a non-empty rowset, ROW_NUMBER() always returns consecutive integers.

What would you answer? True or False?

I'd still answer False because it's...

Because I usually have to look them up to...

Hugo Kornelis (1/6/2011)

---

cengland0 (1/6/2011)

---

Meh, I could just as well say that everything is consecutive in a single-row rowset.

According to http://www.thefreedictionary.com/consecutive, "consecutive" means (a.o.) "Following one after another without interruption" -...

This was a very easy question but when I saw it was worth 2 points, I had to hesitate before answering it and look through all the options a second...

There are several ranking functions:

RANK

DENSE_RANK

NTILE

ROW_NUMBER

When the question asked will it always return consecutive integers, I knew right away that it was false because none of them will always return consecutive...

sjimmo (1/5/2011)

---

I too had the 300 bd modem, but yes - there was software that could both take and convert a number to both DTMF or pulse dial codes. There...

Oh, any my first modem was a 300 baud acoustic coupler.

Did you ever see the movie war games? They used one of those too. You take the receiver...

8" single sided, 5" single sided single...