TravisDBA (4/26/2012)

---

I agree, because in the end it makes you more marketable in the work place. However, in todays work place SARBOX standards tends to demarcate job descriptions a...

I have rewritten the explanation. Thanks for pointing out the issue.

I have also contacted the author.

Anyone want to tackle a semi-complex reporting / accounting issue?

http://www.sqlservercentral.com/Forums/Topic1290025-1291-1.aspx#bm1290373

Thomas Stringer (4/26/2012)

---

I think what is so wonderful about databases and data as a profession is that we oftentimes are the JOIN (if you will) between the high-level software (applications,...

Matt Miller (#4) (4/26/2012)

---

True, but in order for most of the heat recapture plants to work viably, most of them have to be very local (basically on-site or the heat...

Better, though I've formatted the code. There are formatting items to the side of the edit box that make it much easier to read.

FirstDay - First day of the year?...

In Syracuse when I lived there, the waste heat from a fossil fuel power plant (in the form of steam) was used to heat some university and local buildings.

In a...

Mirroring just moves the log data from one to the other, so there's no replication. It's a replay of the same transactions from the primary on the secondary mirror. When...

ROFL

Congrats on passing the knowledge exam. Sorry the lab was a hassle. Good luck in the future.

Greg Edwards-268690 (4/25/2012)

---

VM is wonderful until you hit a resource constraint. Then you find out how much they really know about what they have done. Very different to trouble shoot...

I think you need to rewrite this to explain it a little better. You are rambling a bit in the explanation of what you want to occur and it's not...

Nothing moves user accounts over. Clustering is essentially pointing two servers to the same set of physical data, but if there's a disk issue, you have no failover, only fail.

Mirroring...

These errors are conversion errors. Somewhere your data contains a value that is not compatible with the float type.

I don't see anything in that code that would cause it, so...

You might also look at SQLSentry's PErformance Advisor. Not sure if it does what you want, but it can be helpful in analyzing issues.

No matter which tool you use, ultimately...