Those links don't work for me. The code you posted will do the job, but it'll rebuild every index in the database regardless of how fragmented it is. ...

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

John

L' Eomot Inversé (7/22/2013)

---

John Mitchell-245523 (7/22/2013)

---

kapil_kk (7/22/2013)

---

Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will...

kapil_kk (7/22/2013)

---

Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will reorder of the data in...

You have a date stored as varchar or similar and you want to check it's a valid date?

Two options - the first being vastly more preferable:

(1) Don't store dates as...

ALTER DATABASE MODIFY FILE (....)

If you don't know the syntax, you can search for it. Or you can just use the GUI.

John

Sounds like your stored procedure is making more modifications than there is room for the transaction log to record. If that's the case, rewrite the procedure so that it's...

We're not here to do your work for you, although obviously we're happy to help out if there's anything in particular you don't understand. Therefore please will you show...

Ah yes, hadn't thought of that. I guess that behind the scenes it creates a new column and copies the data across - something to bear in mind if...

GilaMonster (7/18/2013)

---

Other way around.

When an index rebuild is run, the statistics on that index are updated with fullscan as part of the index rebuild process. It's not that the rebuild...

Quite difficult, if you don't have anything to compare your results with. I suppose if users are happy, performance is acceptable. I would recommend monitoring Disk Reads and...

You don't need to. The restore will create an exact copy of the database, including filegroups.

John

I prefer to have one job per database, in case I want to back up databases individually, but that's by-the-by.

If I were you, I'd make some enquiries about the vendor's...

To add to what Koen said, 4 uses sysobjects, which, from SQL Server 2005, has only been included for backward compatibility. Some of your statements test for the schema...

Koen, are you sure about that? You can add a new column with an identity property, but I can't see any way of adding the identity property to an...