|
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: 2656 |
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...
|
|
| 07 Sep, 2007 |
Views: 1858 |
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: 1450 |
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: 1327 |
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: 1282 |
Comments: 0 |
|
|
|
|
|
|
Recent articles
|
| |
|
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 |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
