Suggestions for PASS Published on SSC
I wrote this article shortly after returning from the PASS 2007 Summit and tried hard to come up with ideas...
2007-10-18
1,348 reads
I wrote this article shortly after returning from the PASS 2007 Summit and tried hard to come up with ideas...
2007-10-18
1,348 reads
All of these are new articles that have gone up on SSC recently. The troubleshooting one was my attempt to...
2007-10-14
627 reads
Bill Graziano (main man at SQLTeam.com, consultant, and VP of PASS) was in town recently to speak at both the...
2007-10-13
682 reads
I'm catching up on my reading today and ran across an article from Kathi Kellenberger called Understanding the Difference between...
2007-10-13
603 reads
I'm a couple days late updating the blog, the article went up on Mon.
2007-10-11
571 reads
Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.
2007-10-08
9,122 reads
I spent last week onsite with a client teaching performance tuning and it was really a good week. Great company...
2007-10-08
606 reads
SQL Server guru Andy Warren brings us a list of things that he considers when things go wrong. Read about some of the common sense approaches to solving performance and other problems.
2007-10-03
4,594 reads
This article by Andy warren shows you how to get started with DMO using either VB or VBScript. The article includes sample code that will backup all databases on a server and will update the statistics on all databases as well.
2007-10-02 (first published: 2003-08-15)
39,126 reads
This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5
2007-10-02 (first published: 2001-05-01)
10,931 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