SQL Archives - Page 136 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Installation Error – INSTALLSHAREDDIR parameter is not valid because this directory is compressed or is in a compressed directory

February 16, 2015

One of my blog reader contacted me for assistance. Here is his email: Hello Pinal, I am trying to install SQL Server on my laptop but getting below errors: SqlServer.Configuration.Sco.DirectoryAttributesMissmatch: Folder C:\Program Files\Microsoft SQL Server has an unsupported attribute (Compressed) set. Please resolve this issue by removing the unsupported attribute…

Interview Question of the Week #007 – How to Reindex Every Table of the Database?

February 15, 2015

Pinal Dave

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

SQL Scripts

Some questions are extremely popular questions and they never get old. Here is one such question which I see very often asked to DBAs in their early career. Question: How to re-index every table of the database? Answer: Well, The answer of this question can be only given in the form of the…

SQL SERVER – Warning: Null value is Eliminated by an Aggregate or Other SET Operation

February 13, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Working with NULL’s are always a challenge – not many developers understand how NULL works sometimes. In a related note, long back I wrote below blog in which I explained two set options Quoted Identifier and ANSI NULL. SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation In future blogs,…

SQL SERVER – The Basics of the Execute Package Task – Notes from the Field #067

February 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. In this episode of the Notes from the…

SQL SERVER – Script to Find Leap Year

February 11, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

A leap year has 366 days. A leap year has 29 days for February month. Suppose you want to find if year is Leap year or not, you can use many methods. But this is one of the simplest methods. In our example I have passed the year 2000 as…

SQL SERVER – Error: Fix for Error Msg 3906 – Failed to update database because the database is read-only

February 10, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Some error messages are a great source of troubleshooting when things go wrong. I always request my blog readers to read what the error messages are conveying. Most of the solutions are very much documented as part of the message. I must agree that over the years the error messages…

Interview Question of the Week #006 – Is Shrinking Database Good or Bad?

February 8, 2015

Pinal Dave

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

Shrinking Database

Here is the most debated Interview Question – Is Shrinking Database Good or Bad? I will try to answer this in a single statement – “Shrinking Database is bad practice for performance as it increases fragmentation. It should be used in rare cases of running out of space on drive.” I believe above…