DatabaseJournal.com Staff

By John Schultz Overview In early 2013 while working at AOL we discovered a serious problem with an application developed to use MongoDB. The database for this application would consist of billions of small documents representing pieces of user data. While any one document was not large, 1200-1400 bytes, the very large number of documents […]

>>Script Language and Platform: SQL Practice Author: Wes create table zipcodes ( zip integer(5) primary key, city varchar(30), State varchar(20)); create table employees ( eno varchar(10) primary key, ename varchar(30), zip integer(5) references zipcodes, hire_date date); create table books ( bno integer(5) primary key, bname varchar(30), qoh integer(5) not null, price dec(6,2) not null); create […]

Mary Mikell Spence, a Senior Oracle Database Administrator living in Metropolitan Atlanta, Georgia, has worked in the IT field since graduating from Georgia Tech in 1983. Beginning her career as an application developer, she has worked with Oracle since 1991. Her Oracle experience encompasses database design and architecture, development, production support, backup and recovery as […]

By Angela Cataldo The Past and Its Problems Extended Events we–have all heard about it, but did you ever troubleshoot SQL Server 2008 performance, locking and connectivity issues using this source of data? I expect the answer to this is:                 “I tried but couldn’t get the information I needed easily” Using Extended Events in […]

>>Script Language and Platform: SQL Server Piece of code to search all stored procedures in all databases for keyword. Author: Jim Youmans EXEC sp_MSForEachDB ‘USE ?; SELECT DB_NAME(), ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ”%foobar%” AND ROUTINE_TYPE = ”PROCEDURE”’ Disclaimer: We hope that the information on these script pages is valuable to you. Your use […]

>>Script Language and Platform: SQL Server Helps DBA to find out quickly which database takes a lot of space and which file could be shrunk. Very useful when output is sorted by Drive Letter when “Out of space” occurs. Author: Leonid Sheinkman /* Author: Leonid Sheinkman Created: 2009-01-12 Updated: 2013-02-15 This script use undocumented DBCC […]

By Frank Solomon Starting with SQL Server 2005, developers have had recursion available as a T-SQL language feature. This article will describe recursion and its SQL Server implementations, complete with examples. It will also include SQL Server functions and a stored procedure that unpacks, or parses, an integer into its multiple-of-two components. An algorithm that […]

By Alexander Polishchuk Selecting a contiguous data range, when the source data range is incomplete, requires producing the missing data and merging it with the source data set. The following article describes a method of generating the required data in Oracle and merging it via full outer join or union data set operator. Consider an […]

>>Script Language and Platform: Access, VBA Want to use this function in PHP/MySQL but new to PHP/MySQL. It works by taking the select member code description and the last assigned number and format as CON-00001 once the focus in lost after selecting the member description from dropdown list on the form. Author: lrhrose Option Compare […]

>>Script Language and Platform: ASP/SQL Used when checking to see if the registered user is already in the database. Author: Miriam SELECT Email FROM userProfile WHERE LOWER(Email) = LOWER (@0) Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is […]

By Mike Lamble Today, organizations are awash in Big Data. By “big data” we’re talking about traditional business data such as orders, transactions, customer profiles, as well as new data sources flowing from machines, sensors, and social networks. This is data that is measured in exabytes and beyond. If studies are correct, we may be […]

By Alex Polishchuk Often, production databases need to be copied over to development and other environments for performance tuning or testing. The traditional methods of backup and restore or export and import take a long time, especially on large databases. The following approach, utilizing Oracle transportable tablespace (TTS), has been devised to allow fast data […]