Quite often I get request if I send blog post in newsletter or through email. Here are few important links.
You can for sure get email of my post, however, I strongly suggest to visit blog as if there are any updates in my post they are reflected on blog.
Subscribe to blog post through email
Search SQLAuthority – This is very powerful search. Give it a try.
Follow me on Twitter
Reference: Pinal Dave (https://blog.sqlauthority.com)
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
3 Comments. Leave new
Please subscribe me for the daily newsletter.
Thank & Best Regards,
Sandeep
select * from dbo.TempCh where [customer name] like ‘上海精元机械有限公司’ collate Chinese_PRC_CI_AI_KS_WS
Default Collation:SQL_Latin1_General_CP1_CI_AS
[customer name] Column collation :Chinese_PRC_CI_AI_KS_WS
I have record in TempCh with ‘上海精元机械有限公司’ customer name.
but in my above query i do not get row.
What to do ? Any one has idea?
Thanks
Darshan Shah
What happens when you try this?
select * from dbo.TempCh where [customer name] like N‘上海精元机械有限公司’ collate Chinese_PRC_CI_AI_KS_WS