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

Categories
 
folder MS SQL Server (115)
folder MySQL (62)
folder MS Access (9)
folder FileMaker (1)
folder Firebird (1)
folder IBM DB2 (3)
folder Informix (2)
folder Ingres (1)
folder Interbase (1)
folder Oracle (44)
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.


Most viewed
 
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 =...
17 Aug, 2007 Views: 2656 Comments: 0
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...
07 Sep, 2007 Views: 1858 Comments: 0
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: 1450 Comments: 0
document Is there an easy way to loop through every stored procedure in a database and create a file containing all of the SP code?
By joining sysobject and syscomments table we can get your desired results, run this query in Query Analyzer (with result in text...
18 Aug, 2007 Views: 1327 Comments: 0
document How we can back up all databases in SQL Server
USE master GO SET NOCOUNT ON DECLARE @BackupPath nvarchar(500) DECLARE @BackupDBFile nvarchar(500) DECLARE @BackupLogFile...
17 Aug, 2007 Views: 1282 Comments: 0
Recent articles
 
document Which is best free Hosting for PHP, MySQL and with out ads
If you wish to have a professional shared hosting quality in a free hosting package, come and host with
28 Apr, 2010 Views: 171 Comments: 0
document any free mysql Query Analyzer?
Jet Profiler for MySQL   is real-time query performance and diagnostics tool for the MySQL database server. Core features: Query,...
25 Sep, 2009 Views: 430 Comments: 0
document How to Change case to Proper in mysql
(MySQL Version 5) DROP FUNCTION IF EXISTS proper; SET GLOBAL  log_bin_trust_function_creators=TRUE;...
11 Aug, 2009 Views: 451 Comments: 0
document Where i can find data sets?
www.OpenSourceDB.org is a site where you can find data sets for very low price or free,  available data sets are 1. BIN (Bank Identification...
03 Aug, 2009 Views: 339 Comments: 0
document How we can improve MySQL DB Performance?
Don't Index Everything Use benchmarking Minimize traffic by fetching only what you need. Paging/chunked data retrieval
03 Aug, 2009 Views: 391 Comments: 0



RSS