Thanks, here I really mean sql developers not dba,

I'm interesting to be a sql developers too, so just curious what is the work flow and how web developers work...

I see the report of schema change history, I see our report is huge, I export to excel to do some filtering.

If MS can add some filter on the report...

Thanks, the standard report has so many new features I haven't found. I guess thies is recorded by default trace.

Thanks again

Thanks a lot

Thank you, can you point me a link to the article.

That sounds just like what I heard from my former collegue.

He told me it will be a great pain when upgrading- you ignore the collation of older server, and later...

Thank you, but a little bit confusing about below,

when you say, "the only variables that matter are those in the SSIS package itself."

But the variables in dtsconfig matter too, correct,...

So should we just keep the colllation of what the older server have in the upgrade process?

Thanks

It helps a little bit.

But in the process of upgrade server, shall we keep that or change it, I see sql server default is different from what we have, if...

Thanks, this is an index file, does it make difference?

I checked the jobs, I cannot see the one that shrink files.

The only thing I suspect is we do transaction log...

I just got another alert that the database index file 96% full.

I checked the file, it changed back to the original size again.

I repeated these several times, I remember once...

Thanks, I will not do it later in most cases.

I think I am not so clear about DBCC shrink file do.

I thought by doing that will clean and reorganize the page,and leave some unused space at the end...

Thanks,

I did shrink the file manually.

Thank you

Thanks all.

In our case, most of the job owners are the ssis package author themselves, they are not sysadmin, so the job running under their account. And once they left...