Really comes down to six and half dozen the other. Personal experience on my system at home had fewer larger cross joins ran faster when I wanted millions of...

Bob Hovious (3/12/2009)

You are absolutely correct. When asking for more information, I just asked for complete text of errors,...

Yes, you really should do each backup to a separate file. If you are appending backups to the same file you have to specify which file to restore from...

Here is another solution:

with

a1 as (select 1 as N union all

select 1 union all

select 1 union...

Please post the code you used for both your backups and restores.

How are you looking for elapsed time to be returned? Not knowing your data, I don't know if I need to worry about elapsed time going over 24 hours...

Not sure why that would give you a problem, you are using varchar(max) in your...

The other alternative put a where clause on your inserts that checks for the existance of those three values existing in the database already.

You can also drop the NOLOCK hint. It is ignored any way on INSERT, UPDATE, and DELETE statements.

How about trying the following code:

create function dbo.DelimitedSplit (

@pString varchar(max),

@pDelimiter char(1)

)

returns table

as

return

with

a1 as (select 1 as N union all

...

Please confirm that the purpose of the function is to return a table of items from a delimited string.

For example, given the string "'A','B','C','D','E'" return the following:

1 A

2...

Here is my .02. I'd prefer to do native backups to local disks, then backup the backup files to tape or other remote storage media. Reason, it is...

Nice it would be if feedback OP would provide.

Check out the following code and see if it does what you need:

select getdate(), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0) + 4

GilaMonster (3/11/2009)

Bet you a coffee that either he comes back...