Anyone else eagerly awaiting this?

Have to say, getting increasingly irate about e-book pricing. Why do I have to pay 50p more, given all the costs of printing, distributing and shipping...

Statistics are only updated when they need to be. If the data hasn't changed significantly enough to require them to be updated, then it won't bother.

Hang on, are you running this Select * from <table> from SSMS on the local server?

The data you see in the results tab has to go somewhere. Remember that SSMS...

...and this thread becomes a statistic 😀

Brandie Tarvin (9/19/2012)

---

Yep.

My current drama is...

Cadavre (9/19/2012)

---

Glad it worked. Check this link for other formatting options for datetimes. Bear in mind that this is generally slower than...

Given that there's not a single occurrence of this error referenced on Google, I'd assume you're hitting a very unusual condition. It sounds relatively innocuous (the error log does record...

GSquared (9/18/2012)

---

Last I heard, Google uses a customized version of MySQL for their primary data storage. They rebuilt the engine and modified the ACIDity of transactions towards "eventually consistent",...

I think it's a UI bug. You have to drop down the Enumerator Selection and re-select "Foreach File Enumerator" and the options will appear.

I'd just use a For Each File Loop with Filename*.txt as its filter.

There's a tutorial here - it was written for 2005, but the process is the same for 2008

Jeff Moden (9/13/2012)

---

I agree. There are enough distinct values where if one of thhe values was a mile, the toal number of values would be about the same...

Do what? What do you mean by "have no effect"?

Jeff Moden (9/12/2012)

Also, something to be aware of... Books Online is actually incorrect about GUIDs being globally unique (and MS has admitted that fact although I'm on the wrong...

You can't directly create an index on an expression, you can only create indexes on columns.

However, you can achieve something similar using a computed column and indexing it. E.g.:

ALTER TABLE...

I suspect that altering the column to another data type internally requires that ANSI_WARNINGS be set to OFF, so it's overriding the setting.

In your case, you should be dropping all...