Yes, it is already set to 50.

I want to do this because dbcc command waits for very long time with waittype CXPACKET, when I tried running it with MAXDOP 1 all the wait time is gone...

http://www.sqlservercentral.com/blogs/dknight/2012/05/16/upgrading-packages-to-ssis-2012/

Cool, I was not aware of it. Thanks Anthony.

Ratheesh,

I am confused, how sysadmin is related to default schema ? can you please elaborate.

"Type" and "Run as" value of the new job step is same as the job which is working fine ? can you provide the job script ?

see if this is...

I agree, you should use two part name [schema].[object_name].

why you should use 2 part name ?

Consider a scenario where you are searching for a table that doesn't exist in...

you can remove the mapped drive using Remove-PSDrive, example below removes mapped drive "S"

Remove-PSDrive -name S

If possible

- switch recovery model of the database to simple before starting rebuild and switch to full once done ?

- Partitioning may also help where you do have option...

Make sure antivirus is not holding lock on the file, I remember seeing this alert when mdf files were not excluded from antivirus scans.

If it is not the case, Use...

If you need to rebuild all indexes on a table, why don't you create new table and port data to new table in batches to limit log file growth.

1. rename...

I tried to run rebuild on my system and it worked fine, listing steps so that you may see if you missed anything. Note that my sql version is sql...

Have you tried using powershell to map the drive ?

here is the general syntax, this will Map drive with name "S" to the path \\server1\share

New-PSDrive –Name “S” –PSProvider FileSystem –Root...

what is the structure of the table which stores the query to be executed ?

Few questions

- Queries needs to be executed on different database ? If yes, then I may...

I believe it's a technical forum where we are discussing and helping other to find out a resolution. At times we may not very sure about the things and experienced...