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

Try rebuilding the clustered index on Table1 and updating statistics. You'll probably get 50/50 then. The index on Table1 is fragmented since you inserted the data after creating...

Check this out. You can then use the variable to set the ConnectionString property of your connection...

http://msdn.microsoft.com/en-us/library/ms188283(v=sql.100).aspx

One configuration option is to use a parent package variable in each of the packages that is called from your master package.

John