Good catch Craig..

So basically it is ALL manual using Windows Scheduler and something like BCP to copy the data. That is painful..

CEWII

Mark F-428640 (1/25/2011)

---

Thanks Elliot for your response. I would be actually moving the development to the actual dev machine. The machine I am using now is just in...

Well those are some pretty messy requirements.. Ok... Keep in mind supporting express also limits database size so we will have to keep that in mind too.. ...

duncfair (1/25/2011)

---

---SNIP---

1.) We are using a 3rd party tool.

2.) This is beyond just adding indexes(indices); I think I need to create a separate reporting database with some denormalization and...

Four points..

1. You are losing decimals to the left of the point, I would only do this IF I had verified MYSELF that there is NO data that will...

Well, that sounds like performance tuning your report queries. The simplest means are only return the fields and rows you need to generate the report and tune the query...

I would think you could narrow it down without a lot of trouble with just a little sleuthing..

Does it happen overnight or just during the day?

Are...

I'm not sure why you need to develop it ON that server to begin with. You can develop it from anywhere. And as GSquared pointed out, connections are...

I have seen this problem many times in SSIS and .Net, it really comes down to the provider not being able to pick out where to replace the parameters in...

For the code I have posted here I hope that it is reused to make a system better and I do pray that it is more than a cut/paste job...

Not to sound trite but the error message says that the user is unknown, its right there in the message.. This often means that the login failed. Since...

Absolutely right.

CEWII

Scott,

I don't have a solid answer for your question, I would say that it probably is 2TB per.

However the number of installations that even remotely approach that size...

Why don't you explain what part of it didn't work. The "it didn't work" response doesn't really help us help you..

CEWII

I wanted to clarify something, in MS SQL Server there is NEVER more than one tempdb. Now, based on your question it appears you are talking about number of...