-
as seen on Server Fault
- Search for 'Server Fault'
We're trying to export some tables from our production database to our test database using bcp. The bcp export seems to work fine, but the import always fails with a data type error (see below).
We tested on our test database exporting the table content to a file, then importing it in again immediately…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Hi Everyone,
I've recently upgraded my DB2 9.5 to DB2 9.7, and I am unable to update my database to v9.7. The error I have been receiving is this: "SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Packed descriptor corruption…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Hi folks, I have an interesting database problem. I have a DB that is 150GB in size. My memory buffer is 8GB.
Most of my data is rarely being retrieved, or mainly being retrieved by backend processes. I would very much prefer to keep them around because some features require them.
Some of it (namely…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
In programming, there is often a canonical book for a particular topic, like the dragon book for compilers, K&R for C, etc.
Is their a book regarding modern database design that simply must be read by anyone that would hope to eventually design databases?
I'm not looking for a bunch of recommendations…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Hi,
I am looking for a suitable hosting environment for an ASP.NET MVC application. One of the options I have is renting a Hyper-V server and installing my license of SQL Server 2008 on it. I'm a bit wary of shared hosting since the one I have tried so far did not seem to have very consistent performance…
>>> More
