sorry , as sql type file is not allowed, adding its txt file

Thank you Erland Sommarskog. I have done some testing based on different cases ,thank you!

Thank you for your patience and help! but I still have some confusion regarding the unique index of idx1. sorry to bother you again, thanks!

if using index hints to use...

yes , this is ...

No you cannot get the true end users computer from profiler (or extended events for that matter) as that is not the computer connecting to SQL.

If you want to...

Thanks Jeff Moden for you kind help!

but it is a web system, there are many user accessing this system thru Google browser at the same time, and Google browser access...

Dear Johan Bijnens,  I want to use a user-defined function to update   some data in physical table if possible, when I searched and got a post, it was said that...

• This reply was modified 2 years, 1 month ago by  892717952.

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,...