SQL Centre of Excellence

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.

blog comments powered by Disqus

Page List

Page List