i think this will do it.
i'm using datemath to round the dates down to midnight of each date, and grouping by that

select DATEADD(dd, DATEDIFF(dd,0,Invoice_Exceptions.DateTime), 0)...

if you've installed SQL locally, there are aliases you can use, but you can also see what is installed and running.
if you go to start>>Run>>services.msc
it will open your...

could it be that the construction of the query, where it says COLUMNNAME IN(singlevalue) causes a range scan, where if it was COLUMNNAME = singlevalue , it would be an...

i had quite a bit of luck finding some resources here:
https://www.google.com/search?q=hardening+sql+server&rlz=1C1CHBF_enUS707US707&oq=hardening+sql+server&aqs=chrome..69i57j69i60.3839j0j7&sourceid=chrome&ie=UTF-8

this one has a decent checklist of things to do, but not the scripts and details:

if you convert time directly to datetime, itends up being 1900 anyway, so just do a direct conversion.
CONVERT(datetime,convert(time,durationvalue)) As DurationTime2 or directly like convert(datetime,durationvalue) AS DurationTime3
WITH ...

my first guess, but i converted the copy/paste to consumable data:

;WITH MySampleData([OrderNumber],[rtype],[jobnumber])
AS
(
SELECT '8316','J','1' UNION ALL
SELECT '8316','L','2' UNION ALL
SELECT '8316','K','3' UNION ALL

the fix for sql users is easy; use the procedure from microsoft to script out the users:
https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server
in my case, i drop my sql logins and just recreate them...

yeah the items in the article barely merit a nod in acknowledgment , as far as considering them disadvantages.
 i couldn't call any of them show stoppers, or identify what...

post migration, it's mandatory to rebuild all your indexes ; the statistics are different than the new sql engine expects, andyou'll see poor performance until you rebuild your indexes and...

back in SQL2000 days, there was an undocumented flag DBCC TRACEON(257) that would format xml when sent to text view; you could try that, but I'd bet you need to convert...

i had to google it myself, as my answer would have been to identify the advantages i know of instead...the things i thought of was compiled/faster code,ability to tune, code...

whatever is passed to xp_cmdshell needs to be wrapped in single quotes!
EXEC master.sys.xp_cmdshell 'bcp "SELECT * FROM MONITORING.dbo.SIZEOUT" queryout D:\DBSizes.csv -c -t, -r \n -T '

helpful consumable format, still working on the solution:

IF OBJECT_ID('tempdb.[dbo].[#ICA]') IS NOT NULL
DROP TABLE [dbo].[#ICA]
GO
CREATE TABLE [dbo].[#ICA] (
[MsgDateTime] DATETIME            NULL,
[UserName]  VARCHAR(255)               NULL,
[Application] VARCHAR(255)               NULL,