SQL Server Archives - Page 25 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Database Snapshots and Replica Causing Write Delays

June 19, 2015

For folks who have not worked with SQL Server Database snapshot feature, please refer to the blog I wrote sometime back (SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot). I am giving this reference because some might not be aware of this powerful capability with…

SQL SERVER – Stress free life with Spotlight for SQL Server DBA

June 17, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Dell, SQL Backup and Restore

Being on the cutting edge of technology is something that we need to be prepared as IT professionals. Newer capabilities get into the software almost every single day and it is difficult to keep track of what is getting added into the software’s we work with. I am a firm…

SQL SERVER – SPARSE Property Doesn’t Carry Forward Using SELECT INTO

June 16, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

During one of the recent posts on a SQLBangalore UG FB page, one of the members asked an interestingly simple question. He was asking why is it that when you use SELECT-INTO to create a new table the triggers are not getting carried forward as part of the definition. A…

SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1

June 15, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Error Messages

I have been monitoring some of the error messages that SQL Server has been throwing in the recent versions and they are self-explanatory. If we understand the English, then half the problem is solved. It becomes easier and quicker for an administrator if they ever encounter such errors. This blog…

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

June 14, 2015

Pinal Dave

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

SQL Backup and Restore

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 – 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.