Friday, October 11, 2013

SQL Server 2005 - How to Rebuild Indexes periodically

Rebuilding indexes speeds up searches into a SQL Database. Your applications will benefit!
Index is not rebuild unless you tell SQL server to do it.
I have found quite useful to create a maintenance plan.รน
Right-Click on Maintenance Plans and create a new plan:

Undem Maintenance Plan Tasks (left) drug to the workspace the "Rebuild Index Task" 



and then doubleclick to get the properties:



Customize your task. You can select DBs to reindex.
With the Calendar icon schedule how often you wish it to run.


Note: plans will then appear in the Jobs Area:








Force software to always run as admin without exposing admin password

We have many computers where users are not admin.
I need to run a .exe file but it always asks for Admin credentials. I want to avoid been called each time they run the file ....

Surfing the internet I found a solution that worked for me:

1. Create a shortcut to the Exe File
2. Enter properties of the shortcut and modify the "Target" field adding C:\Windows\System32\runas.exe /savecred /user:domain\administrator before the existing file path


Save and run it. You will be prompted to enter the password:
Enter the password.
Always use the link to run the application.
Note: this does not work for Windows 7 Home or Starter Edition


Samsung Printer: Error Code #C1-1311

Hi
I just got this error code on the Samsung ML5010-ND:


This was a toner problem. Toner is not evenly distributed.
Solution: Remove the toner and shake it a while.

If this does not work ... get ready to replace it.

Microsoft Teams doesn't open

 Hello! My Microsoft Teams stop working! Searching .... I found this solution that worked: Delete the content of: C:\Users\<profile>\A...