bret.christoe (9/24/2012)

---

I am a bit confused since you indicate your backups are being overwritten. As in - new backup overwrites old.

If you do know that you have a backup...

Thanks a lot

Another case, if I just do a restore of a database from a backup to another database, do I need to do a update statictics right...

Yes. Are rows in these tables modified after the import? If not, then the indexes won't get fragmented, and there is no...

Nils Gustav Stråbø (9/23/2012)

---

As Gail said; fragmented indexes will usually not slow down that much, not like...

Thanks, we are using that script doing maintenance of db, but only on weekend.

Now that reminds me another related question, we have a process nightly to create some tables in...

You may be right, thanks

The reason I ask is I saw actually we have a ETL that seems generated somehow.

In it there are about 30 data flows, from the format they look so alike.

They...

Thanks, I found you can only install one instance of SSIS on it.

The microsoft doc is confusing to say they can co-exist.

This works perfect, thank you!

Thanks, this work perfect.

I do want to delete subfolders, so the second statement works too.

How can I only delete files with extension .txt in above command

Thanks

More help please

Thanks, I figured that out by removing the old 2008 SSIS installation, and the 2012 show up automatically

Thank you all.

I would like to add the command in sql agent job, using operating system(CmdExec).

can I use the command directoy in the code window instead of using a bat...

Any other recommendations to pull more than 1000 rows.

I guess maybe change AD server setting from 1000 to more is not a recommended one?

Thanks

I think you are right, if I give a criterior that limits it to a small dataset, there is no error.

How do you make the query to pull only a...