The log_reuse_wait_desc column of sys.databases will tell you what is holding up internal log truncation. See Factors That Can Delay Log Truncation for details. As Ian says, if...

ta.bu.shi.da.yu (11/9/2009)

---

It was the " It's not like you'll be able to change it or take advantage of it." It seemed like a pretty reasonable question to me! And the...

No worries - I did exactly the same on another thread earlier...must be catching 😀

In case you decide to use a script component, you just need to create a one-liner along these lines:

Dts.Variables[0].Value = System.IO.Directory.GetDirectories(@"C:\Temp");

Give that component a variable of Object type to write...

I think it depends...

ta.bu.shi.da.yu (11/9/2009)

---

I'm curious whether truncating the table might not be a better idea here? If there are foreign key contraints that reference the table this won't work, of course, but...

I'm sorry - I misread your question.

There isn't a built-in way to enumerate directories by themselves (just files down a recursive tree) but you could install the Microsoft...

Yes please do try the RECOMPILE option - there's a good chance that the problem you get is down to parameter sniffing. Having up to date statistics will also...

So you're still seeing the error after the update to CU6 then?

If so, as I said: adding OPTION (KEEP PLAN) or OPTION(KEEP_FIXED PLAN) to the update statement in the procedure...

Joie, you're welcome. SQL Server on WOW is a bit of an odd duck - the only time you'd really choose it I think is if you somehow ended...

Not necessarily. Concurrency...

I doubt if a 'handful of reports' would justify the considerable complexity and expense of setting up a data warehouse 🙂

A small amount of appropriate denormalization is a perfectly sound...

Makes you wonder if the connection had IMPLICIT_TRANSACTIONS set on. Well, never mind, I'm sure there was a non-paranormal explanation 🙂

I agree entirely with Jeff's sentiments....

I can confirm that. 😀