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 !

I don't understand what you're asking. You can make batch calls from code, almost exactly the same as calling procedures. You just change the command type. SSMS is also...

Here's a code sample showing how C# calls a stored procedure. Compare that to 'EXEC dbo.MyProc' in SSMS. One is a remote procedure call. The other is a...

1. if one stored procedures includes many pieces of SQL Statements and when the stored procedure is called , then The Reads of RPC:Completed includes all the reads...

So which row in the trace are you...

the events I captured as below

Stored Procedures

RPC:Completed

SP:StmtCompleted

TSQL

SQL:BatchCompleted

I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found its...

the “Reads” of SQL Server profiler is the times of the logical read?

• This reply was modified 3 years, 3 months ago by  892717952. Reason: mistyping

I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found its logical...