That's how I understand it too. In my experience index selection and resolving joins are one of the biggest issues if you don't use openquery()....
Are you using openquery() to communicate with the other server?
http://blogs.msdn.com/sqlserverstorageengine/
bradmcgehee, Can you tell me the name of the view in SQL2K5.
Joe, Why just /PAE without /3GB?
PowerDesigner
From BOL: Reporting Services supports stored procedures that return only one set of data. If a stored procedure returns multiple result sets, only...
Have you updated the statistics?
Can you post the DDL?
Since the data is on a shared disk resource replication is not needed. When the active node fails over to the passive node the shared disk cluster...
A little of topic... I'm not sure the CX700 has the same issue as the CX300 but if so make sure you correct the disk offset when you create your...
I use ApexSQLAudit & ApexSQLLog. Redgate's products are good too.
All things being equal, I always use RAID 1+0 for data LUNS as long as space isn't an issue. If I need more space then I'll consider RAID 5. Check...
I would have expected your RAID 5 sequential results to be the results for the RAID 1+0, and the RAID 1+0 results to be the results for the RAID 5....
Random IO looks normal but WOW on the sequential differences. I would expect the RAID 5 sequential to be flip flopped with the RAID 0+1 sequential.
Only use a GUID if you truly need a globally unique identifier. PERIOD!!!
Thanks!
We're reconfiguring our EMC CX 300 array for SQL Server. The array has 30 drives with RAID 1, 0, and 10 configurations. The apps hitting the db...
Dual core procs are great especially for scalability. They work just like having multiple procs. We use AMD's dual core procs. Performance wise...
quote:Originally posted by FrankKalis Are the INSERTs done sequentially? I mean, do the newly INSERTed rows have a "later" date value than the...
Separate names with a comma.
