thank you for your kind help! I'll study it

and I also find that it can't parameter value...

actually,  the user ( bit\pqscott)...

thanks Mr. Brian Gale and Jeffrey Williams!

I tried to use  proxy account, the setting as the pictures, when I created a job and executed it, the error message as below:

Executed...

Grant Fritchey and Jeff Moden, Thank you for your kind help ! much appreciated!

Also, don't set the max of SQL Server to max of the system. You have to leave room for the operating system to have memory as well. While you...

SQL 2008R2 Standard Edition can only use 64Gb of memory, Enterprise Edition can use all of the memory available on the server.  If you can upgrade to 2016 or...

Dear Jeff Moden,  thank you for you kind help!   what you said is quite right.

if I ran it on the same server, sometimes it works fine, but sometimes not , ...

thank you Jeffrey Williams, the table has clustered index,  but  when I used "alter table oldtable rebuild" , the table released a lot space, many thanks!

when I did this operation,...

in SQL Server, which operations will use more CPU resource? it seems that compilation and recompilation will lead to high CPU workload. are there any other operation will...

You can't really track user behavior through the logs. Without specialized tools, you can't view the information in the logs. That's really not what the logs are for. It's...

FWIW, here's the worked solution, so folks at home can play along...

use tempdb;
go

/* setup script */CREATE TABLE LineItem(
LineNum int not null,
ItemNo char not null,
Qty tinyint not...

Yes, I have learnt...

there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for each item and want to the totalqty shown as below...

OK, next...

big thanks !