Viewing 9 posts - 1 through 9 (of 9 total)
Are we talking backing up the data here or actually archiving the data out of the database, (removing from main production environment)?
If it is the removal option, I don't know...
September 27, 2005 at 10:44 am
Sure.
Transaction logs basically wrap around. If the log has space, but that space is not at the end, but in the middle, then it cannot be shrunk with the conventional...
September 27, 2005 at 10:18 am
I had a look at the path, and it no longer exists.
Here's the script:
---************************************---
/*
Shrink a named transaction log file belonging to a database
Originally found at;
September 26, 2005 at 4:09 am
There are sometimes problems with shrinking a database log file due to the fact that it hasn't ever been completely filled. ( I remember seeing this somewhere.)
There was a script...
September 26, 2005 at 4:04 am
There are products by a company called DataFlux that can provide what you are looking for. DF Power Studio being the main contender. It is basically a data analysis tool,...
September 1, 2005 at 4:26 am
This should do what you want:
CREATE PROCEDURE sp_inventering_lista
@RESENH varchar(255), @TableParam varchar(100)
AS
declare
@SQL varchar(8000)
select @SQL =
'SELECT
subquery.Resultatenhet,
subquery.ARTNR,
subquery.BENAEMN,
subquery.ILAGER,
subquery.RESANT,
subquery.DISPONIBELT,
SUM(subquery.SALDO)+DISPONIBELT AS SALDO,
SUM(subquery.SALDO)+SUM(inventering.dbo.hagfors.antal) as SALDO_INVENTERING
FROM
(SELECT
CASE...
September 1, 2005 at 4:23 am
dbcc inputbuffer (), where is the spid from sp_who2. You could write a procedure to use a view of the sysprocesses table and wrap a cursor around each spid...
April 28, 2005 at 2:13 am
Note that adding collation comments into your SQL code could invariably increase the execution time of the code/procedure. It is best to keep the Server Collation the same between your...
April 28, 2005 at 2:08 am
Viewing 9 posts - 1 through 9 (of 9 total)