It's always good finding easier ways...Thank you very much!!

Hello,

seems to me you should change

  BEGIN
   SELECT @Folder = @Folder + (SELECT FLevel FROM @Folders...

Hello Igor,

in the article you pose the question "Which Is Faster: COUNT(*) or COUNT(1)?", but actually you answer with "COUNT(*) versus COUNT(ID)" (which is not the same as count(1))

Is...

Hello,

regarding Raid configuration you also have to count in the time/cost of a rebuild.

If your smallest unit is 1 mirrored drive the controller only needs to read and write...

New code for SQL Server 2005 and above:

declare @groups table ( id int identity, grp sysname, distinguishedName VARCHAR(MAX) )

declare @usrs table ( id int identity, usr sysname, grp sysname )

declare...

... and one more version.

This one works on SQL Server versions 2000-2012...

SELECT c.Name AS DatabaseName, c.rm AS database_recovery_model,

CASE c.type

WHEN 'D' THEN 'Full'

WHEN 'I' THEN 'Differential'

WHEN...

Hi,

i had neglected bulk_logged databases... Here a better script

;WITH a AS

( SELECT type='D' UNION ALL SELECT 'L' UNION ALL SELECT 'I'

), c AS

( SELECT b.Name, DATABASEPROPERTYEX(b.Name, 'recovery') as rm, a.type...

Hi,

this is not so short anymore, but should do the trick...

;WITH a AS (SELECT 'Full' AS type UNION ALL SELECT 'Log' UNION ALL SELECT 'Differential'), b AS

( SELECT Name, DATABASEPROPERTYEX(Name,...

Hello tapaskumardm,

you are using replication. What does

dbcc opentran

get you? Any not distributed transactions?

Regards

karl

sorry, native compressed backups are (as far as i know) only available in

SQL Server 2008 Enterprise Edition

SQL Server 2008 R2 Standard and Enterprise Edition

SQL Server 2012 Standard and...

that's bad

Did you ever try a compressing backup software like SQL Litespeed (Quest) or SQLBackup (Red Gate)? (i'm assuming SQL2005 i.e. you do not have native compressed backup)

That is...

Hi,

are you doing compressed backups or does Networker copy the entire raw data over the net?

If not compressed, i'd presume that not disk-io but network-io is the limiting factor.

regards

karl

Hi,

shortening it up a bit...

SELECT T1.Name AS DatabaseName,

DATABASEPROPERTYEX(T1.Name, 'recovery') AS database_recovery_model,

Isnull(Max(T2.recovery_model),'No Backup Taken') AS backup_recovery_model,

CASE type

WHEN 'D' THEN 'Full'

WHEN 'I' THEN 'Differential'

WHEN 'L'...

Hi,

yes you can, if you install a SQL 2008 R2 named Instance.

You can then use the 2008 RS to query the 2005 Instance.

Perhaps there is/was an external distribution server configured?

Anyway - is it now possible to backup and then shrink the logfile?