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

Categories
 
folder MS SQL Server (115)
folder MySQL (61)
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 (10)
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: 2328 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...
06 Sep, 2007 Views: 1670 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: 1157 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: 1133 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: 1099 Comments: 0
Recent articles
 
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: 198 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;...
10 Aug, 2009 Views: 259 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: 185 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: 235 Comments: 0
document what is ONLINE INDEX?
Online Index is a feature available after SQL Server 2005, prevously DBAs had to build index during off-peak hours as SQL Server locks data for...
08 Mar, 2009 Views: 366 Comments: 0



RSS