SELECT key INTO temotable from table1
fragmentation does not matter if your SQLServer is performaing random IO. Think about. If your application is performing random 8KB reads who...
I would use a set of mirrored drives for the TLOG of your OLTP database. I would put the rest of the drives in a RAID10. How many spindles does...
Your system seems to be a bit mismatched between processing power and storage. I have yet to order an R900 yet but our current systems we order...
I had some problems moving to 2005 with table variables. I had to change several procs to use # tables instead. Change @TempDataset To...
check out the documents on sp_addpublication http://msdn2.microsoft.com/en-us/library/ms188738.aspx set @allow_initialize_from_backup=true
AS Joe mentioned you I would just create two LUNS and split your database into two files. I would not focus too much on how myspace has their...
Adding this complexity gets you what other then placing one table at the outer edge of the disk? Chances are queries need to join this large table...
Ok, leaving out the raw partitions is rather significant…<br /><br />Anyhow this “real dba†needs the ability to perform online DBCC check...
Ok lets look at an example based on your strong preference of “On each external rack, my strong preference is to make 2 array groups of 6-7...
“Then on each array group, create 4 partitions. The first partition is for the most active main database file group. The second partition is for...
I would do one of the following 1. One RAID10 across all drives 2. One 2 drive RAID1 for TLOG of your main DB, one RAID10 across 14drives. Bert
You can use the following workaround for this issue. 1) Stop the Performance Logs & Alerts service from services.msc 2) Open up the registry editor...
DECLARE @tableName sysname DECLARE @indexName sysname DECLARE @columnName sysname SET @tableName='Categories2' SET @indexName='PK_Categories2' SET...
I am interested at looking at these numbers but they are a bit hard to read….do you have the original SQLIO output files that you can provide?...
New KB article on the subject http://support.microsoft.com/default.aspx/kb/322385 Bert
I also performned tests on Cluster size . I tested the following 4KB 8KB 64KB I ran 2 tests 1. 8KB Random reads 2. Mixed workload that...
I would also review the following http://support.microsoft.com/default.aspx?scid=kb;en-us;329204...
I would not owrry about Physical fragmentation too much unless you have large amounts of Sequentail access. For my DBS I have mostly 8KB Reads and...
so for DAS you have 6 dedicated spindles.... but with the SAN you need to share 12-14 but shared with others?....I dont know if I woudl like this....
Separate names with a comma.
