Viewing 15 posts - 42,706 through 42,720 (of 49,571 total)
I don't think I'd use 50. It'll have the same problem as 5 - poor write performance due to the parity stripe. Each write may incur up to ((no of...
December 2, 2008 at 6:50 am
You say partitioned. How many physical drives are we talking here? Raid? SAN?
If you want perfect...
Log file on RAID 10 dedicated array
Data file on RAID 10 (preferably) RAID 5 (acceptable)...
December 2, 2008 at 6:44 am
Tran log growth is hard to predict. As well as the data, there are log headers, internal allocation pages that need logging, etc. Plus, if there was other stuff also...
December 2, 2008 at 6:38 am
Linked servers and remote queries are an excellent way to slow things down.
Why do you want to split the DB up? If the hardware is correct, the design is good...
December 2, 2008 at 6:36 am
sal527 (12/2/2008)
December 2, 2008 at 6:30 am
hemanth.damecharla (12/2/2008)
No errors 😀 :w00t:
Excellent!
It may be an idea to run checkDB a little more frequently. Weekly, if you can afford the time, otherwise do some databases one weekend,...
December 2, 2008 at 6:12 am
Depends what you mean by a DBA. If you're taking about someone that watches jobs, runs backups and deploys changes only, then maybe their job will disappear. There's a lot...
December 2, 2008 at 3:20 am
rajeevtenneti (12/2/2008)
a development dtabase a db of 40Gb with 38GB data takes 37GB on...
December 2, 2008 at 3:15 am
Don't use the database migration wizard. That's a really long way.
Take a backup of the SQL 2000 database and restore it on 2005. Once you're restored, rebuild all indexes and...
December 2, 2008 at 2:49 am
Can you backup top the local disk and then copy the backup to take.
we are currently using mssql2000 !!
Please post SQL 2000-related questions in the SQL 2000 forums. If you...
December 2, 2008 at 2:46 am
What about the other index, on OUTP_54?
December 2, 2008 at 2:42 am
Ok...
I think that this whole mess can be fixed by dropping and recreating two indexes. I'm not going to promise it will, I'm a bit unsure of the meaning of...
December 2, 2008 at 2:16 am
It's a built-in function that returns a resultset of the records currently in the transaction log.
December 2, 2008 at 1:45 am
hemanth.damecharla (12/2/2008)
p.s. (unrelated to the corruption)
Why are you shrinking your database on a regular basis? Databases tend to grow as more data gets put in them. It's in their nature.
Not...
December 2, 2008 at 1:44 am
The SQL 2005 parser is a lot stricter about what it considers valid SQL. Technically, that syntax isn't valid, but the 2000 parser would accept it, even though it could...
December 2, 2008 at 1:39 am
Viewing 15 posts - 42,706 through 42,720 (of 49,571 total)