A 78 GB log file for a 3 TB database is less than 3% the size of your data, so that seems far too small. You probably need 10% or...

I use a simpler method: I just pay cash.

Just sounds like a stupid example. If you are doing log backups, you want to do them often.

Avraham de-Haan (10/23/2007)

---

select HexName=convert(varbinary,name), name from master.dbo.sysdatabases order by name

HexName ...

What output do you get when you run this query?

[font="Courier New"]select HexName=convert(varbinary,name), name from master.dbo.sysdatabases order by name[/font]

select

Avg_time =

avg(convert(numeric(10,8),round(datediff(ms,dateadd(dd,datediff(dd,0,a.DT),0),a.DT)/3600000.0000,8)))

from

MyTable a

where

Col_a in ('a', 'b', 'c', 'd')

Marcus Farrugia (10/18/2007)

---

Thanks everyone for your replies,

Matt your reply was the one I went with that ended up working great.

ALZBA I wasn't sure how to apply your solution, because I'm...

I think this does what you want.

select

TIME_NUMERIC,

-- Convert from number back to datetime on day 1900-01-01

BACK_TO_TIME = dateadd(ms,TIME_NUMERIC*3600000.0000,0),

DT

from

(

select

TIME_NUMERIC =

-- Extracts time only from date and converts it to numeric

convert(numeric(10,8),round(datediff(ms,dateadd(dd,datediff(dd,0,DT),0),DT)/3600000.0000,8)),

DT

from

(

-- Test...

There are many good reasons to have a date dimension table, so you might as well have one.

The following should give you a good start on creating a date dimension...

JonJon (10/10/2007)

---

Is there anywhere I can get a SP to create a dates table.

It needs to include

Day, Month, Year, Fiscal Day, Fiscal Month, Fiscal Year, Week Number and Day...

I think this would be much simpler:

[font="Courier New"]Declare@RequestID int,

@ErrorMessage varchar(250),

@SubstitutionProcedureName varchar(250),

@SQLString nvarchar(500),

@ParmDefinition nvarchar(500),

@DynErrorMessage varchar(250),

@RowCount int

execute @SubstitutionProcedureName

@RequestID = @RequestID, @ElementID = @UnDelimitedValue, @RowCount= @RowCount OUTPUT, @ErrorMessage = @ErrorMessage OUTPUT[/font]

Why do you want to use sp_executesql to execute the procedure?

If you really feel the need to build a new database everyday, it would be simpler to just drop the old database when the load is done, and rename the...

This works well for me

1. Set delivery date

2. Do some programming

3. Test

4. If test is good, go live, else go live

5. Define requirements

6. Repeat 1 through 5 until system is...

Carl Federl (10/4/2007)

---

Q: How many Oracle DBAs does it take to change a light bulb ?

A: Three - it takes three Oracle DBAs to do anything.

Q: How many SQL Server...