RAID 1 for tempdb is a new one on me. I would be curious as to the rationale.
Third party products may be certified on SQL 2005 but not on SQL 2008. That is our situation.
"...how did we ever survive before cell phones?"Just fine.
Use Read80Trace.exe. You can download it from...
Joe: Pulling it all together. John Langston Cimarex Energy Co. Tulsa, OK
Joe: I tried changing the max degree of parallelism to 4 and it had no impact on elapsed time. The elapsed time for last night was two minutes off...
Joe: SQL Statistics: Batch requests/sec: 1st day after HW changes avg 93, max 733, 13 hr period - 6 am - 7 pm (main user activtity time) Today...
Luis, Guess I am not following what is meant by "more statistics than before". Auto create is on, but there have been no additional indexes or...
Main production server is running SQL 2000 EE 64 bit version, SP3, Itanium CPU's. We run a niche ERP application (do not have access to the source...
BTW, my primary is an IA-64, my secondary the EMT (x64). Both run 2003 Advanced Server (X64 on the secondary server). John Langston Cimarex Energy...
Satya, If I understand your question, the only error that appears in the sql log is 14421 "The log shipping destination CECTULDSS.cise_Production is...
I am using SQL 2000 log shipping and all was going well until we had an outage. After the outage the last file copied, last file loaded values do...
Joe Chang mentions the use of task manager, which I have found to be useful in the 64-bit world. Under the task manager processes tab, 32-bit...
I figured as much. Thanks for the feedback Joe. John Langston Cimarex Energy Co. Tulsa, OK
It might seem like a silly question but when you walk into a new shop, is there some way to know for certain what RAID a server running SQL 2000 is...
Separate names with a comma.
