What is the value of the CommitBatchSize parameter of your distribution agents?  Try making it a bit smaller to reduce contention for resources in the distribution database.

John

select EmpID - MinEmp + 1 as Sno, EmpID, e.Dept, EmpName

from Emp e left join (select Dept, min(EmpID) as MinEmp from Emp group by Dept) g

on e.Dept = g.Dept

Have you checked the default language for the user's login?  I've seen situations where some logins have English and others have British English, and this can cause differences in the...

If you're looking for the growth of the data file itself, rather than of the data within the file, you can look through the SQL error log for file growths......

You only need ports 443/445 if you are connecting using Named Pipes.

Pedro

Do you get those messages if you use sqlservr -m to start SQL Server?  If so, then I think you do need to rebuild your master database, and then restore...

Nirmal

You're going to have to help me out with some error messages... right-click on the job and choose View Job History.  Tick the Show step details box.  Click on a...

Nirmal

What is failing - the building of the string or the actual restore of the log?

John

Or this - not tested this so probably full of errors, but you get the idea.  Cursor probably not strictly necessary.  As it's a one-off update I don't think the performance issue...

Nirmal

It's not the job that's the problem - it's the SQL within the jobstep.  You need to change it so that it includes some error handling that will make it...

Michelle

Have a look here - this will give you some ideas on what sort of thing to monitor.  You can then add extra counters if you think they will be...

Yes.  Binary sort order is the fastest (but probably the least useful).  From BOL:

"Sorts and compares data in Microsoft® SQL Server™ tables based on the bit patterns defined for each...

Bill

C:\Progra~1\Micros~1\MSSQL\Backup\MyDB.bak should do it.  BUT if you already had a folder whose name began with "Progra" or "Micros" when either of those abbreviated ones were created, then you may be...

Fernando

Did you save the query that you used to move the tempdb files?  If so, check that you specified a location that actually exists and on which the account that...

Ronnie

I see what you're asking.  You should use the CHECKPOINT command to issue a checkpoint.  This is more likely to be successful during a quiet period since there will be...