Database Development

In case you are wondering, yes, there is a different way to transpose columns into rows than making use of a PIVOT structure. However, it is quite a lot of

In order to create a Snapshot of your database, you can use the following code: DECLARE @DBName VARCHAR(100) = ‘DBName’DECLARE @CurrentDate VARCHAR(20)SET @CurrentDate = ‘_’ + CONVERT(VARCHAR(20), GETDATE(), 120)SET @CurrentDate

The following code snippet shows a small example of how you can sum the result of a count aggregate function. select sum(studentcount) as TotalCountfrom( SELECT count(s.studentname) as studentcount, s.studentname as

Only once the development part of the project is complete do we tend to look at the performance of our application’s interaction with the database and realize that the transactions

There are essentially two ways to get a list of all Stored Procedures inside your database. Option 1: SELECT *FROM YOUR_DATABASE_NAME.information_schema.routinesWHERE routine_type = ‘PROCEDURE’ORDER BY Specific_name This option checks the

magine that you’ve just finished building a database for another Web-based system. Now it’s time to start thinking about writing all that SQL to move the data in and out

massive DELETE operation deletes millions of rows from a table with indexes and constraints. This operation is database intensive and time consuming, mainly because it forces the database to generate

here are times when database data manipulation requires extracting DDL (Data Definition Language) commands for various objects, such as database tables, indexes, constraints, triggers, etc. Recently I was charged with

common misconception among Oracle developers is they can run stored procedures in parallel only from outside the database. For example, many use Java-based code that spawns multiple Java threads and