SQL* (3/21/2013)

---

If there is any corruption while writing the data to PRIMARY File Group's files the database will not available to access. We can make the Database available by adding...

Log fragmentation is described in the article I referred you to.

Yup, restore from backup.

2005 and newer, same as your ALTER INDEX...

DBCC INDEXDEFRAG is deprecated, etc, etc. replacement is ALTER INDEX ... REORGANIZE

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

And chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

I'm getting the string impression, out of his depth and doesn't know it.

http://www.sqlservercentral.com/Forums/Topic1431330-1292-1.aspx

solomon.jernas (3/20/2013)

---

But i want know, this way , thread and cost of query , lazy writer, memory . what are things involve in DML query.. Architure level...

If you're getting recurring corruption (you repair, corruption comes back, you repair, etc), your IO subsystem is faulty, check logs, update drivers, etc. SQL is not in the habit of...

kevaburg (3/20/2013)

---

If your transaction logs are getting big even in SIMPLE Recovery Mode, could it possibly be that you have a great deal of DML occuring without commits? INSERTs, UPDATEs...

Yup, consolidate, that should be one index.

The only counter case for keeping it separate would be where queries that use those indexes absolutely must run as fast as possible and...

clintonG (3/20/2013)

---

Also, I wasn't talking about SQL permissions, you need to lock down the windows machine, limit administrative access, make sure that no one has permissions to the machine unless...

clintonG (3/20/2013)

---

Not to my foreknowledge but I may actually be trying to do a trick niavely as my intent to locate the mdf/ldf files at My Documents > My Data...

That could well be it. Just keep an eye on things, run regular CheckDB and make sure that things remain OK.

There are lots of processes running in the background all the time. Query sys.dm_exec_sessions and filter for is_user_process = 0. That'll show you all the background system processes.

They aren't specific...