Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips
Tip Bank > Database Development

Database Development - Page 3

Active Server Pages
Data Access
Database Administration
Database Apis
Database Tuning
Relational Databases
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
41-60 of 2269     Previous     Next
Executing Marked Text in SQL Server Management Studio
by Cindy Rodriguez
In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute.
Quickly Determine Which Tables Need Indexes in SQL Server
by Srinath MS
A quick way to determine which tables need indexes is to use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables."
Debugging SQL Server Stored Procedures Through Visual Studio.NET
by Srinath MS
Learn how to use Visual Studio.NET to debug SQL Server stored procedures.
Use UNION ALL Instead of UNION
by Srinath MS
To improve query speed, use the UNION ALL statement.
Calculate the Last Day of the Month for Any Given Date
by Raja Krishna
The code in this tip calculates the last day of the month for any given date.
Read an Image from a Database Using the getBinaryStream Method
by Leonard Anghel
This following code shows you how to extract an image from a database using the getBinaryStream method.
Creating Tables in the Default Tablespace
by MS Sridhar
Most users typically create tables in the default tablespace. Most of them are not familiar with the actual tablespaces concept and are not aware that this is responsible for the issues they encounter when large data is pumped into said tables.
Using the GRANT Command
by Alexander Ocher
The SQL GRANT command is used to grant access privileges to database objects and role authorizations.
Using MySQL's LIMIT Command to Control Returned Rows
by Srinath MS
Use the script shown in this tip to select a particular number of rows after a certain row in MySQL.
Determine the Version and Build Information for Microsoft SQL Server
by Alexander Ocher
Use the query shown in this tip to determine the version and build information for Microsoft SQL Server.
Trigger Efficiency in Oracle
by Alexander Ocher
It turns out that the latest documentation for Oracle 10g and 11g is incorrect and the documentation for Oracle 9i and previous releases is correct: AFTER row triggers are more efficient than BEFORE row triggers.
Obtain Information About Table Columns in Microsoft SQL Server
by Alexander Ocher
To obtain information about table columns in Microsoft SQL Server, use the INFORMATION_SCHEMA.COLUMNS view.
Changing the Locking Scheme on a Table
by Navin Varma
Using the right type of locking on tables is very important to ensure application scalability.
Testing Compatibility Between SQL Server Versions
by Srinath MS
When migrating SQL code (stored procedures, triggers, etc.) to newer versions, it's not uncommon to have to rewrite your entire back-end code. However, a simpler solution is to check the exisiting code's compatibility with the newer versions.
Execute a SQL Statement with Variable Parameters
by Leonard Anghel
When you have to execute the same SQL statement (in general an UPDATE) for different values you can use the PreparedStatement.
Convert a java.util.Date Object to a java.sql.Date Object
by Leonard Anghel
The code in this tip demonstrates how to convert a java.util.Date object to a java.sql.Date object.
The #flastmod and #fsize Server-side Includes
by Srinath MS
The #flastmod and #fsize server-side includes provide important information on web pages hosted by classic ASP web sites.
Using ANYDATA in Oracle 9i
by Shraddha Pandya
First introduced in Oracle 9i, ANYDATA is a "self-describing data instance type" which means it not only holds the value, but it also holds its own data type within each instance of it.
When to use ORDER in Sequences in PL/SQL
by Shraddha Pandya
You may need to use ORDER to force sequence numbers to be output in the order of request when you're using them for timestamping.
Does Your RDBMS Support Savepoints?
by Leonard Anghel
Before using savepoints in your application, you need to be sure that your RDBMS supports this facility.
41-60 of 2269     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date