Knowing how to copy existing table data is beneficial to any DBA. This tutorial will demonstrate how to copy an existing table’s data into a new table. Examples with walkthrough explanation are provided.
When you use Skype, you probably use some other third party apps for call recording or faxing to enhance the experiences. If you have stopped using these apps, you should revoke their access to Skype to maintain your privacy.
This guide will explain how to set an Application to run on startup and/or power on. Initially, the default Input is set to run on Power On; we can change this to startup an Application instead.
Amazon gives your Kindle Fire a generic name when you register your device. If you want to change the device name, you will need to go to Amazon’s site to configure it.
If your wireless router uses MAC filtering, you will need to know the Wi-Fi MAC address of your Kindle Fire so that it may connect to the internet.
Do you have a PlayStation 3 and wish you could change the theme on your PS3 without having to buy themes from the PSN? Here’s how you can download and install PS3 theme files from a usb harddrive or thumbdrive.
If you usually have to search for information in a particular website, it is quite handy to do the search directly from the address bar of your browser instead of going to the site and typing in the search box. This tutorial will show you how to do this in Firefox.
If you’ve forgotten the sa password for your SQL server, you are probably in a panic. Fear not, for you can reset the password and once again have access to the powers of the sa account by using the query window in the Management Studio.
Making changes to a database that has been created by a third pary can be a difficult task, especially when you don’t want to break any of the existing stored procedures. You can search the database’s stored procedures for keywords to find which procedures use a keyword that is involved in your change. This makes it much easier in identifying these procedures so you can make the appropriate changes.
If you’re running SQL Server, it’s very wise to make sure that you have the latest service pack installed for optimum performance. If you’re not sure what service pack you have installed (or if you’re still running RTM), follow these steps to find out:
A trigger allows for the execution of SQL code anytime an UPDATE, INSERT, or DELETE command is performed on a certain table. If you are having to perform manual modifications to the table, you may not want the trigger to fire off. Here’s how to disable the trigger so that you can perform your administrative tasks:
By default, tempdb is placed on the same drive that SQL Server is installed on. This is probably not a desirable result, especially if you have installed SQL Server on the boot drive or on an IDE versus a SATA drive. To move tempdb to a faster drive and improve performance, follow these steps:
1...357358359...525Page 358 of 525 error: Content is protected !!
