Sergiy (9/16/2012)

---

Trigger is executed after UPDATE. If SQL Server figures out that the values are the same and does not proceed with writing to the pages then trigger has no...

Evil Kraig F (9/14/2012)

---

SQL Kiwi (9/14/2012)

---

Gianluca Sartori (9/14/2012)

---

If that happens, I'll run away and hide as far as I can.

Uh, wait... isn't that New Zealand?

C'mon Paul, get the guest...

Eugene Elutin (9/12/2012)

---

It's hard to see what will "prove it beyond all doubt"...

GSquared (9/14/2012)

---

Stefan Krzywicki (9/14/2012)

---

Anyone know how to do this?

Search time type between PM and AM

I can't quite figure out a good way to google it or there's just nothing out...

Unless there is some performance issue that I haven't spotted, it should be sensible to do this the simple and obvious way:

SELECT LoadNumber

FROM LoadTimes

WHERE...

SQL Kiwi (9/14/2012)

---

That does make sense, thanks!

BTW: Never post anything ever again, Peter. ...

Or supercalifellation?

Nice question.

But using rollback immediate may annoy someone :hehe:. I guess it's OK if you are fireproof :cool:.

Good question about something most people are lucky enough not to have encountered.

But the wording is terrible - Making the question fit the answer options forces one to assume what...

Good question.

SQL Kiwi (9/11/2012)

---

The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick...

Nice simple question.

The collation issue added some amusement to what might otherwise have been a little dull.

Moksha

That's fair enough. If you want...

duplicate post deleted

Steve Jones - SSC Editor (9/6/2012)

---

Scott D. Jacobson (9/6/2012)

---

John Hanrahan (9/6/2012)

---

Steve,

I'm surprised no one mentioned agile development practices. It seems like agile is another word for minimal testing. ...