Be careful; on at least SQL Server 2005 SP3 with a very similar formula, I've seen a very interesting issue where the internal SQL Server rounding results in the ACOS...

Personally, I'd rather have a column which tells me when the data in...

To summarize:

1) Please post the precise statements your script is generating and running.

2) Please investigate your disk configuration all the way down to the individual physical spindle/SSD device level; separate...

Jeff Moden (4/12/2011)

---

"Do not use this for critical things" is an "advertisement"? Not where I come from. 😉

And, yes, I use it for "critical" things.

Anyway, sorry about the...

No, I'm not trolling; I'm advertising your article! The full context was:

-- Quirky update!!! BEWARE!!! Do not use this for critical things!

-- BEFORE USING, read http://www.sqlservercentral.com/articles/T-SQL/68467/

Jeff Moden (4/8/2011)

---

Also,...

Thank you for your response; I'll see if I get the chance to generate sample data and schemas, as well as the two-part SET statement variant.

Setup:

USE tempdb

CREATE TABLE [dbo].[tmp_conf_server](

[RecordedDateTime] [datetime2](3)...

It may be my own mistakes (and I don't have time to delve into it now), but may I suggest further testing on SQL 2008 R2 RTM? While the...

I'd agree with views and indexed views as an option to restructure underlying data.

I'd also note that on the "buy truly excessive hardware" side, there are commodity 4U servers that...

For those with RAID; how many actually run consistency checks on a regular basis, to detect single drive corruption?

For single drives, how often is an online disk check (much less...

UMG Developer (3/28/2011)

---

...

Just try to imagine how they would deal with installing an update while a 7 hour query was in process when they made major changes to the DB...

If MS wants to go with the CU approach, then MS should design the system such that CU's can be applied (and rolled back!) realtime, without any outage. Preferably...

GilaMonster (3/20/2011)

---

I can tell you that few normal workloads are CPU bound unless you've really skimped on the processors or have really poorly written queries, disk bottlenecks tend to hit...

Truly drastic hardware additions and purely single-threaded assembly code optimization are about the only things that are an almost guaranteed performance improvement... and they can expose concurrency and timing flaws...

You could try tracking Profiler along with Perfmon or Process Monitor, to see what's happening at the same time as the growth.

Or, simpler but not as immediately useful, you could...

There are different ways of looking for backup information; one is to use msdb (fails if your server's crashed already), another is to look at the backup files themselves.

Regardless, you're...