Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Minimize the size of tempdb in SQL Server
- Arthur Fuller discusses tempdb and explains what to do to shrink this database to its minimum size. These tips will help you optimize your system's use of tempdb. SQL Server automatically creates a database called tempdb for use as a workspace. When you specifically create a temporary table...
- Tags: Microsoft SQL Server, SQL, Arthur Fuller, Databases, Programming languages, server, tempdb, SQL Engine, ALTER DATABASE, recovery mode, disk, SQL Server Newsletter, Database, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2006-10-23
Additional Resources
- How Can I use the RMAN to recovery Oracle9i ?
- How Can I use the RMAN to recovery Oracle9i ?good answer can somebody help me? thank uRMAN>startup nomount;RMAN>set dbid=RMAN>alter database mount;RMAN> restore database;RMAN>recover database;RMAN>alter database open resetlogs;This question was closed by the author
- Tags: houxf@..., linux, RMAN, Oracle9i
- Q&A 2006-01-16
- Ease Access database maintenance with the Alter Table command
- When you need to make a number of changes to your Access database, the Alter Table command can help. Learn how you can use the command to quickly add or delete fields in an Access table. When you need to make a number of quick changes to your ...
- Tags: Microsoft Access, Databases, Microsoft Office, Mary Ann Richardson, ALTER TABLE, Employees Table, database, Microsoft Office Suite Access Tips Newsletter, Storage, Enterprise Software, Software, Data Management, Office Suites, Hardware
- Technical articles 2006-03-14
- Visual Studio 2003 & SQL Server 2005 - Database Updating
- Every so often, my database and/or VB code gets a concurrency exception when I try to write to the database. If I alter the code using the acceptChanges method on the dataset, I eliminate the exception, but the database is not being updated. It seems that the data...
- Tags: Storage, Databases, Microsoft development tools, vlenza@..., database, Microsoft Visual Studio, Microsoft SQL Server, Microsoft SQL Server 2005
- Discussion threads 2007-10-12
- Alter-Ego (exe)
- Alter-Ego is the only fully automated profile and domain migration system. From a centralized console, Alter-Ego is able to simultaneously move PCs between one or more domains or workgroups while migrating user accounts on hundreds or even thousands of workstations! Alter-Ego requires no scripting expertise or desktop visits to install...
- Tags: Winterfrost Systems, Alter-Ego, Workstations, Desktops, Hardware
- Software downloads 2007-06-12
- Alter every table in a SQL database
- Adding two columns to every table in a database that contains hundreds of tables is impractical to do by hand. Arthur Fuller describes how simple it is to create a query that performs this task. All developers make mistakes from time to time; sometimes this happens...
- Tags: SQL, Databases, Arthur Fuller, database, ALTER TABLE NorthwindTest.dbo, ADD LastUpdated TimeStamp NULL, LastUpdated TimeStamp, SQL Server Newsletter, TechRepublic Inc., Table, Storage, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-22
- Oracle XE data block corrupted
- I have oracle XE installed on solaris 10 When i try to create new table it gives me error ORA-01658: unable to create INITIAL extent for segment in tablespace USERSto fix this problem i am trying to alter the tablespace the datafile exists at '/usr/lib/oracle/xe/oradata/XE/users.dbf'I tried ****alter tablespace...
- Tags: alpha.mn@..., Oracle Corp.
- Discussion threads 2007-09-26
- Resize BIGFILE tablespaces directly using ALTER TABLESPACE
- Database administrators can now resize Oracle datafiles at the tablespace level using the BIGFILE tablespace feature in 10g. Bob Watkins explains how in this Oracle tip. Oracle 10g introduced a new type of tablespace called BIGFILE. Unlike traditional tablespaces that are composed of up to 1,022 datafiles,...
- Tags: Oracle Corp., BIGFILE, Storage, RAID, Bob Watkins, datafile, tablespace, Oracle Tips Newsletter, TechRepublic Inc., Hardware
- Technical articles 2007-01-09
- Ease Access database maintenance with the Alter Table command
- do it in table designWhile not just alter the table in table design. Seems quicker then typing SQL code in a query.You have to be careful with some gui table designersInstead of executing a number of alter table commands they create a temporary table with the new structure, construct an...
- Tags: ALTER TABLE, database, hardware, Microsoft Access, solson@..., SQL, table design
- Discussion threads 2006-03-16
- How to use default values with database columns
- When you create a database table in Oracle 9i, you have the option to specify a DEFAULT value. Using default values on database columns helps to insulate database design issues from application code. With the DEFAULT value set, you can change it at some later date with a single ALTER...
- Tags: Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Download resources 2005-06-03
- DbVisualizer (exe)
- DbVisualizer is a feature rich, intuitive and cross platform database tool for developers and DBA's providing a single powerful interface for a variety of databases. DbVisualizer supports simultaneous database connections, it lets you explore and manage database objects, execute SQL queries, visualize information and a lot more. Version 6 adds...
- Tags: DbVisualizer, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2007-07-30
- SQL CodeSecure (zip)
- SQL CodeSecure allows DBA's, developers, and IT managers to easily enforce and manage database protection and security at different levels and to keep track of changes made and executions called in a database. SQL CodeSecure audits all create, alter, drop, select, insert, update, delete, and execute statements. This version is...
- Tags: SQL, SQL CodeSecure, Programming Languages, Databases, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware
- Software downloads 2007-11-22
- ThoughtScape Designer (asmx)
- ThoughtScape Designer is a powerful database designer helpful when it comes with working with database structures and .NET code. The designer is database independent so that you can use the same tool for a variety of relational database management systems. With this tool you can reverse engineer databases, create and...
- Tags: ThoughtScape Designer, Designer, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2008-01-16
- DTM Schema Reporter (exe)
- DTM Schema Reporter is a reporting tool for database schema. The program creates reports in RTF,XML,HTML,CHM,PDF or plain text formats and supports all common database interfaces - ODBC, OLE DB, IDAPI, or Oracle Call Interface. This utility helps technical writers and database administrators create a report of any complexity level...
- Tags: Report, DTM Schema Reporter, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2007-12-20
- EMS DB Comparer 2006 for MySQL (zip)
- EMS DB Comparer for MySQL is an excellent tool for database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences. Having EMS DB Comparer for MySQL you can work with several projects...
- Tags: MySQL, Databases, Open Source, Enterprise Software, Software, Data Management
- Software downloads 2007-03-31
- EMS DB Comparer 2007 for Oracle (zip)
- EMS DB Comparer for Oracle is an excellent tool for database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences. Having EMS DB Comparer for Oracle you can work with several projects...
- Tags: Oracle Corp., Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2007-10-10
- DataForms.Net (zip)
- DataForms.Net allows developers to create database applications on MS SQL Server or other RDBMS. Just point DataForms.Net to any table in your database and DataForms.Net will get underlying schema and dynamically create forms to add, edit, delete, sort, filter, and print data. If you alter your tables, there is no...
- Tags: Schema, DataForms.Net, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2005-10-10
- Free Website Traffic Monitor (zip)
- It will record useful information about your Web site activity. You can select what page you want to monitor. All report is stored in a Microsoft access database format (*.mdb). You can modify, alter, distribute at your own risk. This version is the first release on CNET Download.com.
- Tags: Monitor, Web Site, PureGoogle, Web Site Development, Monitors & Displays, Web Technology, Databases, Internet, Hardware, Components, Enterprise Software, Software, Data Management
- Software downloads 2008-08-21
- SSW Property and Event Pro 2000 (exe)
- Developed for the Access developer wanting to do a global replace SSW Property and Event Pro 2000 allows you to set values for properties and events across your whole database with an easy-to-use interface. You can also apply conditions based on any property to alter the affect of your changes....
- Tags: Microsoft Access, Property, Software Development, Databases, Microsoft Office, Storage, Software/Web Development, Enterprise Software, Software, Data Management, Office Suites, Hardware
- Software downloads 2007-03-24
- Toshiba Screen Toruble
- I recnetly recieved a toshiba laptop that had a broken LCD screen. I cannot identify exactly which model the computer is because the tag is unmarked on the bottom of laptop. I ordered a replacement screen by the number on the original screen. The new screen is...
- Tags: Notebooks, Monitors & displays, tmMountainfountain@..., laptop computer, Toshiba Corp.
- Discussion threads 2007-04-17
- << Previous
- page 1 of 1
- Next >>
