Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2016

Are there any performance downsides to using ODBC date string-literals in SQL Server? Is it better than a regular string date literal?

TSQL - Round up/down to nearest SECOND

Error while using SSMS 2016 : Object cannot be cast from DBNull to other types

Duplicates in temporal history table

Calculate percentage between two values

SQL Server replace string based on another table

SQL Server Management Studio 2016 slow to reach splash screen

ssms sql-server-2016

Create View and For Json clause

sql json sql-server-2016

Everytime I start SQL Server Agent job I get an error log

OPENJSON poor performance with CROSS/OUTER APPLY and millions of rows

json sql-server-2016

Optimize JSON query processing in SQL Server 2016

How do I use OPENJSON on the result of a sub OPENJSON

json t-sql sql-server-2016

Get data as rows from array inside JSON column

How to JSON_MODIFY on Array of Array?

json sql-server-2016

Why do upserted INSERTED.ID and DELETED.ID both contain values after MERGE?

sp_helptext and definition of view being NULL

sql sql-server-2016

Merge two STRING_SPLIT

Result order of string_split?

Sql 2016 - How to get only modified column in system-versioned temporal table