Add the service account of the SQL Server DB Engine to the network share where the backup is located. Grant the access rights to the account. Try recover...

You will notice that the second approach is faster when you are running this query for selecting a larger recordset.

Thanks

Suresh Ramamurthy

It's possible that your team lead merged the existing partitions and dropped some file groups / or shrunk the datafile after merging.

Thanks

Suresh Ramamurthy

Use the combination of sp_add_job_step and @command option with dynamic SQL. Have provisions for creating and dropping them(job steps) at runtime. It will be possible.

Thanks

Suresh Ramamurthy

Basically any index with fillfactor 0 or 100 makes no difference. In such case every new record insert will create a new page. Ideal is to have values...

Please check the values in RSReportServer.config for

the specific entries are the MaximumMemoryLimit setting and the MemoryLimit setting in the tag.

Also, check the machine.config for values in .

These settings play...

AWE is mainly to enable SQL Server to use memory beyond 4GB in 32 bit systems(OS). If the OS is of 64 bit one, AWE has no effect.

Moving to...

Did u use DBCC UPDATEUSAGE before running sp_spaceused or atleast used the @updateusage option?