SQL Server 2008 Interview Questions and Answers Part 4: which command shows the version of SQL server and operating system, what SQL Server Agent is, and more.
SQL SERVER – 2008 – Interview Questions and Answers Part 3
SQL Server 2008 Interview Questions and Answers Part 3: which TCP/IP port SQL Server uses, and the difference between a clustered and non-clustered index.
SQL SERVER – Interview Questions and Answers – Part 2
This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox
SQL SERVER – 2008 Interview Questions and Answers – Part 1
Part 1 of my SQL Server 2008 interview questions and answers covers general questions like what is RDBMS and the properties of relational tables.
IN With NULL: Show the Unknown Comparison
IN with NULL can produce UNKNOWN instead of false. Compare a positive match, an unmatched value and a missing input without hiding the truth state.
SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint
How to create a Primary Key, Foreign Key and Default constraint in SQL Server 2008, at column level, at table level, or after the table already exists.
SQL SERVER – Find Primary Key Using SQL Server Management Studio
Need to drop a primary key but do not know the constraint name? Imran Mohammed shows how to find primary key details using SQL Server Management Studio.