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

SQL SERVER – How Can Deadlock Happen on Same Table?

February 2, 2015

Interesting TRUE Story As part of learning I get inspiration from the activities we do daily and see how it can be mapped to SQL Server. This in a way many say is an obsession for the subject I love – SQL Server. But I think it is part of…

Interview Question of the Week #005 – List All the Tables with Name Containing Specific String

February 1, 2015

Pinal Dave

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

The other day, I received an email from a blog reader. When he appeared for an interview, he was asked to retrieve all the tables where the name of the table contained the words ‘tbls_’. This was a very interesting scenario. As the organization had earlier adopted a specific naming…

SQL SERVER – 8 Performance Related Articles on Logical Reads

January 31, 2015

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Confio

Earlier this year, I have written few articles which are related to SQL Server Performance and they are published on site of Logical Reads. Here are my personal favorite 8 various articles on the subject of SQL Server Performance. I have really enjoyed writing them and I am very confident…

Developer – 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part 3 of 3)

January 29, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Blogging, SQL Training

I am very fortunate that I know John Sonmez in person. He is one of those individuals who understands the young mind of developers and depth of software development industry. I am a regular follower of his books, videos and ideas. I have personally implemented many of his ideas in my…

SQL SERVER – The Basics of the SSIS Script Task – Notes from the Field #065

January 29, 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…

Developer – 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part 2 of 3)

January 28, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Blogging, SQL Training

SQL SERVER – How to Know Backup History of Current Database?

January 28, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Some blog post and scripts are like ever green references. One such blog has been Get Database Backup History for a Single Database. A number of you have pinged me and for amendments to that script with various ideas. Since that post was written more than 4+ years now, I…