https://www.mssqltips.com/sqlservertutorial/277/index-scans-and-table-scans/
https://www.mssqltips.com/sqlservertip/2602/collecting-and-storing-poor-performing-sql-server-queries-for-analysis/
https://www.mytecbits.com/microsoft/sql-server/what-are-extended-events
https://helpx.adobe.com/coldfusion/developing-applications/the-cfml-programming-language/extending-coldfusion-pages-with-cfml-scripting/using-closures.html#ClosureinColdFusion
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
You can also define how many recent versions you want to keep. To retain only one past version use: | |
# paccache -rk1 | |
Add the u switch to limit the action of paccache to uninstalled packages. For example to remove all cached versions of uninstalled packages, use the following: | |
# paccache -ruk0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[INFO ] runwar.server: Starting RunWAR 3.8.1-SNAPSHOT | |
[INFO ] runwar.server: Starting background cf9001 [adobe 9.0.2+282541] from: /C:/Users/bd/.CommandBox/lib/runwar-3.8.1-SNAPSHOT.jar | |
[INFO ] runwar.context: Starting in background - | |
[INFO ] runwar.server: Starting RunWAR 3.8.1-SNAPSHOT | |
[INFO ] runwar.server: Adding additional lib dir of: C:\Users\bd\.CommandBox\server\FA53F12C9565C5F09E80F00AED307624-cf9001\adobe-9.0.2.282541\WEB-INF/lib | |
[INFO ] runwar.server: ****************************************************************************** | |
[INFO ] runwar.server: Starting - port:53699 stop-port:53700 warpath:file:/D:/Webs/CF9.001/ | |
[INFO ] runwar.server: context: / - version: 3.8.1-SNAPSHOT | |
[INFO ] runwar.server: web-dirs: D:\Webs\CF9.001 | |
[INFO ] runwar.server: Log Directory: C:\Users\bd\.CommandBox\server\FA53F12C9565C5F09E80F00AED307624-cf9001\adobe-9.0.2.282541\logs |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
> cfconfig set mailServers=127.0.0.1 to=myserver | |
ERROR (4.6.0+00003) | |
invalid call of the function setMailServers, first Argument (mailServers) is of invalid type, can't cast String [127.0.0.1] to a value of type [array] | |
the function is located at [C:\Users\xxx\.CommandBox\cfml\modules\commandbox-cfconfig\modules\cfconfig-services\models\providers\Adobe9.cfc] | |
\modules\commandbox-cfconfig\commands\cfconfig\set.cfc: line 59 | |
57: error( "[#property#] is not a valid property" ); | |
58: } | |
59: oConfig[ 'set#property#' ]( arguments[ property ] ) | |
60: .write( toDetails.path ); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!--- | |
Invalid CFML construct found on line 23 at column 36. | |
ColdFusion was looking at the following text: | |
Function | |
The CFML compiler was processing: | |
An expression beginning with callStack, on line 23, column 23.This message is usually caused by a problem in the expressions structure. | |
A cfset tag beginning on line 23, column 6. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
> start server-cf9.json --trace --console | |
✓ | Starting Server | |
|------------------------------ | |
| Looking for server JSON file by convention: D:\Webs\CF9.001\server-cf9.json | |
| webroot defaulted to location of server's JSON file: D:\Webs\CF9.001\ | |
| start server in - D:\Webs\CF9.001\ | |
| server name - cf9001 | |
| server config file - D:\Webs\CF9.001\server-cf9.json | |
| WAR/zip archive already installed. | |
| ****************************************** |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<cfset q1=QueryNew( | |
"Date,User,Col1,Col2,Col3", | |
"varchar,varchar,integer,integer,integer", | |
[ | |
{ | |
Date = "08/2019", | |
User = "Sam", | |
Col1 = 1, | |
Col2 = 2, | |
Col3 = 3 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<cfset SetLocale("German (Standard)")> | |
<cfset dOct31 = createDateTime( 2021, 10, 31, 0, 0, 0 )> | |
<cfset dOct310800 = dateAdd( 'n', 30, dOct31 )> | |
<cfset dOct310800 = dateAdd( 'h', 8, dOct310800 )> | |
<cfdump var="#dOct31#"> | |
<cfdump var="#dOct310800#"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<cfset strName = "fit&gesund"> | |
<cfoutput> | |
#encodeForHTML( strName )# | |
<br>#encodeForHTML( strName, true )# | |
</cfoutput> |
Lesson Learnt, Streaming Producer / Consumer issue using:
BlockingCollection<T>
and Parallel.ForEach(_blockingCollection.GetConsumingEnumerable
Beware default Partitioner algo, which is chunking and buffering.
The GetConsumingPartitioner
heading covers it, and also the first comment from Stephen Toub totally nails it. We implemented similar to what commenter Hernan pointed out.
Stephen Toub Blog
My absolute saviour, NoBuffering
in:
OlderNewer