Thanks for the explaination. I talked to a net programming buddy of mine here, and he said to always use the col index, so I'll have to show him your...

GilaMonster (2/12/2011)

---

amenjonathan (2/11/2011)

---

I also use SELECT NULL.

Personally if something is faster and there's virtually no complexity difference, I use the faster version. Why waste where there is no need is...

Tom.Thomson (2/11/2011)

---

amenjonathan (2/11/2011)

---

I didn't have time to read all the posts but here are a couple more I didn't see in the first couple pages:

1. If a column is added...

I didn't have time to read all the posts but here are a couple more I didn't see in the first couple pages:

1. If a column is added to the...

I also use SELECT NULL.

Personally if something is faster and there's virtually no complexity difference, I use the faster version. Why waste where there is no need is my motto.

I've never embellished or lied in an interview or on my resume, but I'm definitely done being intimidated by job requirements on postings. So many times they list everything and...

Plus if you change the log backups to once per hour, you will not need as much space and should be able to shrink the log at that point.

Ah thanks for the correction Ken.

So the log will truncate at the first backup after the Full back. Why it doesn't do it at the Full seems a bit weird,...

After a full or log backup, the transaction log will be emptied out, but the log size remains. This is so the database does not need to grow the file...

Instead of NULL, create an 'Undefined' record holding key 0. Makes life much easier. In my warehouse I have set up the keys to start at IDENTITY(0,1) for this reason....

The time change is the exact reason I perform GETDATE() at the beginning of any proc it's needed in. That and IMO it's best practice to increase performance any where...

Thanks, Gus.

Just wanted to post back to this thread that I finished my blog post on handling hierarchies in slowly changing dimensions. If I've misquoted anyone (especially Gus) please let me...

Agree with others. Better way to solve this is have dev, test, and prod environments. DBAs do code review after developers have submitted code for test. No developer should...

mishaluba (12/14/2010)

---

Thank you for the responses, but I was thinking more along the lines of slowly-chaning dimension, rather then audit/logging. In one of the earlier comments Jeff Storm showed...