Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us

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: 9190 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: 3804 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: 2845 Comments: 40
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: 2695 Comments: 43
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: 2685 Comments: 46
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: 338 Comments: 0
document Oracle PL/SQL - Introduction
02 Aug, 2011 Views: 550 Comments: 0
document MySQL Simple Basics
02 Aug, 2011 Views: 413 Comments: 0
document Introduction to SQL - SQL LESSON 1
02 Aug, 2011 Views: 437 Comments: 0
document SQL Server Backup Basics
02 Aug, 2011 Views: 560 Comments: 0



RSS