All Articles - SQL Authority with Pinal Dave

SQL SERVER – 2008 – Interview Questions and Answers Part 8

September 19, 2008

Data Warehousing, Database, SQL Data Storage, SQL Function, SQL Index, SQL Scripts, SQL Server DBCC, SQL Utility

SQL Server 2008 Interview Questions and Answers Part 8 starts with Data Compression: how row compression and page compression work and save space.

SQL SERVER – 2008 – Interview Questions and Answers Part 7

September 18, 2008

Pinal Dave

SQL Interview Questions and Answers

Database, SQL Error Messages, SQL Scripts, SQL Server Security, SQL Utility

SQL Server 2008 Interview Questions and Answers Part 7: how to rewrite sub-queries with joins or a CTE, what CLR is, and more answers with examples.

SQL SERVER – Interview Questions and Answers – Part 6

September 17, 2008

Pinal Dave

SQL Interview Questions and Answers

Database, SQL Data Storage, SQL DateTime, SQL Function, SQL Index, SQL Scripts, SQL Server, SQL Utility

Part 6 of my SQL Server Interview questions and answers covers SQL Server 2008, starting with what the master, msdb, model, tempdb and resource databases do.

SQL SERVER – 2008 – Interview Questions and Answers Part 5

September 16, 2008

Pinal Dave

SQL Interview Questions and Answers

Database, SQL Scripts, SQL Stored Procedure, SQL Utility

SQL Server 2008 Interview Questions and Answers Part 5: how to rename a db with sp_renamedb, and a table or a column with sp_rename, with examples.

SQL SERVER – 2008 – Interview Questions and Answers Part 4

September 15, 2008

Pinal Dave

SQL Interview Questions and Answers

Database, SQL Constraint and Keys, SQL Function, SQL Index, SQL Scripts, SQL Stored Procedure, SQL Utility

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

September 14, 2008

Pinal Dave

SQL Interview Questions and Answers

Database, SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Utility

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.

Gouache painting of a fan of blank index cards, one edged in vermilion, resting on a wooden desk

Cursor and Join Questions: SQL Server Interview Answers Part 2

September 13, 2008

Pinal Dave

SQL Interview Questions and Answers

Data Warehousing, SQL Constraint and Keys, SQL Cursor, SQL Function, SQL Joins

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

September 12, 2008

Pinal Dave

SQL Interview Questions and Answers

Database, SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Stored Procedure, SQL Trigger

Part 1 of my SQL Server 2008 interview questions and answers covers general questions like what is RDBMS and the properties of relational tables.

SQLAuthority News – 700 Articles and Author Updates

September 11, 2008

Pinal Dave

SQLAuthority News

Best Practices, Database, DBA, MVP, SQL User Group

The blog has reached 700 articles. Here is why I write, plus updates since article 600: the SQL Server MVP award, user group work and 4 million visitors.

A glass jar of green cardamom pods beside a closed white lidded crock on a shelf.

IN With NULL: Show the Unknown Comparison

September 10, 2008

Pinal Dave

SQL Tips and Tricks

SQL Datatype, SQL Function, SQL Scripts

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.