Thank you Jeff Moden kind's help!

your post is very valuable and helpful!

Thank you Erland Sommarskog kind help!

Yes, Fetch is also a T-SQL Statement, and fetch is used for a cursor, and I just now to know which select statement  is associated...

Thank you andreas.kreuzberg,  I created a new user and set those permissions as you mentioned then it works fine.

before a created a user like this one and I set all...

Thanks Joe Torre and ZZartin kind help and patience !

yes, I know there are some information in sys.dm_db_index_usage_stats, but how to evaluate this index is useful or useless based on the information of sys.dm_db_index_usage_stats? and is there any other...

Thank you Erland Sommarskog for your kind help! and waiting some experts for detailed explanations.

there are many confusions for me aside from ones mentioned above. when thoese stored procedures called,...

Many Thanks  Grant Fritchey  and MVDBA !

ok, thank you Grant Fritchey!

Thanks  Grant Fritchey and  MVDBA!

if I use transactional replication or  to fulfil this requirement (sync data from OLTP database into OLAP database), how about the latencey of them?  thanks

one more question of Extended Event of SQL Server 2008,  I used the following scripts to  generate the captured files in SQL Server 2008, how can I read these files...

Thanks MVDBA and Grant Fritchey  for your time and good advice.

Very Sorry for no repond for a long time!

We have one ERP system, one SQL Server database is an OLTP...

if I set "set STATISTICS IO on" , and execute  one SQL Query statement it shows as below, can you say it took 1767*8kb memory when runing this state ?...

Dear Grant Fritchey, thank you for your kind and patient assistance,

I know you are an excellent expert in database. Thank you for your valuable advice!

Sorry to bother you again, can...

Thank you Grant Fritchey for you kind and patient assistance !

thank you for your help!

Hoping to get an answer  here.