Thanks, good to have confirmation on that.  So.  Perhaps the person that started this whole subject could look to his index-rebuilding sequences to see if that is why his transaction logs...

This may be a very basic question, but do index rebuilds grow the transaction logs? 

I have a nightly job that goes through these steps.  First, DBCC, second Update Statistics,...

The best, most comprehensive:

Inside Microsoft SQL Server 2005: T-SQL Querying by Itzik Ben-Gan

Another good reason for only rebuilding indexes only when it is significant to do so is that the index rebuilds get logged as transactions.  These transaction logs, which are really only related to...

This is great.  Thanks very much.

I for one would love to have the script, i am up to my ears in this, multiple databases, multiple servers. 

i've set up jobs on busy databases to check...

Thanks very much Grant.  I can use that info.

I just assumed that Microsoft would have published a generic but comprehensive Best Practices document or link, and that, even after searching for...

you can use an ActiveX Script task to invoke an Access macro, in an .mdb or an .adp

in the ActiveX script box just type in the full path to the...

My particular backup problem is that when I do a full backup on some transaction-heavy databases that have their recovery models set to Full, the first hourly transaction log - .trn...

Thank you, this is very helpful.  I am taking on a new assignment, and will be building a data warehouse.  This is a great example of how to monitor for...

This works to give you the last day of the previous month, in case you wanted that:

select getdate()-datepart(day,getdate())

Thank you, that's what i needed to see, a test.  I appreciate the effort.

So in this instance, in practice, theory and practice were the same, meaning that the theory: "In...

Try adding a function like this:

--=========================

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE  FUNCTION GetAgeInYears

--mcarey 6/1/2005  

--declare input variables:

   (@DOB datetime, --DateOfBirth

    @AsOfDate datetime) --DateForWhichAge is being Calculated

RETURNS decimal(6,1) -- AgeInYears

AS

BEGIN

 ...

did you try

where isnull(selectionvalue,0) <> 0

?

Here's what I do.  This stored procedure query looks for errors in a table after users at various sites have entered data.  If a site has no errors, they get a report...