Microsoft SQL – Rebuild Indexes
- February 26th, 2009
- Write comment
You can use the following command to simply rebuild all the indexes on a table.
DBCC DBREINDEX(tablename, “”,0)
Archive for February, 2009
You can use the following command to simply rebuild all the indexes on a table.
DBCC DBREINDEX(tablename, “”,0)
The command “system_profiler” will return all the hardware information.
Other useful commands include sw_vers, hostinfo, and uname -a.
To utilize the automatic update facility in WordPress 2.7 and greater, the files need to be owned by the same user as the user the web server runs as. For example, a linux installation would need to have the files owned by the apache user and group. I did this by using the following command:
chown -R apache.apache /usr/local/wordpress
From here, the update worked fine. The google analytics plugin worked fine as well.
To get Tversity to install/run on a Vista Ultimate installation that is joined to a domain, I had to disable “User Access Control.” I did it via the msconfig utility executed from a “Command Prompt.” Go to Tools/Disable UAC.
Note: If Vista is not joined to a domain, you can disable “User Access Control” via Control Panel/User Accounts/User Accounts.” From there, you can click “Turn User Account control on or off.”
You have to reboot after changing the setting.
Add the following to the .vmx configuration file for the guest.
bios.forceSetupOnce = “TRUE”
From a command prompt:
nslookup
set q=srv
_ldap._tcp.dc._msdcs.Active_Directory_domain_name
I used this method in a very simple configuration. I had one Windows 2003 server/forest/domain controller with a few XP/Vista clients.
From the Windows 2003 Domain Controller:
Bring up “Active Directory Domains and Trusts”, from Administrative Tools.
Right mouse click on the domain name (usually a “.local” name), and click on “Raise Domain Functional Level”.
Change the level “Windows 2003”. Note: This is not reversible and you are warned in the application as well.
Next, right mouse click on “Active Directory Domains and Trusts,” and click on “Raise Forest Functional Level.”
Change the forest level to “Windows 2003” as well. Note: This is also not reversible.
Next, copy the source/adprep directory off the “Windows 2008 Server” CD to a your Windows 2003 domain controller.
From the copied adprep directory, execute adprep /forestprep.
Then, execute adprep /domainprep.
At this point, you can run dcpromo from your Windows 2008 server. However, you need to make sure you have the “Active Directory Domain Services.” role installed.
I have run a DNS issue, and have not been able to get dcpromo to complete. Will update when I get it to work.
Boot from the installation source CD/image.
Enter the Recovery Console by pressing R when prompted.
Enter the number for the appropriate installation.
Enter “bootcfg /list” to list the current configuration.
Enter “boot /rebuild” to rebuild configuration.
At “Enter Load Identifier”, enter the name of the installation (i.e. “Windows XP”.
If prompted for “OS Load Options”, enter “/fastdetect”.
Enter “EXIT” to reboot
I used this method on CentOS5 and used the rpmforge repository to install mencoder (yum install mencoder).
mencoder -forceidx -ovc copy -oac copy -o combinedfilename.avi firstfilename.avi secondfilename.avi