How to check Optimizer_index_caching from sql prompt

simple answer is

sql>show parameter Optimizer_index_caching;

Done

Enjoy Naveen

Comments

Post a Comment

Popular posts from this blog

Remote Desktop Connection has Expired (Pre-Release Version) Download from Windows Updates

First of all check the your XP version If it is XP SP3 v,3256 or some other version for SP3 then 1 step - Copy mstsc.exe and mstscax.dll from C:\WINDOWS\system32 and mstsc.exe.mui, mstscax.dll.mui from C:\WINDOWS\system32\en-us from some other machine where mstsc is working. 2 step - in the current machine go to cmd c:\sfc /purgecache - to remove the temp entries. Copy mstsc.exe and mstscax.dll To C:\WINDOWS\system32 mstsc.exe.mui, mstscax.dll.mui from C:\WINDOWS\system32\en-us 3.Logoff and Login and try now.Remember this activity has to be done from Administrator account only. 4.If in Any case you still are getting the error that means File Protection is enabled in your system 5.To Disable File protection of the system go to start--cmd--regedit HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ Windows NT\ CurrentVersion\ Winlogon. By default, SFCDisable is set to 0 make it 1 or 2.The Follow Steps 2,3,4, and log off and login with admin and start - run - mstsc Cheers Enj...
Read more

Double click a folder open search box

When i am double click or single click my folder the search box opens :- There are 2 methods to solve this issue 1)Simple helps most of the time start-run-cmd Type regsvr32 /i shell32.dll 2)Solution 2 1. Start Registry Editor (Regedt32.exe). 2. Locate and then click the Default value under the following keys in the registry if this problem occurs with folders: HKEY_CLASSES_ROOT\Directory\shell If this problem occurs with drives: HKEY_CLASSES_ROOT\Drive\shell 3. Click Modify on the Edit menu. 4. Type none in the Value data box, and then click OK. 5. Quit Registry Editor.
Read more