So are you saying the container_id is null in sys.allocation_units?

And that this query gives the same kind of results?

select container_id, sum(total_pages)/128 SizeMB
from sys.allocation_units
group by container_id
order by SizeMB...

I would look at the type on sys.allocation_units as well - this may explain if you have a lot of data in large-objects, or in columnstore indexes.

Type of allocation unit:

0...

You are right in thinking that the full backup does not break the log chain -  a full backup is a backup of the database, together with enough of the...

You have to take account of the namespace in the XML - it's like a qualifier

So you can either alias the namespace

with xmlnamespaces ('http://www.opengis.net/kml/2.2' as kmlns)
SELECT
T.c.value ('(kmlns:name)[1]','varchar...

One of the benefits of table variables is that they don't cause recompiles - whereas adding data to a temp table can.  Now, this is the crux of the issue...

The first query in the script doesn't return any data for the following inputs

DECLARE @BirthDate datetime, @Today DATETIME
select @BirthDate='1976-02-29', @Today='2017-03-28'

DECLARE...

I'm glad Jeff Moden has pitched in here.

I've been using a lot of hierarchical data in a current project, and Jeff's articles have helped immensely. I really do recommend...

Nice.

A simpler (IMHO) way of determining the ROWID is to simply subtract the Remainder from the RowNumber, a technique used a lot in "Gaps and Islands" solutions.

select

max(case when remainder =...

Most of the examples so far have demonstrated the OVER clause used with aggregate (MIN, AVG, COUNT, etc) functions, or with ranking (ROW_NUMBER, DENSE_RANK etc) functions. In SQL2012, the...

Peter-757102 : whilst I agree you that the observed effects are down to misunderstanding the order by clause, and not some sort of misbehaving case statement, I don't understand your...

Wait a minute! What about that "ASC," after the END of the first CASE statement, above? If that CASE statement does not produce output, then wouldn't the four...

What was the answer to the question 'why?'?

Rudy,

the ORACLESRV1 is just the name of the linked server, that you can then reference in SQL - that shouldn't have any effect?

Yes I have the Oracle client...

Thought it was, still doesn't help me.

I have the error

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLESRV1".

OLE DB provider "OraOLEDB.Oracle" for...

In the definition of the linked server, is 'ORACLESP' the resolved name from tnsnames, or is it the actual server name? Or either?