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
View qOq_JOIN.cfm
<cfset q1=QueryNew( | |
"Date,User,Col1,Col2,Col3", | |
"varchar,varchar,integer,integer,integer", | |
[ | |
{ | |
Date = "08/2019", | |
User = "Sam", | |
Col1 = 1, | |
Col2 = 2, | |
Col3 = 3 |
View error.log
> 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. | |
| ****************************************** |
View index.cfm
<!--- | |
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. |
View 20180312_box_error.txt
> 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 ); |
View server.out.txt
[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 |
View clear_pac.sh
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 |
View links.md
View tz.001.cfm
<cfset oZoneId = createObject( "java", "java.time.ZoneId")> | |
<cfset oInstant = createObject( "java", "java.time.Instant")> | |
<cfset oTextStyle = createObject( "java", "java.time.format.TextStyle")> | |
<cfset oLocale = createObject( "java", "java.util.Locale").init( getLocale() )> | |
<cfset qryTZ = queryNew( | |
"offset,zone,region,displayfull,displayfullstdo,displaynarrow,displaynarrowstdo,displayshort,displayshortstdo,displayfulloffset,displayshortoffset", | |
"Integer,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar" | |
)> |
View datatypes_lucee_acf.cfm
<!--- | |
http://teratech.com/is-lucee-cfml-now-better-than-adobe-coldfusion/ | |
---> | |
<cfscript> | |
data={ | |
boolean:true, | |
stringTrue:'true', | |
stringYes:'yes', | |
number:5, | |
stringFive:'5' |
View EncodeRFC3986.cfm
<cfscript> | |
/** | |
* URI encoding per RFC 3986, which has treats the following as unreserved: ALPHA / DIGIT / "-" / "." / "_" / "~" | |
* @text Text to encode | |
* @returns URI encoded text | |
*/ | |
public function encodeRFC3986(required string text) { | |
// Requires CF10+ | |
Local.encoded = encodeForURL(arguments.text); | |
// Reverse encoding of tilde "~" |
NewerOlder