(Vadivel M) Prior to SQL Server 2005 if we want to find out the list of recently run queries we need to depend on SQL Profiler.
Other News
Online restore and filegroups
(Tibor Karaszi) Is data available for a partitioned table if one of the partitions isn’t available? Instead of reading BOL, I wanted to test this.
Another use for INSERT ALL syntax
(Andrew Clarke) Over on the Pythian blog Babette Turner-Underwood discusses Oracle’s multitable insert syntax. She’s been using in on a data conversion project. The advantage of INSERT ALL is that it allows us to insert several different VALUES clauses in a single statement.
Oracle Database Fundamentals
(Mamun Zaman) In this article we will mainly focus on basic database development using Oracle. We will learn how to create new tables, alter them, insert data into the database, update data, retrieve data, delete data and drop tables. We have lots to do, so let’s get started.
Oracle Capacity Planning
(JP Vijaykumar) 02:00 AM Boss: Reclaim every byte of free space from other tablespaces in the database/ server that are not 100% full and allocate to EMP_TBSP01 tablespace, which is 100% full.
Put SQL Server’s EXISTS construct to good use
(Tim Chapman) One thing I have noticed over the years is how seldom developers use SQL Server’s very useful EXISTS construct. You can use EXISTS in a variety of situations — some of which I will explore in this article.
MySQL Optimizer and Prepared Statements
(Sergey Petrunia) Performance-wise, the idea of Prepared Statements is that the server does certain pre-processing on PREPARE command, and then those steps are omitted when the statement is executed. If the statement is executed several times, we get an economy of cost_of_prepare_preprocessing *
Rapid Windows application development with IBM Informix Dynamic Server and IBM Database Add-ins for Visual Studio 2005
(Vimal Pradeep and Malarvizhi Kaliyakrishnan) IBM introduced the IBM Database Add-ins for Visual Studio 2005 to allow rapid Windows application development, database schema development, and debugging, along with numerous other features. This IBM tooling has been available for DB2 on all of the Visua
Enforce Business Rules for All Your Data with Constraints
(Alexander Kuznetsov) Of the several ways to enforce business rules in the database, only constraints can guarantee that your business rules are always enforced for all your data. This article teaches you how to apply foreign key constraints with the ON UPDATE CASCADE clause to implement waterproof
Splitting a class across files in VB.NET
(Irina Medvinskaya) With the complexity of today’s applications, developers often deal with classes that are very long. One way to make the classes more manageable is to split them across multiple files. Partial is a new keyword in VB.NET that allows you to split the classes to multiple physical sou