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
A loaf of bread on a cooling rack in front of a new oven, one end darker than the rest

Migrating From MySQL to SQL Server: The Gotchas

January 9, 2010
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Collation, SQL Migration, SQL Server

Migrating from MySQL to SQL Server needs identity, collation, paging, and date rules, with SSMA assessing and converting the bulk of the work.

Read More
SQL SERVER - Change Collation of Database Column - T-SQL Script - Consolidating Collations - Extention Script

SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script

October 19, 2009
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL Utility

Brian Cidern’s extension script for consolidating collations across a database, a big help when you face the annoying cannot resolve collation error.

Read More
An open wooden specimen case holds cylinders, small blocks and polished stone spheres in separate compartments.

NULLIF Text: Collation Decides Whether Values Match

March 12, 2009
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Function, SQL Server

NULLIF text comparisons can remove a matching value. Select the matching rule explicitly and preserve the first expression’s return contract.

Read More
A hand placing the last red pencil into a tin of pencils sorted by color

Choosing the Server Collation at Install Time

February 9, 2009
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Server, SQL Server Installation, SQL TempDB

Choose the server collation before installation by checking application comparisons, tempdb behavior, and the cost of changing an instance later.

Read More
Database column collation.

SQL SERVER – Change Collation of Database Column – T-SQL Script

December 20, 2008
Pinal Dave
SQL Performance
SQL Collation, SQL Scripts, SQL Server Security, SQL Utility

How to change collation of database column with ALTER TABLE ALTER COLUMN and COLLATE, then check it in sys.columns. A short test script shows each step.

Read More
SQL Server query execution plan.

SQL SERVER – Find Collation of Database and Table Column Using T-SQL

December 16, 2008
Pinal Dave
SQL Tips and Tricks
Database, SQL Collation, SQL Scripts, SQL Server Management Studio

A quick tip to find the collation of database and table column in SQL Server with DATABASEPROPERTYEX and sys.columns, using AdventureWorks.

Read More
The same nine mosaic pieces grouped by color in one tray and by shape in another.

SQL Server – Good Articles on Database Collation

April 4, 2008
Pinal Dave
SQL Tips and Tricks
Database, DBA, SQL Collation, SQL Server

Database Collation defines default character comparison rules for a database. I also inspect the columns and expressions involved.

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

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