Daily Dynamic Learnings

Search This Blog

Useful SQL Queries

· select * from sys.change_tracking_databases

Gives you details about databases for which change tracking is enabled.

· select * from sys.databases

Gives you details about databases like its name, id, owner etc…

SQL

Comments

How to clear cache in VM

Clearing cache could help in some cases. Close Visual studio and other applications before attempting to clear the cache for them. In a VM navigate to the mentioned paths and clear the contents. C:\Users\Administrator\AppData\Local\Temp Below are the paths to clear cache related to Visual studio and Team foundation/VSTS C:\Users\Administrator\AppData\Local\Microsoft\VisualStudio\14.0\ComponentModelCache C:\Users\Administrator\AppData\Local\Microsoft\VisualStudio Services\7.0\Cache C:\Users\Administrator\AppData\Local\Microsoft\Team Foundation\6.0\Cache Note : The admin user would be named differently in each VM but it would start with Admin****** Depending on the version of VS the folder numbers could be as 15.0_eff6c803 or 16.0_e0fab5b4 Don't clear any other content apart from mentioned cache folders. Similarly, to clear cache corresponding to SQL is C:\Users\AdministratorAppData\Local\Microsoft\SQL Server Management Studio\18.0_IsoShell\ComponentModelCache I...

Filter blank/empty values in form

Select ‘ is exactly ’ in filter lookup & enter “”. This would give you records for which value is not filled in. Note : Might not work for referenced fields in the form. Example is Phone number in Customers form.

About Default action property & Default button set to Yes

Default Action – Specifies the default action to execute on the form when the Enter key is pressed. Default Action – Specifies the default action to execute for a row in the grid (typically navigation). Default Button – Specifies whether the button control should be executed when user presses the Enter key (Dialog forms only)

Powered by Blogger

Useful SQL Queries

Comments

Post a Comment