Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • 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

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Dirty Records and Table Hints – Day 7 of 35

August 7, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 1. Every day one winner from United States will get Joes 2 Pros Volume 1. Dirty Records Recap Most SQL people know what a “Dirty Record”…
Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding un-matching Records – Day 5 of 35

August 5, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 1. Every day one winner from United States will get Joes 2 Pros Volume 1. Finding un-matching Records Often time we want to find records in…
Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35

August 4, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 1. Every day one winner from United States will get Joes 2 Pros Volume 1. Query Writing Strategy Some people may push back on this next…
Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding Apostrophes in String and Text – Day 3 of 35

August 3, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts, SQL Server

Answer simple quiz at the end of the blog post and –
Every day one winner from India will get Joes 2 Pros Volume 1.
Every day one winner from United States will get Joes 2 Pros Volume 1.

Finding Apostrophes in string and text

Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard Basics Recap – Day 1 of 35

August 1, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 1. Every day one winner from United States will get Joes 2 Pros Volume 1. Wildcard ranges If you have ever been to a convention where…
Read More

SQL SERVER – Win a Book a Day – Contest Rules – Day 0 of 35

August 1, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
Learning is an extremely important part of life. From the first step, everybody progresses in life and learns something new. Earlier this year, SQLAuthority.com had a month-long series on SQL Server Interview Questions. It was extremely popular series, and I received a lot of encouraging comments. While I compiled the…
Read More
Interview

SQL SERVER – The Difficult Interview Question – Moment of the Life – Day 31 of 31

July 31, 2011
Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. Complete List of all the Interview Questions and Answers Series blogs. We have spent the last 30 days going over questions and answers you may come up against…
Read More
Previous 1 … 181 182 183 184 185 186 187 … 393 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version