SQL Server Trivia
August 23, 2010 3 Comments
Think you know SQL Server past and present? Here are the next-to-impossible questions I asked at the SQLSaturday #51 Stump The Experts session in Nashville. There were a few people who apparently have far more active brain cells than me who managed to answer a couple of these questions. But for the most part, these questions, did indeed, stump the experts.
Let’s see how you do.
The Trivia Questions
True or False. The following T-SQL statement is valid.
CREATE TABLE # (Column1 INT);
What’s the maximum number of nonclustered indexes per table for a 64-bit instance of SQL Server 2008 R2?
There was a little known and cancelled upgrade to Windows 95 that eventually became known as Windows Desktop Update, Internet Explorer 4.0. What was its codename?
For what processors was SQL Server 4.21a SP4 available?
When did Mainstream Support end for SQL Server 2000 Enterprise Edition?
What is the maximum number of columns you can have in a single SELECT statement in a 64-bit instance of SQL Server 2008 R2?
What was the final name of the SQL Server feature that originally was known by the code name Rosetta?
What command displays information about the installed versions and registered instances of Notification Services?
How many task in SSIS for SQL Server 2008 R2 are designed for SSAS?
On what operating systems did SQL Server 4.20 run?
How many copies of a query plan can be in memory at one time in SQL Server 2008 R2?
In how many different North American cities has the PASS Community Summit been held?
Name one aspect of SQL Server that separate it from any other Microsoft product.
For which operating system was SQL Server originally developed?
In SQL Server 2008 R2, how many DMVs are related to Indexes?
How much was an unlimited user license for SQL Server 1.1?
When was SQL Server 1.1 released?
When SQL Server 1.1 was first released, it was considered to be well behind in sales compared to Oracle Server for OS/2. How many licenses had Oracle sold already?
True or False. SQL CE can be managed from SQL Server Management Studio 2005.
When AUTO_UPDATE_STATISTICS is ON, updated statistics or cardinality changes to which of the follow tables cause a recompile?
a) User Tables
b) Temporary Tables
c) Inserted Tables
d) Deleted Tables
True. But it’s scheduled to be deprecated in a post SQL Server 2008 R2 release. (http://bit.ly/sqlsat51-1)
SQL Server 4.21a Service Pack 4 was available for Intel (x86), MIPS, and Alpha-based computers. (http://bit.ly/sqlsat51-4)
April 8th, 2008 (http://bit.ly/sqlsat51-5)
Reporting Services (http://bit.ly/sqlsat51-7)
NSControl ListVersions (http://bit.ly/sqlsat51-8)
Windows NT 3.1/Windows NT Advanced Server 3.1 (http://bit.ly/sqlsat51-10)
2; one for parallel execution and another for serialized execution. (http://bit.ly/sqlsat51-11)
6; Chicago, San Francisco, Denver, Seattle, Orlando, Dallas/Grapevine (http://bit.ly/sqlsat51-12)
SQL Server is the only Microsoft product that allows you to set processor affinity. (via Buck Woody)
UNIX; that’s why SQL Server still has processor affinity on a SMP operating system. (via Buck Woody)
August 20th, 1990 (http://bit.ly/sqlsat51-17)
All of the above. (http://bit.ly/sqlsat51-20)
So how did you do? Got any other good trivia questions that I could have / should have added to the list?
And a very special thanks to our panel of experts – Thomas LaRock, Jason Strate, Kendra Little, Jeremiah Peschka, Louis Davidson, and Kevin Boles!