12 May 2024
後來反覆測試發現到 36 萬字多還可以，40 萬字就不行了，會拋例外
後來慢慢可以理解，如果某查詢條件下資料 2 筆，2 萬真的也還好，但這種串 id 組成 in 的做法，id 長10個字，串出 20 萬字的語句就是很自然的結果😂
可能 40 萬字的語句在等了 30 秒後拋這個回來，SqlProfiler 停止回應
9 May 2024
老專案組 SQL 語句有很多這種
String where = "id in (' ' ";
for(int i = 0; i < data.size; i ){
where = ", '" data[i].id "'";
}
where = ")";
直到今天一個客服反映查很慢，和同事追蹤下去發現應用程式送出了20 萬字的 SQL 語句………
1
5
711
28 Mar 2024
Need to dig deep into #powerbi dataset refresh performance? #SQLProfiler technique might help dhyanintech.medium.com/how-t…
2
57
5 Oct 2022
SQL Server'da,
SQL Profiler ne demektir?
Trace almak ne demektir?
#hergüne1sqlbilgisi #sqlprofiler
1
5
93
8 Dec 2019
SQL Profiler ne demektir? Trace almak ne demektir?
#hergüne1sqlbilgisi #sqlprofiler #sqltrace #tracealmak
#sql #sqlserver #sqlservertips #mssql #tsql #sqladministration #dbManagement #veritabanıYönetimi #sqlperformance
#ocolakoglu #udemysql
6
31
Implementing a manual #SQL Server Audit w/ @AhmadZYaseen #SQLAudit #SQLProfiler
sqlshack.com/implementing-a-…
5
11
Interested in optimizing and troubleshooting SQL
Server database from a development perspective? Look no further. Here's an article that covers some of the tools for monitoring SQL Server #dashboardreports #activitymonitor #sqlprofiler
bit.ly/2L03MVx via @SQLShack
10
20
28 Mar 2018
Monitoring Specific Table Using #SQLProfiler by Pragya Nagwanshi cc @CsharpCorner goo.gl/CLcHGq #SQLServer
7
12
25 Jun 2017
2
2 Oct 2016
Trace #Database Transaction Using #SQLProfiler by @Bhuvaneshmohan cc @CsharpCorner c-sharpcorner.com/article/tr…
8
9
28 Sep 2016
Volvemos del verano con un nuevo Meetup por @PJBonillaSilio que te hará olvidarte un poco del #sqlProfiler y tenerlo todo más bajo control
27 Sep 2016
5
2
6 Sep 2016
Trace #Database Transaction Using #SQLProfiler by @Bhuvaneshmohan cc @CsharpCorner c-sharpcorner.com/article/tr…
15
13
28 Aug 2016
Trace #Database Transaction Using #SQLProfiler by @Bhuvaneshmohan cc @CsharpCorner c-sharpcorner.com/article/tr…
3
9
20 May 2016
Trace #Database Transaction Using #SQLProfiler by @Bhuvaneshmohan cc @CsharpCorner c-sharpcorner.com/article/tr…
5
12
26 Nov 2015
1
23 Feb 2015
BLOGGED: Book Review: Mastering #SQL Server Profiler by Brad M McGehee @redgate samabraham.net/book-review-m… #sqlprofiler @RedGateFriends
2
2