I am getting this error. Did some troubleshooting through Microsoft KB but no resolution. Any tricks for...
I have a couple of projects in place to do table partitioning. I have identified the partition key and working on the range. With 230 million...
I have installed sqll 2005 and restored a sql 2000 database with complvl with 80. Now i did a updatestats and everything possible but the rowmodctr...
Thanks. It made my head spin a few times last night. Glad to know the answer....
Its quite confusing now that I looked at the statstics and profiler on both runs. nothing is changed...
Does someone know why the results in text would take a lot longer than grid?
is window 2003 advanced server = 2003 enterprise edition?
In my experience I have seen such error messages with memory issue to begin with....It will be worth looking at average page life expectancy counter...
Perhaps something of interest is recovery interval setup. Any changes there?
I guess its time to find someone willing to donate chopeen some meory.....512 is for sure not much for a sql and mized use machine
Excellent work Satya. I would suggest that /3GB looked /userva extension in 2003. It helps a lot for system resources.
I agree for HT. Even win2k is not all that intelligent for HT. ONly win2003 is capable of handling complexity of HT. If at all suppport for HT is...
I am just curious to know if the HP/Compaq RAID-ADG (Advanced Data Guard) will pick arbitary number of disks for LUN assignment? IBM does have...
Its one of the common issues in database envoirnment. A lot of times (about 80% and up), the application tema comes and complain that the server was...
If its going to be an active database with a lot of users and transactions, I would suggest to hire an experienced DBA. You could only be Junior to a...
Excellent breakdown Derrick. I will only add the 1 file per CPU for data files rule. On an 8way SMP, dont split your data on more than 8 physical...
I really dont see much of an issue here except that I would prefer data, log and tempdb seperate so to balance the IO. Dont forget your good old...
Also the assumption is that the database has been optimized for disk IO with multiple files for data on SMP server and engaging more disk...
Cant agree more on Derrick's point #1. However, the second choice is conditional. It all depends on your RDBMS. If its an OLAP or OLTP. Both have...
Good. I am glad to hear that....I guess I needed a little positive reinforcement to get my trust back. I am glad that it all went that way though as...
Separate names with a comma.
