Data Driven Subscriptions in SSRS 2016
Note: SSRS data driven subscription do not work if we have user-id as parameter.
Author
Web Photo Width, Height, Size
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
Partition columns for a unique index must be a subset of the index key
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.
Create Index Status Monitor Progress
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
Increase Performance of Existing Stored Procedure
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.
Show Entity Framework Model Browser Panel
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: You are debugging a release build
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
OFFICIAL USA TIME
https://www.time.gov/