|
Most viewed
|
| |
 |
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 |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
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
|
| |
|
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 |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
