Paul

Rather than me woffle on about this, have a look at BOL under 'BACKUP LOG'. There's a paragraph entitled 'Creating a Sequence of Transaction Log Backups', which shows interleaving full...

As far as log shipping is concerned, full and differential backups have no effect on the Transaction Log backup cycle.

We log ship every 2 minutes between primary and secondary. Full...

Also look at the last part of your WHERE clause. You should be using IS NULL instead of = NULL

Try using a derived table e.g.

select max(salary) from

(select max(sal) salary from account

union select max(sal) from sales

union select max(sal) from marketing) as allsalaries

Tim

The SELECT TOP is performing a sort because you asked it to by specifying an ORDER BY clause.

The only difference is that that the combination of TOP and ORDER BY...

SELECT ACC,MAX(ACCDATE) FROM tablename GROUP BY ACC

Tim

The answer lies in the query plan generated by the two queries. One generates a 'Sort', the other generates a 'Sort/TopN Sort'. Obviously the SQL Server code for these is...

I'm not sure I agree with your statement about IN being more efficient than JOIN.

SQL Server treats an IN statement as an OR, and frequently an OR will stop SQL...

Am I missing something here?

The two rows returned have the same value (1)for the ORDER BY column (contract), therefore SQL Server cannot guarantee which order they will return in.

If...

SQL Server is rounding because you are performing the maths on 2 smallint fields.

If you convert your smallint fields to decimal before doing the maths, it will not round. e.g.

declare...

Have you tried embedding a CR/LF in the output where you want it to split e.g.

declare @txt varchar(255)

set @txt = 'Hello there' + char(13) + char(10) + 'this is the...

There doesn't seem to be anything wrong with the path.

Does SQL Server run as the system account (in which case it has no network access), or as a domain account...

Does your file server have any quota limits on disk space?

Chris

I raised virtually the same issue on these forums a few months ago, and got the same response as you... Nothing.

The execution plan just shows a table scan for the...

To stop SELECT INTO from creating columns as nullable use the ISNULL function on the columns e.g.:-

select isnull(id,0) as id,isnull(status,'') as status into tableACopy from tablea

It's a bit of a...