And there's the root cause of your problems. This table design is a violation...

Ed Wagner (2/29/2016)

---

Hugo Kornelis (2/29/2016)

---

jimtimber (2/29/2016)

---

Can I please ask, what would the code be to convert just the time part of a datetime entry to miliseconds. So, for example if...

jimtimber (2/29/2016)

---

Can I please ask, what would the code be to convert just the time part of a datetime entry to miliseconds. So, for example if SQL has this: 01/01/2016...

So why not write this as

WHERE A.1PKCOLUMN='DATE'

AND A.2PKCOLUMN > '+SEQ'

That would make it far easier for SQL Server to estimate the cardinality, and it does exactly...

Hi Noob (is that actaully your real name??),

However, i am not able to find any concept related documentaion

(e.g. relationship between instance/database in SQL server, logical/physical structures in SQL server etc).

Did...

In a query tool such as SSMS or sqlcmd.exe, execute a query such as SELECT StartDateTime FROM YourTableName;

These tools present the data in a very raw fashion, so you will...

Q1:

The documentation pages currently default to SQL Server 2016 (unfortunately, since it is not even officially released yet; it's in CTP - a fancy term for a public betatest).

However, on...

The code that extracts the time is not rounding up, it is truncating. It is the other display (Excel, if I understand your reply correctly) that does the rounding.

You write...

Hi Bantrim,

Unfortunately I cannot assist you in finding off-the-shelf packages that fit your needs. This is not an area I ever had to investigate. But I am happy to hear...

Hi Bantrim,

You post a lot of information, which is always good. However, the complexity of the problem may be beyond what can be solved -or rather, what I am prepared...

If the data type of the column is datetime, then it stores fractional seconds as well, with a precision of 1/300th of a second. The CONVERT with style 108 that...

Good question, and I am glad that the answer I expected to be correct was not listed.

I do want to point out a few things, though.

First, on ISNULL - the...

Let me correct that: it may be a correct design decision....

I'm a bit late to the party, but depending on what version of SQL Server you are on, have you looked at using TRY_CAST insterad of trying to build it...

SQL Server rowstore indexes are stored as balanced trees (*). SQL Server does not use binary trees. I am not aware of any official ruling on what the shorthand "B-tree"...