|
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: 993 |
Comments: 4 |
|
|
|
 |
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: 805 |
Comments: 33 |
|
|
|
 |
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: 347 |
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: 334 |
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...
|
|
| 05 Sep, 2007 |
Views: 296 |
Comments: 0 |
|
|
|
|
|
|
Recent articles
|
| |
 |
how we can change ownership in SQL Server?
DECLARE @old sysname,
@new sysname,
@sql varchar(1000)
SELECT
@old = 'webwin_whomakeswhat'
, @new = 'dbo'
, @sql =...
|
|
| 09 Jun, 2008 |
Views: 54 |
Comments: 0 |
|
|
|
 |
what is an Extent?
A collection of 8 data pages. Since a data page is 8 KB, an extent is 64 KB.
|
|
| 13 May, 2008 |
Views: 69 |
Comments: 0 |
|
|
|
 |
What is Log sequence number (LSN)?
The unique number that each operation is stamped with when it is written to the transaction log. A single SQL Server transaction may contain several...
|
|
| 13 May, 2008 |
Views: 85 |
Comments: 0 |
|
|
|
 |
What is Filegroup?
A logical grouping of SQL Server database files. By default, a new SQL Server database contains the Primary filegroup.
|
|
| 13 May, 2008 |
Views: 76 |
Comments: 0 |
|
|
|
 |
define term Minimally logged operations (bulk load operations)
Data movement operations that require minimal logging in the transaction log. These operations include bcp, certain Data Transformation Services...
|
|
| 13 May, 2008 |
Views: 71 |
Comments: 0 |
|
|
|
|