Generally: the log files first_lsn needs to be <= the full backups last_lsn and the log files last_lsn needs to be greater than the full backups last_lsn. When this condition...

I'm surprised more people didn't choose 1,2,3. The update will fail, leaving the 2nd select giving the original values.

I doubt this. Hitting SHIFT...

Lukasz H. (9/19/2016)

---

I know it's old thread but I found that there is some 30-65 sec wait/timeout during any backup/restore from UNC path when it's short UNC name. With full...

This only works within the dbo schema. To have it work with all tables, you'd need to change line 39 to do something like this:

select quotename(s.name) + '.' + quotename(t.name)

from...

Yes, the word "if" exists in that example. The distinction is closing out the request completely versus keeping it open. Removing the last sentence doesn't change anything.

It's like if someone...

cdesmarais 49673 (11/25/2015)

---

sequelgarrett (11/25/2015)

---

cdesmarais 49673 (11/25/2015)

---

I hate absolutes, but really, never say no. Always take the extra time to turn the no into an "if." We can do...

cdesmarais 49673 (11/25/2015)

---

I hate absolutes, but really, never say no. Always take the extra time to turn the no into an "if." We can do that if we...

What advantages does this have over sp_whoIsActive?

This is really neat. If I didn't have Litespeed I would definitely use this.

The question is what matters, not the title. The answer to the question asked is 524 PB. If the OP intended for it to be express edition, it should have...

Why is the CASE statement necessary?

Do the number of columns in the definition of the view really matter from a performance perspective? I thought the columns returned from a view only matter when the view...

<edit>

Lynn Pettis (11/14/2014)

---

Yes, poorly worded. As for getting points back? You didn't lose any points, you just didn't get any for a correct answer. Anyway, the points...