Tips for Querying Special Characters with wildcards, since some symbols are tricky to pattern match. Examples use the [Grant] table in the JProCo database.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard Basics Recap – Day 1 of 35
A recap of wildcard basics from Joes 2 Pros: how wildcard ranges work with LIKE, explained with a convention registration desk example.
Large IN Lists: When a Temp Table Beats Thousands of Values
Pasting thousands of IDs into an IN list works, until it does not. See where the time goes and how to keep the answer the same with a temp table.
SQL SERVER – The Difficult Interview Question – Moment of the Life – Day 31 of 31
The last day of my interview series is about the difficult interview question: acing an interview is sometimes about personality and reasoning, not only right answers.
SQL SERVER – Interview Questions and Answers – Guest Post by Jacob Sebastian – Day 30 of 31
SQL Server MVP Jacob Sebastian, author of The Art of XSD, adds his own interview questions and answers to the series in this guest post.
SQL SERVER – Interview Questions and Answers – Guest Post by Feodor Georgiev – Day 29 of 31
Feodor Georgiev’s guest post in my interview questions and answers series is part 2 of his take on job interviewing the right way and for the right reasons.
SQL SERVER – Interview Questions and Answers – Guest Post by Nakul Vachhrajani – Day 28 of 31
Nakul Vachhrajani’s guest post for my interview questions and answers series starts with what an interview really is and why we all face them.