Script to create demo database and load data for statistics and R
Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...
2016-07-15
293 reads
Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...
2016-07-15
293 reads
I started my re-discovery of statistics with an introduction here. This second post is about descriptive statistics – very basic, simple...
2016-07-14
1,104 reads
I was a student of statistics in school and college. I didn’t get to use much of anything I learned...
2016-07-10
674 reads
This month’s TSQL Tuesday post is from one of my favorite people in the community – Jorge Segarra a.k.a. SQL Chicken. It...
2016-02-17
445 reads
For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but...
2016-02-02
297 reads
I have been following the series of posts written by my friend and SQL MCM Wayne Sheffield on some TSQL...
2016-01-19
259 reads
Continuing with the recipes in SQL Server 2012 T-SQL recipes book – I was drawn to this puzzle that asked for...
2015-12-14
770 reads
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Comments posted to this topic are about the item Where Your Value Separates You...
Comments posted to this topic are about the item Fixing the Error
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers