Thanks Thomas. I guess this is some kind of way around as Chart Title area is not actually Text box. But you suggest if I am correct to keep Crat...

Thanks guys for your help

Thanks guys for your answers. My main concern regarding local backup is not only extra 5TB (or less in case of compression) of space but mainly overhead from backup software...

Thanks for your responses. My main concern was about system DBs. I played a bit yesterday and found that it's possible to restore system DBs from 32 to 64 bit...

Thanks, Mark. Problem is that this nonclustered index is composite one with 3 columns and first column (id) is in clustered index (PK). Thanks

Thanks, gents, for your help.

Steve: this nonclustered index ncIndex3 first column is the same as clustered index (id). I found some cases where clustered index was used but can not...

Found this on MS TechNet Forum and it works for me:"To do this, edit the SSIS step in Agent. Copy the text from Command Line tab. Switch step to use CmdExec...

Thanks for your answers, Ken 

First of all, I run Package from Management Studio- IntegrationServices-RunPackage. And it's OK. Second, I read regarding selecting job type of Operating system but have no idea...

Thanks guys for your answers.

Markus: we are going to make partitioning on this table, you are absolutely right

Mohamed:I did not kill this procedure- Sql Server did. When tr log became...

Thanks for your answer. I do not know regarding possible rollback time but I know for a fact now that online reindexing is not appropriate for a big table under...

Thanks for your help. It's true but there are couple "buts": 1) when table itself was modifyed this value changed also and 2) when table has some indexes rebuilding any...

Thanks for your help- AutoUpdate Statistics is True. I remember I saw here (Sql Central Forum) answer- returned value something like "modifydate" for each table index. And I used it...

We decided to play (development Sql Server certainly) with files/filegroups to save backup time. Our DB has 34 files (all in primary filegroup) with...

We had same issue- there is no way (I read in BOL) to create standby server in case of primary and secondary servers have different versions (like 2K and 2K5)

Unfortunately I do not have this luxury to uninstall Sql Server as this is production server. Funny thing is that I run SP1 installation in 2 production servers in...