Know any SQL Server experts that are going for a technical job interview ?
Have some fun by giving them 60 seconds to answer as many as possible of these true/false questions.
# | Question | True | False |
1 | A clustered table is better than a heap? | ||
2 | You should never use a GUID as a primary key ? | ||
3 | Mirroring is better than replication? | ||
4 | The datetime2 data type should always be used over datetime? | ||
5 | Page compression is recommended over row compression? | ||
6 | Compressed tables are faster than uncompressed tables? | ||
7 | Adding SSD’s will make queries faster? | ||
8 | Adding more memory will make queries faster? | ||
9 | Cursors should never be used? | ||
10 | Table variables are better than temp tables? | ||
bonus | The Tabular model is faster than the MOLAP model? |
Thanks to Vedran Kesegic (SQL MCM) who popped over for dinner last night and inspired these interview questions.