Viewing 15 posts - 43,951 through 43,965 (of 49,571 total)
Do you have any access to the database at all? If so, please run the following at regular intervals (every couple hours) and see which values are changing the fastest...
October 8, 2008 at 2:28 pm
Direct attached storage, SAN, NAS, network drive?
Is is a clustered server? If so, is the E drive a dependency of SQL in the cluster admin?
October 8, 2008 at 2:25 pm
None of the above. You've got database corruption. Please run the following and post the results.
DBCC CHECKDB(< Database Name > ) WITH NO_INFOMSGS
October 8, 2008 at 2:23 pm
How many processing cores did the old server have, how many does the new one have?
SQL Server's max memory setting. Configured under server properties (object explorer in management studio) or...
October 8, 2008 at 2:21 pm
Ray Mond (10/8/2008)
October 8, 2008 at 11:59 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic582765-148-1.aspx
October 8, 2008 at 11:59 am
What are the specs of the two servers (memory, disk)?
What's the max memory setting on the new server?
October 8, 2008 at 11:56 am
If the fragmentation is low (< 30%) then reorganise instead of rebuilding. If you can, switch the DB into Bulk logged recovery for the duration of the rebuild. Index rebuilds...
October 8, 2008 at 11:55 am
The fastest way would be to buy a copy of SQL Refactor (from RedGate). Otherwise you're going to be spending hours doing replaces of the various keywords and fixing any...
October 8, 2008 at 9:31 am
Not enough information to say anything useful.
What were the specs of the old server. What OS, what version of SQL?
What are the specs of the new server. What OS, what...
October 8, 2008 at 9:29 am
TheSQLGuru (10/8/2008)
1) Can anyone give me some justifications for the apparent agreement that table variables should be used for 100 rows??
I use it as a rough thumb-suck of...
October 8, 2008 at 9:23 am
Lynn Pettis (10/8/2008)
October 8, 2008 at 9:12 am
Dugi (10/8/2008)
October 8, 2008 at 8:31 am
Is there a chance that this DB ever was published in the past (transactional replication)? Could it have been restored/moved from a server where there was replication?
October 8, 2008 at 8:24 am
SQL 2008 allows 30000 columns if a table is 'wide'. A wide table is one that contains a set of sparse columns (defined as a columnset, see Books Online for...
October 8, 2008 at 8:22 am
Viewing 15 posts - 43,951 through 43,965 (of 49,571 total)