I also didn't understand what would happen if I didn't use snapshot isolation with my Change Tracking process, but this helped.

http://technet.microsoft.com/en-us/magazine/ee914612.aspx

Have you tried deleting all the indexes right before the bulk load and recreating them afterwards? That probably wouldn't explain the difference but it should speed things up substantially.

Are you using them as clustered indexes?

Seems like you should wait the week it will take to generate the 30 billion rows and then see what happens. Also, make sure you use NEWID if you're...

Do you see table locks occurring, is that why you can't read from the table when the insert is happening?

Funny I never noticed before. Thanks Gail.

I've seen performance issues come up because of some trace flags that were set or acted differently between versions, e.g. 4199 and 4135. You might try playing around...

Strange. What version number of SQL Server is it?

I had the same confusion, so I'm glad you didn't "recall" the post. 🙂

Thanks all, that helps a lot. I could easily create a report for it but I'm trying to give my users a single place where they can get all...

Thanks Chris, I had read that page before and it does not answer my question, but you have helped. In my case I think the Customer dimension should be...

Did you ever figure this out? I have the same problem.

I'm on SQL 2008 R2 (10.50.1600) and I just created a filtered index with "MyColumn IS NULL" as the filter and my queries appear to be using the index when...

I would also like to know how/why rebooting doesn't seem to flush the cache. Thanks to the OP. 🙂

I'm having a similar issue, but my hunch is that it has nothing to do with SQL Server. I'm getting SQL timeout errors in my ASP.Net logs, but always...