As several others have mentioned in comments and other answers to your question the core issue is 2015-07-27 23:59:59.999 is being rounded to 2015-07-28 00:00:00.000 by SQL Server. Per the documentation for DATETIME:
Time range - 00:00:00 through 23:59:59.997
Note that the time range can ne...
Setup:
create table dbo.T
(
ID int identity primary key,
XMLDoc xml not null
);
insert into dbo.T(XMLDoc)
select (
select N.Number
for xml path(''), type
)
from (
select top(10000) row_number() over(order by (select null)) as Number
from sys.columns as c1, sys...
I am using SQL Server 2012.
I have written the query below which works fine apart from when I include the last line 'where NomDiff <> 0'.
It tells me NomDiff is an invalid column name. I don't understand why and don't know how to get the query to return only rows where the nomDiff is not equal ...
Using APPLY VALUES is a good way of not having to use a subquery, or another CTE:
WITH pf
AS ( SELECT
Name ,
Sedol ,
Nominal
FROM tblTempPLF
WHERE FundCode = 'CSGE'
),
pc
AS ( SELECT
Name ,
Sedol ,
Nominal
FROM tblTempPCF
WHERE F...
Imagine a junior database developer / DBA that may not have an avenue to get their SQL code reviewed for best practices and such as they are learning the ropes. There is of course the Code Review Stack Exchange (CR.SE) site, which can and will review SQL if it is posted and falls within the site ...
Running the below SQL/XPath query returns the following error:
Query:
;WITH XMLNAMESPACES (
'http://schemas.microsoft.com/win/2004/08/events/event' as ns
, default 'http://schemas.microsoft.com/win/2004/08/events/event'
)
select [Events].[Event].value('(./System/TimeCreated/@SystemTime)[1]',...
The .value method must always return a single value so you normally wrap it in brackets and move the ordinal ( eg [1] ) to the end. Here's an example:
DECLARE @xml AS XML = '<DATA>
<ROW RowNumber="1">
<COLUMN Name="ProdID" Value="1234" />
<COLUMN Name="AppID" Value="20144" />
<COL...
Not sure if it's a bug, per se but it's definitely an interesting occurrence. Online partition rebuilds are new in SQL Server 2014 so there may be some internals to sort through with this.
Here's my best explanation for you. Incremental statistics absolutely require that all partitions be sampl...
