Case Sensitive Search - SQL in Sixty Seconds 158

preview_player
Показать описание
Let us learn how we can do a Case Sensitive Search in SQL Server.

0:00 Intro
0:11 Real World Story
0:22 Demo - Case Sensitive Search
1:11 Summary

#SQLServer #PerformanceTuning #SQLAuthority
  1. Pinal Dave
  2. SQL
  3. SQL Server
  4. SQLAuthority
  5. pinaldave
  6. Sixty Seconds
Рекомендации по теме
SQL Trick | 0:00:29

SQL Trick | Case Sensitive search

Case Sensitive Search 0:05:33

Case Sensitive Search in SQL | SQL Server | Collation Settings | Exact String Search in SQL V29

Case Sensitive Search 0:01:27

Case Sensitive Search - SQL in Sixty Seconds 158

Case Sensitive Search 0:05:38

Case Sensitive Search in SQL Server

MySQL case insensitive 0:08:11

MySQL case insensitive searching (don't use LOWER)

sql interview questions 0:00:59

sql interview questions How to handle case sensitive search filter records using collate #sqlserver

SQL Interview Question 0:06:33

SQL Interview Question | How to find strings with lower case characters | Case Insensitive | Collate

SQL Interview Question 0:01:47

SQL Interview Question # 23 - Is SQL Case Sensitive?

SQL : How 0:01:34

SQL : How to do a case sensitive search in WHERE clause (I'm using SQL Server)?

How to Perform 0:01:22

How to Perform a Case-Sensitive Search and Replace in SQL Server 2000/2005

SQL SERVER CASE 0:02:49

SQL SERVER CASE SENSITIVITY TRICK

SQL interview questions 0:00:59

SQL interview questions handling case sensitive with charindex in sql server

SQL : How 0:00:59

SQL : How to get a case sensitive version of a collation in SQL Server?

SQL : How 0:01:06

SQL : How do I perform a case-sensitive search and replace in SQL 2000/2005?

SQL : Case-sensitive 0:01:18

SQL : Case-sensitive database collation, but case-insensitive SQL queries

SQL SERVER CASE 0:01:34

SQL SERVER CASE SENSITIVITY

SQL : Case 0:01:27

SQL : Case insensitive search (and order by case insensitively) in a case-sensitive column

SQL SERVER CASE 0:01:57

SQL SERVER CASE SENSITIVITY LESSON

SQL : SQL 0:01:03

SQL : SQL Server check case-sensitivity?

SQL SERVER CASE 0:01:54

SQL SERVER CASE SENSITIVITY TUTORIAL

SQL - Part 0:03:10

SQL - Part 5 - SQL is not case sensitive

Are SQL Queries 0:00:57

Are SQL Queries Case-Sensitive? #Shorts

SQL : MYSQL 0:01:11

SQL : MYSQL case sensitive search for utf8_bin field

SQL : Case 0:01:11

SQL : Case Sensitive in Mysql using select where Query

Комментарии
Автор

Thank you very much!
I have a question though, wouldn't that have same effect as having a UDF in the where clause, causing SQL doing index scan over seek?
I had some troubles recently with one DB I was working on, tried to remove UPPER() to get a better plan using COLLATE but it had same effect as using UPPER().

Thanks Pinal and please keep going with SQL In 60 Seconds :)

frysf