SQL Archives - Page 122 of 378 - SQL Authority with Pinal Dave

Interview Question of the Week #023 – Error Handling with TRY…CATCH

June 7, 2015

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

Here is one of the most popular question I see people discussing in SQL Interviews. Question – How do you handle errors with the help of TRY…CATCH? Answer – TRY/CATCH helps to write logic separate the action and error handling code. The code meant for the action is enclosed in…

SQL SERVER – FIX: Msg 3102, Level 16, State 1 – RESTORE cannot process database ‘Name’ because it is in use by this session

June 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Some of the simple learnings can come from unexpected places and this blog post is a classic example to that statement. Recently I got an email from one of my readers about the below error message: Msg 3102, Level 16, State 1, Line 2 RESTORE cannot process database 'DBProductDevelopment' because…

SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083

June 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server Security, SQL Statistics

[Note from Pinal]: This is a 83rd episode of Notes from the Field series. Maintenance of the database is very critical activity and I have always seen DBA taking it very seriously. There is a only one problem – there is no single solution or guidance for how to maintain the database.…

SQL SERVER – Finding Out Identity Column Without Using Column Name

June 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity

There is an interesting observation when querying the identity column of a table Let us create the following tables CREATE TABLE test1 ( id INT IDENTITY (1,1) ) GO CREATE TABLE test2 ( id INT ) Note that the table test1 has identity column and table test2 does not have…

SQL SERVER – Errors and Limitations of Working with SPARSE Columns in SQL Server

June 2, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SPARSE Columns, SQL Error Messages

I make a visit to the local user group whenever I get and keeping the community juices up and running for me. I get an opportunity to share some of the learnings and meet tons of new people. In our recent meetup at the SQLBangalore UG, I met a lot…

SQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)

June 1, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

As I always say, Errors are a great source of learning and I am fortunate to have you as my readers. Because one of my blog reader reported an interesting issue which is worth blogging. This is his initial email: Hi Pinal, Your blogs have been very helpful to me…

Interview Question of the Week #022 – How to Get Started with Big Data?

May 31, 2015

Pinal Dave

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

Big data is one of the most popular subject in recent time and everybody wants to get started on this subject. During recent interviews there are plenty of the questions with related to Big Data. Here is the most popular question which I receive on this subject. Question: How to…