Tom.Thomson (3/29/2010)

---

There are a couple of additional things backup could do to improve performance: at some point before starting to write pages to backup media, it could write all dirty...

Tom.Thomson (3/19/2010)

---

If I undertand it rightly, the correct wording is more like "from the start of the oldest transaction that was uncommitted at the start of the backup, or from...

Hugo Kornelis (3/29/2010)

---

As far as I know, it stops as soon as it reaches the end of the log file. That means that, in theory, you could envisage a scenario...

A faint bell rang in my head concerning foreign key relationship validations.

I found the following article here on SSC:

http://www.sqlservercentral.com/articles/T-SQL/68337/

May help 🙂

The newer system views have a column called is_system_named. This will be 1 for the ones you are interested in.

Examples:

sys.check_constraints

sys.foreign_keys

sys.default_constraints

The code will be simpler, and much more reliable...

Not to be confused with Candida.

My attempt:

A view is the definition of a single (restricted) SELECT statement. The definition of the view is expanded into any query it is referenced by before optimization.

A stored...

This is all a bit academic now anyway - the cause and correct solution have been posted multiple times (VLFs).

edit: Actually, the one thing has hasn't been said is that...

Yes, I do.

Paul (4 letters)

Really? That's quite a bit more than I thought...

CirquedeSQLeil (3/30/2010)

---

That to me is akin to calling Paul

Never do that again. I will find you.

:w00t:

Jeffrey Williams-493691 (3/30/2010)

---

The thing is - even with a clean shutdown there is no guarantee that the database will come back online without a log file. You are relying...

CirquedeSQLeil (3/30/2010)

---

Hurry plz it is urgent. I may...

GSquared (3/30/2010)

---

Data Geeks:

I have an urgent problem with my interview. I don't know anything about much of anything, and I'd like one of you to disguise yourself as me...

Deep? In here?