SQL Tips and Tricks Archives - Page 505 of 536 - SQL Authority with Pinal Dave

SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details

August 2, 2007

SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details This error is very common and many times, I have seen affect of this error as Suspected Database, Database Operation Ceased,…

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Search SQL

August 1, 2007

Pinal Dave

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

SQL Humor

In meeting with DBA friends one of my friend suggested while searching for “MSSQL Client” Microsoft returns you suggestion as “MySQL Client“. I did not believe it so I tested it myself. He was correct. Here is the screen shot. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – My Favorite Articles of This Blog

July 31, 2007

Pinal Dave

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

Database

The question I receive very often is I have more than 250 articles so far on this blog, which are my most favorite articles so far? Yesterday while talking with my parents on occasion of my birthday, they asked the same question to me. Answer is I keep running list…

SQLAuthority News – Birthday of SQL Authority Author

July 30, 2007

Pinal Dave

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

DBA

Today is Birthday of SQL Authority Author. Thought of the day : Family is everything. https://www.pinaldave.com/ http://www.SQLAuthority.com Reference : Pinal Dave (https://blog.sqlauthority.com)

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

July 29, 2007

Pinal Dave

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…