Error: Data-driven subscription cannot be created because the report or shared dataset has user profile dependencies and cannot be run unattended. Fix: When we tried to setup data driven subscriptions we kept getting error: report or shared dataset has user profile dependencies and cannot be run unattended. SSRS data driven subscription do not work if... » read more
Note: SSRS data driven subscription do not work if we have user-id as parameter.
When you upload an image, WordPress not only uploads the original image, it automatically creates three resized images for you: a Large version (default 600px) a Medium version (default 300px) a Thumbnail (default 150px) Width Height Ratio Size WordPress Large 600 WordPress Medium 300 WordPress Small 150 Facebook Download 960 720 1.33 109 KB Google... » read more
Error: Column ‘xxxxx’ is partitioning column of the index ‘PK_xxxxxxxx’. Partition columns for a unique index must be a subset of the index key. Could not create constraint or index. Solution: Since both biTable01Id, dtStartDateTime columns are in the partition column, both must be in the Primary Key column as well.
Starting with SQL Server 2014 a new troubleshooting capability is to monitors real time query progress with the DMV sys.dm_exec_query_profiles which is the base for Live Query Statistics new functionality for SQL Server 2016, there are two ways to enable real time query monitoring: Session scope: By enabling SET STATISTICS XML ON; or SET STATISTICS PROFILE ON;... » read more
Execution Plan in SSMS Run Stored Procedure in SSMS with “Execution Plan” enabled. SSMS will recommend index to be created. Improve Query Statement Convert subqueries to main queries. Note: This may not always increase performance. Have to run the both queries side by side to test.
Model Browser My default, the Model Browser panel does not show up in Endity Model editor. To show the Model Browser panel… Open up .edmx file. Right click and select “Model Browser”.
Error: For some reason, when I launch this application in the debugger using the normal Start Debugging command in Visual Studio, it launches, but it also produces the following warning: Resolution: Disable this option under Debug->Options->Suppress JIT optimization on module load (Managed only). Sources: https://stackoverflow.com/questions/38601643/error-you-are-debugging-a-release-build-of-x-dll