Chad Baldwin chadbaldwin

Odd (and inconsistent) behaviour with datetime/datetime2 comparisons

Test results for SQL Server feedback submission:

Tested against all available compat levels for docker tags:

	<?xml version="1.0" encoding="utf-16"?>
	<ShowPlanXML xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Version="1.564" Build="16.0.4205.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
	<BatchSequence>
	<Batch>
	<Statements>
	<StmtSimple StatementCompId="2" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="160" StatementSubTreeCost="126.466" StatementText="UPDATE dbo.vw_FooFiltered SET Code = 'ABC' WHERE FooID = @FooID" StatementType="UPDATE" QueryHash="0xD280ECD9D3E6F9E2" QueryPlanHash="0x45FC3E4D8415E259" RetrievedFromCache="true" StatementSqlHandle="0x09009E9BB574372BDDFB48BD416DC587C0EE0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="1" SecurityPolicyApplied="false">
	<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="false" CONCAT_NULL

	DROP TABLE IF EXISTS #clicky_data;
	CREATE TABLE #clicky_data (
	random_text nvarchar(MAX) NULL,
	);

	INSERT #clicky_data (random_text)
	VALUES (OBJECT_DEFINITION(-495130372)) -- sys.dm_db_partition_stats
	, (OBJECT_DEFINITION(-411581074)) -- sys.dm_exec_query_stats
	-- , (N'This is a ?> test <? bleh')
	, (N'This '+NCHAR(0)+' is a '+NCHAR(18)+N' test '+NCHAR(20)+N' bleh')

	import re
	from typing import Dict, List, Optional, Union
	from dataclasses import dataclass

	@dataclass
	class BoxImport:
	"""Represents a single import statement within box::use()"""
	module: str
	alias: Optional[str] = None
	functions: Optional[List[str]] = None

	------------------------------------------------------------
	GO
	------------------------------------------------------------
	SELECT [CurrentDB] = (SELECT x.recovery_model_desc FROM sys.databases x WHERE [name] = DB_NAME())
	------------------------------------------------------------------------------
	GO
	------------------------------------------------------------------------------
	IF OBJECT_ID('tempdb..#tmp_log_track','U') IS NOT NULL DROP TABLE #tmp_log_track; --SELECT * FROM #tmp_log_track
	CREATE TABLE #tmp_log_track (
	ID int NOT NULL IDENTITY(1,1),

	{
	"OriginalBase64": "JgB4AQABIJASEhISEjcSEhISEhMRExISEjYSNhITETcRNxE3EzYSNhISEjcRExETERMRExETEhITNhISEjcRNxE3ETcSNhI2EgAE5wABH0kSAAv1AAEgSBEAC/UAASBJEgAL9QABH0kSAAv1AAEgSREAC/UAASBJEgAL9gABH0gSAAv2AAEgSBIAC/UAASBJEgAL9gABH0kRAAv2AAEgSBIAC/UAASBIEwAL9QABH0kSAAv1AAEgSREAC/UAASBJEgAL9gABH0kRAAv1AAEhSBEAC/YAASBIEgAL9QABIEkRAAv2AAEgSBEAC/YAASBIEwAL9QABH0oRAAv1AAEgSBIAC/UAASBJEgAL9QABH0kSAAv1AAEgSBEAC/YAASBIEwAL9QABH0kSAAv1AAEgSBIAC/UAASBJEgAL9QABH0oRAAv1AAEgSREAC/UAASBJEgAL9QABIEkRAAv1AAEgSREAC/UAASFIEgAL9QABH0oRAAv1AAEhSBIADQU=",
	"RawMessage": [
	38, 0, 120, 1, 0, 1, 32, 144, 18, 18, 18, 18, 18, 55, 18, 18, 18, 18, 18, 19, 17, 19, 18, 18, 18, 54,
	18, 54, 18, 19, 17, 55, 17, 55, 17, 55, 19, 54, 18, 54, 18, 18, 18, 55, 17, 19, 17, 19, 17, 19, 17, 19,
	17, 19, 18, 18, 19, 54, 18, 18, 18, 55, 17, 55, 17, 55, 17, 55, 18, 54, 18, 54, 18, 0, 4, 231, 0, 1, 31,
	73, 18, 0, 11, 245, 0, 1, 32, 72, 17, 0, 11, 245, 0, 1, 32, 73, 18, 0, 11, 245, 0, 1, 31, 73, 18, 0, 11,
	245, 0, 1, 32, 73, 17, 0, 11, 245, 0

	$base64 = 'JgB4AQABIJASEhISEjcSEhISEhMRExISEjYSNhITETcRNxE3EzYSNhISEjcRExETERMRExETEhITNhISEjcRNxE3ETcSNhI2EgAE5wABH0kSAAv1AAEgSBEAC/UAASBJEgAL9QABH0kSAAv1AAEgSREAC/UAASBJEgAL9gABH0gSAAv2AAEgSBIAC/UAASBJEgAL9gABH0kRAAv2AAEgSBIAC/UAASBIEwAL9QABH0kSAAv1AAEgSREAC/UAASBJEgAL9gABH0kRAAv1AAEhSBEAC/YAASBIEgAL9QABIEkRAAv2AAEgSBEAC/YAASBIEwAL9QABH0oRAAv1AAEgSBIAC/UAASBJEgAL9QABH0kSAAv1AAEgSBEAC/YAASBIEwAL9QABH0kSAAv1AAEgSBIAC/UAASBJEgAL9QABH0oRAAv1AAEgSREAC/UAASBJEgAL9QABIEkRAAv1AAEgSREAC/UAASFIEgAL9QABH0oRAAv1AAEhSBIADQU='

	$output = [pscustomobject]@{
	OriginalBase64 = $base64
	RawMessage = [System.Convert]::FromBase64String($base64)
	MessageType = $null
	RepeatCount = $null
	MessageLength = $null
	InitialPulse = $null
	NECMessage = [uint]::MinValue # 4 byte int to store the 4 NEC message sections

	------------------------------------------------------------------------------
	GO
	------------------------------------------------------------------------------
	DROP VIEW IF EXISTS dbo.vw_TableSize_Snapshots;
	GO
	CREATE OR ALTER VIEW dbo.vw_TableSize_Snapshots
	WITH SCHEMABINDING
	AS
	SELECT InstanceID, DatabaseID, SnapshotDate, ObjectCount = COUNT_BIG(*)
	FROM dbo.TableSize

	Add some sort of "reset_time" or similar to Index stats DMVs
	https://feedback.azure.com/d365community/idea/e9e84bf2-64c4-ee11-92bc-000d3a0fb290

	Output warning message when altering an indexed view that all indexes (clustered and non-clustered will be dropped)
	https://feedback.azure.com/d365community/idea/0f1f2993-43b6-ee11-92bc-000d3a033659

	Statement execution duration global variable - Similar to @@ROWCOUNT, but instead how long the previous statement took to run
	https://feedback.azure.com/d365community/idea/884c86b1-9b85-ee11-a81c-000d3ae5ae95

	# Run this script from within the git repo you want to copy data OUT of

	$copyTo = 'C:\MyTestFolder'

	$ErrorActionPreference = 'Stop'

	$currBranch = git branch --show-current
	$repoRoot = git rev-parse --show-toplevel

	if ($LASTEXITCODE -gt 0) { return }