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.
