Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download

July 29, 2007

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, SQL Download, SQL Scripts

Click here to get free chapters (PDF) in the mailbox It was a great pleasure to write latest series about Data Warehousing Interview Questions and Answers. Just like always again, I received lots of suggestion and follow up questions. I have tried to accommodate all of them in the last…

SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3

July 28, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Data Warehousing

Click here to get free chapters (PDF) in the mailbox What are slowly changing dimensions (SCD)? SCD is abbreviation of Slowly changing dimensions. SCD applies to cases where the attribute for a record varies over time. There are three different types of SCD. 1) SCD1 : The new record replaces…

SQL SERVER – Data Warehousing Interview Questions and Answers – Part 2

July 27, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Data Warehousing

Click here to get free chapters (PDF) in the mailbox What are normalization forms? Please visit this article. Describes the foreign key columns in fact table and dimension table? Foreign keys of dimension tables are primary keys of entity tables. Foreign keys of facts tables are primary keys of Dimension…

SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1

July 26, 2007

Pinal Dave

SQL Interview Questions and Answers

Data Warehousing, SQL Server

Let us learn about Data Warehousing Interview Questions and Answers.

SQLAuthority News – Interesting Read – Programming Concepts, Structured Thinking Language (STL) and Relationary

July 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

I have always enjoyed reading articles and blogs which are different then others. There many be thousands of technology and programming blogs, only few makes difference in the tech world. One of the high quality blog, I enjoy reading is relationary by Grant Czerepak. Grant Czerepak is an IT professional…

SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction

July 25, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, DBA, SQL Download, SQL Scripts

Click here to get free chapters (PDF) in the mailbox This series is in response to many of my reader’s continuous request to start Data Warehousing Interview Questions and Answers series. This series is written in the same spirit as previous two series which has received good response. Samples Question…

SQL SERVER – 2005 – Server and Database Level DDL Triggers Examples and Explanation

July 24, 2007

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure, SQL Trigger

Let’s learn about Server and Database Level DDL Triggers Examples and Explanation here. Let us learn more about this topic.