Okay, I think I may have found an issue with FK enforcement. I posted it on the SQL Server 2008 forums, here. I'd appreciate all you smart folks...

Nadrek (8/25/2011)

---

Jack Corbett (8/24/2011)

---

Well, still working on it. Added an index and that took 15% off.

The real winner is disabling and then re-enabling the FK's. There are 48...

Can you post a link to the forum? I'd like a more in depth explanation and if I go there I can ask.

Thanks

Interesting that this editorial comes up now as my current project is to design a purge of older data. I'm not archiving any of the data, but the needed...

Good article Wayne. Clear and concise examples. I'm looking forward to the running totals ability.

travis.vandyk (8/25/2011)

---

Well not all the users, some access the data warehouse via Access.

On another blog someone suggested possible corruption in a table and Im starting to think this was the...

Could you share what you found? Others are probably having the same problem and if you share how you solved it they won't have to look further than this thread....

I think that is because .NET is taking the null which is ASCII 0, I believe, which when converted to a .NET DateTime is 1/1/0001.

Since this keeps the SQL Browser service from exposing it, I'm going to say that your application will need to provide the port in addition to the server name/IP Address.

No it is not. When a report is more than one page you need to use the paging capability.

What is the scope of the variables?

If you put a script component between the destination and your error output CSV you can get the description of the error. Here's an article[/url] that talks about this.

If all the columns are used together in where clause then it is likely a good index. You can check sys.dm_db_index_usage_stats to see if it is used and how...

This article isn't exactly what you want, but you can probably use it as a starting point

Are all the users using SSMS? This looks like an Intellisense query.