28GB sounds ok for max server memory if this is a DB server.if you have allocation contention on your tempdb data file try with increasing tempdb data files to 1/4...

yes check this out:

http://msdn.microsoft.com/en-us/library/ms345408.aspx

Raid 10 is a better option if you have enough disk space.The write are done faster on raid 10 beacause unlike raid 5 there's no need to calculate the parity.So...

First you have to take a Full backup and then You can take Log backups

Thanks

So there's no difference between using DROP_EXISTING=ON,ONLINE=OFF and dropping and recreating a non-Clustered index .Is there?

Of the top of my head you can check the data types of columns.I have seen so many times that column's data type is set to INT for storing very...

As a general guideline if the sum(signal_wait_time_ms)/sum(wait_time_ms) is more than 20% it could be a good indication of CPU bottleneck if that's what your looking for.The signal_wait_time_ms shows how...

GilaMonster (8/10/2012)

---

pooyan_pdm (8/8/2012)

---

And about the update I don't know what you think of a index key update but it' effects on page splits and fragmentation is the same as...

No I don't think so

from MSDN:

This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system...

Lynn Pettis (8/9/2012)

---

pooyan_pdm (8/9/2012)

---

you van use rowmodctr column in sys.sysindexes to check the number of rows inserted,updated or deleted in the index since the last time stats were updated on...

I know it does not make that much scence but try backing up the log two times in a row it might help

you van use rowmodctr column in sys.sysindexes to check the number of rows inserted,updated or deleted in the index since the last time stats were updated on that index.from SQL...

run select * from sys.databases and check log_reuse_wait_desc

you might have an active transaction to check that you can use dbcc opentran('DBName')

What I said is a general guidline and is true, yes with a ever increasing key the inserts does not cause the fragmentation but generally speaking beacuse most of the...