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...

What that means is that rebuilding indexes doesn't change the distribution of data and therefore the ALTER INDEX REBUILD operation itself doesn't make the statistics go out of date. ...

Lian

Be careful with missing index recommendations. They only suggest indexes that would improve performance on individual queries, not on the workload as a whole.

Adding an included column to an...

The config file does not (directly) affect the connection string in the child package. The child package inherits the value of a variable from the master package. You...

belowery (7/15/2013)

---

david.wright-948385 (7/15/2013)

---

belowery (7/12/2013)

---

That's one of the things I think about when I do get frustrated and think of leaving. I know I won't get that from the start any...

The object ID is only unique within each database. Are you sure you're querying the correct database? By the way, sysobjects is only included for backward compatibility. ...

This isn't going to solve your problem, but it may get you in a position where it's easier to solve it yourself.

My advice is to format your code so that...

Is your backup running as a job? Does the SQL Server Agent account have access to the target folder?

John

How often do you ever need to restore from system database backups? If the answer is "not very", I'd only keep the two most recent... provided, of course, that...

This is a SQL Server forum. There may be someone here who knows MySQL, but you'd probably be better posting your question somewhere else.

John