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

Interview Question of the Week #024 – What is the Best Recovery Model?

June 14, 2015

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

Here is one of the most popular questions I often see people asking on the internet. Question: What is the best recovery model for my database? Answer: Every situation is different and each situation has different needs for the recovery model. SQL Server offers three recovery models: full recovery, simple recovery and…

SQL SERVER – How Many Line of Code Do You Have in Database?

June 12, 2015

Pinal Dave

SQL Tips and Tricks

SQL Saturday, SQL Scripts, SQL Server, SQLAuthority Author Visit

Last weekend I happened to be in one of the beautiful cities in Sri Lanka for some fun time with SQL Enthusiasts. We had our first ever SQLSaturday Event in Sri Lanka and it was just too much fun to be amongst the amazing audiences. I was fortunate to deliver a couple of sessions and not to forget the hours and hours of interaction with the attendees post session. In this blog post we will answer the question How Many Line of Code Do You Have in Database?

SQL SERVER – The Basics of the Execute Process Task – Notes from the Field #084

June 11, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. This note is from Andy and as we all know he is amazing person when we have to understand the fundamentals. He…

SQL SERVER – Puzzle with Year Function

June 9, 2015

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts, SQL Server

A couple of weeks back, I ran a contest with MONTH () function and had close to 300 of you answer the puzzle. It was a great brain teaser and we had an awesome response from you. Most of you got the answer right and it is great to see you folks getting the basics right.

SQL SERVER – Know Your Backup Before Deleting Database

June 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Earlier last week I wrote a blog around, SQL SERVER – FIX – Msg 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use. The premise of that blog was driven by some of the demo’s I show at conferences. During one of the UG…

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

June 7, 2015

Pinal Dave

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…