I encountered an odd situation where appending OPTION (RECOMPILE) to my query causes it to run in half a second, while omitting it causes the query to take well over five minutes. There are times that using OPTION(RECOMPILE) makes sense. In my experience the only time this is a viable option is when you are using dynamic SQL.... » read more
There are number of general signs in the SQL Execution Plan that indicate potentially bad performance spots on the query. For example, the most expensive operator that has the highest cost, related to the overall query cost, is a good starting point for the query performance troubleshooting. In addition, the fat arrows, that followed with thin ones, indicates... » read more
Error: Microsoft.JSInterop.JSException: Cannot read property ‘throttle’ of undefinedTypeError: Cannot read property ‘throttle’ of undefined at https://localhost:44381/_content/Syncfusion.Blazor/scripts/sf-accumulation-chart-5f1ab0.min.js:1:1257 at Object../modules/sf-accumulation-chart.js Fix:
Note: This query is the most detailed. It breaks out the Used space to Data space and Index space. ReservedSpace = DataSpace + IndexSize + UnusedSpace Note: This run needs to be ran on specific database on the server. Sources:
UTF-8 has an advantage in the case where ASCII characters represent the majority of characters in a block of text, because UTF-8 encodes these into 8 bits (like ASCII). It is also advantageous in that a UTF-8 file containing only ASCII characters has the same encoding as an ASCII file. UTF-16 is better where ASCII... » read more
Note: In order for the CRUD operation to work, you must have the following… A Primary Key column defined in the grid. The source of the grid must be a List. IEnumerable will not work. You can either use the OnActionBegin or OnActionComplete grid events to handle the CRUD operations. Example
Issue: SQL Server Agent jobs stuck in running state. No errors and no history. When trying to view history displayed error “Cannot display activity data”. SQL Server Agent Error Logs displays error message… Message: [298] SQLServer Error: 53, A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not... » read more
Sources: https://docs.microsoft.com/en-us/aspnet/core/blazor/forms-validation?view=aspnetcore-5.0
Use input change event to get the changed value in onchange event argument. If you bind using the two-way bind to value property, it will automatically change the value into the value property. or