Viewing 15 posts - 1 through 15 (of 216 total)
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...
December 20, 2023 at 3:21 pm
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...
December 20, 2023 at 3:09 pm
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...
June 24, 2020 at 2:03 pm
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...
June 23, 2020 at 2:13 pm
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...
December 11, 2018 at 1:35 am
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...
March 28, 2017 at 4:56 am
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...
September 16, 2014 at 1:23 am
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 =...
July 17, 2014 at 4:09 am
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...
December 5, 2013 at 4:38 am
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...
April 26, 2012 at 7:14 am
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...
April 26, 2012 at 2:22 am
What was the answer to the question 'why?'?
October 25, 2011 at 2:06 am
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...
June 6, 2011 at 5:28 am
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...
June 6, 2011 at 5:19 am
In the definition of the linked server, is 'ORACLESP' the resolved name from tnsnames, or is it the actual server name? Or either?
June 6, 2011 at 2:49 am
Viewing 15 posts - 1 through 15 (of 216 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy