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.
Cursor and Join Questions: SQL Server Interview Answers Part 2
This is part 2 of my SQL Server interview series, with cursor and join questions and seven more. The answers cover collation, functions, subqueries, keys, identity and data warehousing. Each answer is short, with a link to a longer post where one exists.
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.
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.
SQL Server Tips: Temporary Tables, Constraints and Agent
Temporary tables, constraints and SQL Server Agent each solve a different problem. Choose an appropriate temporary-table scope, use declarative rules for data integrity and give scheduled jobs clear ownership and failure handling.