Mark

I'm not sure what your point is. The question is about compressed databases (not compressed disks), as was my reply. I apologise if I didn't word mine clearly.

I...

I think you're assuming this question is more complicated than it actually is. What it's actually saying is this: "I have two databases that take up the same size...

Precisely. ...

OK, so fix that. When you set the value of a scalar variable, you can only pass a single value to it. If the SELECT statement you use...

You need to do it before, not after.

John

The first thing to try is to put a SELECT @ADR3 statement in just after you set the value of the variable. Then you can see whether the problem...

Happy to help, and I'm glad it turned out so well. Please will you share your solution, in case anyone else has a similar issue and wonders how you...

Jeff's and Lynn's queries return the last value, which, as was pointed out, isn't necessarily the largest. Depending on what the exact requirement here is, it may be worth...

I remember once having a conversation with the support team of another vendor of third-party backup software, and resigning myself to the fact that I was going to have to...

If you take a differential backup, you'll need the original backup as well. But yes, your differential is likely to be almost as large as a full backup. ...

You can write your stored procedure with a table-valued parameter instead of scalar parameters. You'd need to use an OUTPUT clause on your INSERT statement instead of relying on...

Here's one way, but I'm not sure that it's the best. Create a table called ForbiddenPatterns with columns Size, Colour, Pattern. Insert one row for each forbidden combination....

You can check the authentication mode in the registry. If it's set to Windows only, change it to Mixed and try sa again. If that doesn't work, you...

So the answer to your original question is no, it's not overkill. You can't rely on the clustered index for sorting query results. Parallelism, advanced scans and other...

Fairly simple in T-SQL, as well:

SELECT

a.RowNumber

,a.name

,a.dQty

,a.Price

,b.RowNumber

,b.name

,b.dQty

,b.Price

FROM

MyTable a

LEFT JOIN

MyTable b ON a.RowNUmber + 1 = b.RowNumber and a.RowNumber%2 = 1

John