Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why. *First published @ www.SQLServerCentral.com (2015/12/01) Once upon a time, there was a…
Tag: SQL Server
Fast with values slow with variables
There is a big debate why the same query can run fast with hard coded values and slow when using variables, come see there is a reasonable explanation for all this mess. The…
Clustered index row order
How rows are physically stored is well known and sometimes very misunderstood, let me show you something might not be as you expect One of the basic (and well used during interviews) questions…
Day 1 @ AdventureWorks, the Solutions
Solutions for Day 1 of exercises using the AdventureWorks sample database It’s been a while since I published Day 1 questions and I guess it’s time to post the answers I came up…
Divide and Conquer Date Search Hack
Divide and Conquer Date Search Hack (because binary search sounds boring) Divide and Conquer Date Search Hack (because binary search sounds boring) This week has been an amazing experience, not only I have…
Day 1 @ AdventureWorks, some basics about SELECT, JOINS and more
Day 1 of exercises using the AdventureWorks sample database, the SELECT statement The first day of this journey we’ll work on the most basic statement I can think of, the SELECT statement. Exercises are…
Day 0 @ AdventureWorks, setting up AdventureWorks sample database
Guide to explain how get AdventureWorks sample database and install it in your environment I wasn’t planning writing this post, because there are tons of resources available on the internet, but since I…
Welcome to your new office!
First post of a comprehensive series of exercises based on the sample database AdventureWorks Hi there! Welcome on board, you’re the candidate we have chosen to cover the junior DBA opening. Does it…