I am told the original database and tables have the Spanish collation, I don't have access to the original database to verify.

I guess I wasn't sure if the...

GSquared (12/16/2010)

---

Format inputs in ISO style, and you won't have any problem with it.

Are dates being fed to the database as strings, or as date-time data? How does the...

PaulB-TheOneAndOnly (10/13/2010)

---

Do you have a ticketing system to track changes?

Is there an established weekly Change Management call...

Perry Whittle (9/22/2010)

---

from memory you need port 1434 UDP and TCP. Can you not configure the application with the server name\IP and port number like so

Myserver, 1933

or

192.168.29.28, 1933

Just open...

Right. I'm not necessarily looking for a fix to the problem, just ideas about the cause.

It has happened twice to the same database on the same drive. Before...

I should also mention that I can not create any of my own indexes on the tables, because it voids the support.

I don't think that the tempdb is the problem either, but the vendor recommended that we add more tempdb data files to see if it helped the process at all....

I created 7 more temp files, for a total of 8, on the server in question last Friday. The long calc job ran over the weekend; there was...

david_wendelken (8/24/2010)

---

You had it right the first time, I just misread what you told me.

Thanks for taking the time to slap me upside the head and tell me to pay...

The only way I got the views to show up in SSMS under "Views" was to grant the user "View Definition" rights at the database level, not at the individual...

I think I granted "View Definition" privileges at the database level.

Right click on the database name >> Properties >> Permissions >> Add the user that needs to see...

CirquedeSQLeil (8/17/2010)

---

The database is not too terribly large. This would lead to me question the process that is running and taking 40hrs. Number of records being processed and...

Over 400 GB...

Also, thanks for the suggestions 🙂

I agree, but the vendor is grasping at straws here.

The same vendor told me to disable auto create/update statistics on their database. Oh boy...