Au contraire....:-)

The rules on converting to an INTEGER...

Interesting. I swapped the order of the first two thinking it was more likely - ah well - glad to hear you have it sorted out now.

Thanks!

Grant Fritchey (3/25/2010)

---

Heck better Database Administrator than Database Developer. There's an average $20k difference in their salaries in the US. What I really do is develop databases, but I put...

It's not the title so much - I don't recall ever having DBA as a job...

Aha! Awesome!!! ...

Database Administrator

Anyone else dislike the term 'DBA'?

I am still trying to catch the DBCC commands in a trace - I get the shrink events and a blank DBCC event, but not the thing I am looking...

No worries. I was a little concerned that I had missed your point - and I should not have said 'never' updated...there's always an exception, even if...

or:

select amount

from @sample

where amount = amount / $10000 * $10000

Trey Staker (3/25/2010)

---

They want SIMPLE but they send their databases out the door in FULL or BULK LOGGED. My company assumed, before I came aboard, that they could do...

Well I said it - reference enough! 😀 :laugh:

Ok, ok:

TechNet: Statistics used by the Query Optimizer

A relevant extract:

After a...

I think we both know the (recursive) answer to that.

TheSQLGuru (3/25/2010)

---

Not sure I agree with that. The update stats stuff (even if you go async) can hit performance pretty hard and on a busy/critical system you simply cannot...

Yes, datetime is compressed. One of the best sources I have found for information concerning the internals of ROW and PAGE compression is http://blogs.msdn.com/sqlserverstorageengine/archive/tags/Data+Compression/default.aspx. Loads of great stuff...