This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting: on a turner's bench, a plain solid wooden egg sits whole beside a second egg that splits in two halves

ASCII Versus UNICODE: Inspect the First Character

November 4, 2007
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Datatype, SQL Server

ASCII versus UNICODE asks different representation questions. Compare a first UTF-8 byte with a code point while preserving the complete input.

Read More
Database properties in AdventureWorks.

SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS

August 30, 2007
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts

Two ways to check database collation using T-SQL and SSMS in SQL Server 2005, and why DATABASEPROPERTYEX in T-SQL is the one I recommend.

Read More
SQL SERVER - 2005 Collation Explanation and Translation - Part 2

SQL SERVER – 2005 Collation Explanation and Translation – Part 2

July 14, 2007
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL String

Collation Explanation and Translation, part 2: one query on sys.fn_helpcollations() lists all 1011 collations in SQL Server 2005 with a description of each.

Read More
A gouache joinery bench contrasts incompatible grooved pieces with a smoothly matched pair, beside a red checking peg.

SQL SERVER – Cannot Resolve Collation Conflict For Equal to Operation

June 11, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Collation, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server

A collation conflict means character expressions use incompatible comparison rules. I choose the intended rules before applying COLLATE.

Read More
A hand moving a magnifying glass along a shelf of plain matching books, one book pulled halfway out.

Searching Every Stored Procedure for a Word

June 1, 2007
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table

Searching every stored procedure through sys.sql_modules finds text quickly, but comments, case, dynamic SQL, and other databases need care.

Read More
Two nearly identical brass keys lying side by side on a workbench, one cut with a single notch in a different place.

SQL SERVER – Collate – Case Sensitive SQL Query Search

April 30, 2007
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL Search, SQL Server, SQL Utility

Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.

Read More
SQL SERVER - 2005 Collation Explanation and Translation

SQL SERVER – 2005 Collation Explanation and Translation

April 24, 2007
Pinal Dave
SQL Tips and Tricks
SQL Collation

How to read a SQL Server 2005 Collation name like Latin1_General_CI_AS, check which collation you have, and avoid collation conflict errors.

Read More
Previous 1 … 4 5 6 7 8 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com