https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ - Chapter 4

Normal, fully expected. SQL needs space to put the new index. A rebuild creates the new index then drops the old. So if there wasn't space in the data file...

Not true. You can wrap expressions in as many brackets as you like, makes no difference.

p.s. 3 year old thread.

Restore the database, see how long it takes. Best...

sreekanth bandarla (11/25/2013)

---

OFFLINE INDEX REBUILD should work fine....Online index rebuild reads the old index to build the new one so the new index has the same missing rows as the...

Straight from the article

Frequency of log backups

The frequency that log backups should be done is dependent on two considerations:

The maximum amount of data that can...

Ratheesh.K.Nair (11/25/2013)

---

As mentioned in earlier post the solution is to drop and recreate the index and as far as i know its same as Rebuild but Rebuild wont fix the...

Tran log backups are unaffected by full/diff backups, so you can have your tran log backups running before, during or after the full/diff.

Please note: 3 year old thread

mah_j (11/24/2013)

---

Now this field does not have a default of NEWID(),and the value for this column is generated automatically,not in the application,so as I understood from your reply, if...

http://technet.microsoft.com/en-us/library/bb510680%28v=sql.105%29.aspx

If an insert explicitly specifies a value for a column that has a default,...

Better term for that is 'low page density'.

Inserts and updates can cause page splits, which results in pages half full. Deletes can leave empty gaps on pages where the...

Depends what the book means by 'internal fragmentation'. It's a poorly defined term that has been used for different things by different people.

It's the same data type. No idea if it'll even work. If you specify a default and the app explicitly inserts a value, the default is ignored.

Better option would be...