Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us
Database Knowledge Base
Categories
 
folder MS SQL Server (119)
 folder MySQL (64)
 folder MS Access (9)
folder FileMaker (1)
 folder Firebird (1)
 folder Video Tutorials (6)
folder IBM DB2 (3)
 folder Informix (2)
 folder Ingres (1)
folder Interbase (1)
 folder Oracle (45)
 folder Paradox (database)
folder PostgreSQL (11)
 folder Sybase (3)
 folder Visual FoxPro (1)
folder General Issues (1)
 folder Btrieve (2)
 folder Clipper (9)
folder SAP DB (1)
 folder Teradata
folder DBA Interview Questions / Answers (1)
Before you go for the interview, be prepared.
folder Data Sets
Download Open Source Data Sets


Most viewed
 
document What is the maximum size for a row, a table, and a database (PostgreSQL)?
These are the limits: Maximum size for a database? unlimited (32 TB databases exist)
06 Sep, 2007 Views: 16746 Comments: 44
document How to change the owner of all tables in a database?
DECLARE @oldowner sysname, @newowner sysname, @sql varchar(1000) SELECT   @oldowner = 'OLD_OWNER',   @newowner =...
16 Aug, 2007 Views: 4141 Comments: 40
document What is SQLPing and how does it work?
came out of my curiosity and observations of SQL Server's discovery mechanisms. When a SQL Server 2000 client wishes to connect to a server it first...
02 Sep, 2007 Views: 3407 Comments: 40
document what is Maximum size of a query in mysql?
the max size would be limited by the variable max_allowed_packet so, if you do a show variables like 'max_allowed_packet' it will show...
03 Aug, 2009 Views: 3175 Comments: 46
document How does PostgreSQL compare to other DBMSs?
There are several ways of measuring software: features, performance, reliability, support, and price. Features PostgreSQL has most features present...
06 Sep, 2007 Views: 3042 Comments: 43
Recent articles
 
document SQL Server Backup Compression and Security
- Securing your backup - backup compression - NO_WAIT, ROLLBACK AFTER, and ROLLBACK IMMMEDIAT - EMERGENCY! mY TRANSACTION LOG HAS FILLED...
02 Aug, 2011 Views: 556 Comments: 0
document Oracle PL/SQL - Introduction
02 Aug, 2011 Views: 846 Comments: 0
document MySQL Simple Basics
02 Aug, 2011 Views: 676 Comments: 0
document Introduction to SQL - SQL LESSON 1
02 Aug, 2011 Views: 747 Comments: 0
document SQL Server Backup Basics
02 Aug, 2011 Views: 878 Comments: 0


RSS
Powered by KBPublisher (Knowledge base software)