Interesting variation on the normal ISNULL-related QotD.

I do wish that the table definition had included an explicit NULL on the column definition though.

Your fact table should always have a Primary Key - whether it is a surrogate key, or based on your...

Quality over quantity 😛 😀 :laugh:

sys.dm_db_index_operational_stats - range_scan_count

http://sqlblog.com/blogs/louis_davidson/archive/2007/08/26/sys-dm-db-index-operational-stats.aspx

http://blogs.msdn.com/sqlcat/archive/2005/12/12/502735.aspx

http://blogs.msdn.com/craigfr/archive/2009/07/29/correction-to-my-prior-post-on-sys-dm-db-index-operational-stats.aspx

Seems like a pretty fine reason, right there 😛

Christian Buettner-167247 (4/6/2010)

---

Well, this would not be the first time that there is incorrect documentation out there in MSDN. From what I undestand, the schema lock is aquired to...

yingchai (4/6/2010)

---

I'm not so concern about the I/O performance as I predict the Cost fact table will grow to approximately 1 mil records in 10 years. Currently, the database server...

Good. Consider modifying your script to only...

Jeff Moden (4/5/2010)

---

Stop. It's a waste of time to do...

It is important to fix this, from a recovery point of view, but I doubt it is affecting performance much.

As for the code, I know...

Marts (4/5/2010)

---

On our current setup without any modifications, I could move the logs and/or the tempdb to the system drive (raid 1), away from the data files. Would you...

This is not a triangular join in the traditional sense (assuming the correct supporting index exists) since the APPLY results in a single-row seek per input row, not an aggregate...

Bill Kline-270970 (4/5/2010)

---

I guess a profiler trace is in order to verify if these procedures are the source of the waits due to locks. I will also research sp_getapplock...

Garadin (4/5/2010)

---

I think figuring out the right stats to pull is a big part of it. Any tips anyone has to this regard are welcome. I'll probably do...

Jeff Moden (4/5/2010)

---

Actually, they are. From Books Online:

If an application must generate an identifier...