Jan 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
date null

SQL SERVER – CONVERT Empty String To Null DateTime

May 6, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL NULL, SQL Scripts, SQL Server, SQL String

Let us learn today how to CONVERT Empty String To Null DateTime. While I focus on SQL Server Performance Health Check, let us learn about it today.

Read More
Case-Sensitive Search

Case-Sensitive Search – SQL in Sixty Seconds #158

March 16, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server, SQL String

Earlier I wrote a blog post about SQL SERVER – Case-Sensitive Search. Lots of people said I should make a video on this topic.

Read More
case-sensitive

SQL SERVER – Case-Sensitive Search

March 15, 2021
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL Search, SQL Server, SQL String

How to do a Case-sensitive Search? I was asked this by one of my clients of Comprehensive Database Performance Health Check.

Read More
check constraint

SQL SERVER – CHECK CONSTRAINT to Allow Only Digits in Column

February 1, 2021
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Function, SQL Scripts, SQL Server, SQL String

My client during Comprehensive Database Performance Health Check. Today we will learn about CHECK CONSTRAINT to Allow Only Digits in Column.

Read More
nvarchar

What is N in nvarchar? – Interview Question of the Week #301

January 21, 2021
Pinal Dave
SQL Interview Questions and Answers
Data Type, SQL Server, SQL String

Question: What is N in nvarchar?

Answer: n in nvarchar or nchar stands for world national. Let us learn today about datatypes.

Read More
Text Output

SQL SERVER Management Studio – Grid vs Text Output

January 15, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, SQL String, SSMS

they asked me questions if I know how to fix it. Well, it is actually very simple and we need to learn about Grid vs Text Output.

Read More
unicode character strings

SQL SERVER – Datatype Storing Unicode Character Strings

September 30, 2020
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Scripts, SQL Server, SQL String

I explained how Unicode datatype works, you can read that blog here SQL SERVER – Storing a Non-English String in Table – Unicode character strings.

Read More
1 2 3 4 … 11 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version