Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2016

How to remove unknown characters using T-SQL?

Always Encrypted SQL 2016 and Entity Framework 6: “Operand type clash: datetime2 is incompatible with date”

Understanding a specific type of deadlock

JSON_VALUE with square-bracket terminated JSON object

SQL Server Count records from parent category and all subcategories

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