Viewing 15 posts - 1 through 15 (of 214 total)
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)SELECTT.c.value ('(kmlns:name)','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'
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
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.
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
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
Being a DBA is not a 9-5 job, 5 days-a-week. You can't switch off when you leave the office, but unfortunately you do disconnect from your work place. ...
December 13, 2010 at 9:55 am
I knew there would be a reason, it's just a shame it wasn't communicated as well, or as soon as it could have been - but hey, lots of companies...
June 28, 2010 at 9:27 am