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

SQL SERVER – Finding Top Offenders in SQL Server 2012 – Notes from the Field #068

February 19, 2015

Notes from the Field, SQL Azure, SQL Backup and Restore

[Note from Pinal]: This is a 68th episode of Notes from the Fields series. Performance tuning gets easier with SQL Server 2012. For the first time, you can capture a workload and find your top offenders inside of Management Studio without having to write a single line of T-SQL or…

SQL SERVER – Notes and Observations on ReadOnly Databases in SQL Server

February 19, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In the past couple of weeks, I have written few blogs that revolve around utilizing “readonly” databases. It was fun working on this special case scenario that I had stumbled upon an interesting set of questions from my blog readers. These were not clearly called out in my previous blogs,…

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

February 16, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

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 – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated

February 14, 2015

Pinal Dave

SQL Tips and Tricks

SQL Datatype, SQL Error Messages, SQL Scripts, SQL Server

Earlier this week, I have blogged about how to suppress Warning: Null value is eliminated by an aggregate or other SET operation SQL SERVER – Warning: Null value is Eliminated by an Aggregate or Other SET Operation. Let us learn about the error STring or Binary Data would be truncated.

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…