June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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

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…
Read More

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

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…
Read More

SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction

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…
Read More

SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted.

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts
Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted. This errors happens when corrupt database log are attempted to attach to new server. Solution of this error is little long and it involves restart of the server. I…
Read More