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.
|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.