The ‘Database’ Archives
Posted December 7, 2011 by

Oracle: How to Create a Copy of Table Data

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.

Category Oracle

Posted December 5, 2011 by

Oracle: How to Create an Auto Increment Field Using Sequence

In Oracle, you can create an auto increment field using ‘sequence’ database object that can be assigned as primary keys. Using Oracle ‘sequence’ object, you can generate new values for a column. An Oracle sequence is an object like a table or a stored procedure. Examples with walkthrough explanations are provided.

Category Oracle

Posted November 4, 2011 by

SQL Server 2008/2008 R2: Move tempdb to Improve Performance

By default, tempdb is placed on the same drive that SQL Server is installed on. This can impair performance as tempdb is frequently used to store temporary tables and objects. If the hard drive is being accessed for other functions, it can result in sluggish performance by the database as well as any software that […]

Category Database

Posted October 1, 2011 by

MySQL: How to get row number order

These directions walk through how one can displaying the row number order/rank for result set obtained from executing a sql query. An example with walkthrough explanation is provided.

Category Database, MySQL

Posted October 13, 2009 by

SQL Server: How To Find Duplicate Records

When checking the integrity of your data, it may be necessary to check your tables for duplicate records. By grouping these records, you can eliminate the unique records from your result set so that you can view just the records that contain duplicated values, making it easier to remove them.

Category Database

Posted December 22, 2008 by

SQL Server 2005: How to Reset a Forgotten Password for the sa Account

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.

Category Database

Posted December 4, 2008 by

SQL Server 2005: Locating Stored Procedures that Contain a Keyword

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.

Category Database

Posted October 12, 2008 by

SQL Server 2005/2008: Disable Management Studio’s Splash Screen

If you have grown tired of having to view the splash screen each and every time you open the SQL Server Management Studio, you can use a simple command line switch in your shortcut to bypass the annoyance.

Category Database

Posted October 4, 2008 by

Microsoft SQL Server: How to Find the Foreign Keys in a Database

A foreign key is a column or columns that are used to enforce a link between data in two tables. While SQL Server gives you no quick and easy way to view the foreign keys in a database, this quick query will give you that information. It comes in handy when trying to troubleshoot Foreign Key Constraint errors.

Category Database

Posted September 26, 2008 by

SQL Server 2005: How to Disable a Trigger

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 […]

Category Database

Posted January 7, 2008 by

SQL Server 2005: What Service Pack is Installed?

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:

Category Database

Posted May 8, 2007 by

SQL Server 2005: Move tempdb

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:

Category Database