All Articles - SQL Authority with Pinal Dave

SQL SERVER – Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys

March 1, 2014

A very cool trick which I have previously not shared on my blog regarding how to list all the foreign key relationship of table with the help of Stored Procedure sp_fkeys. Here is a quick script how you can use stored procedure sp_fkeys to list all the foreign key relationship.…

SQL SERVER – 28 Links for Learning SQL Wait Stats from Beginning

February 28, 2014

Pinal Dave

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

SQL Scripts, SQL Wait Stats

It has been exact two years since I have written series on SQL Wait Statistics and Queues. I often received quite a few questions related to this subject. Here are my answers to the questions. Q: The series which you have written two years ago, is it still relevant to…

SQL SERVER – Dude, Where is the SQL Agent Job History? – Notes from the Field #017

February 27, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: Everybody knows what is SQL Agent Jobs. We know that they run at regular interval and does the task assigned. However, there are way many more things we should know about SQL Jobs but do not know it or never learnt to care about it. One of…

SQL SERVER – Find Anything in Object Explorer in SSMS

February 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

This blog post is a follow up post of an excellent write up by my friend Vinod Kumar. I suggest you read his blog post here SSMS Tips–Object Explorer Details. After reading his blog post, I called him up and had an interesting conversation with him. Here is our conversation:…

MySQL – Profiler : A Simple and Convenient Tool for Profiling SQL Queries

February 25, 2014

Pinal Dave

SQL

Devart, MySQL, SQL Utility

In terms of working with highly loaded databases, any badly-designed request can cause significant performance degradation. Depending on the used DBMS features, various methods are used for query optimization. However, a general rule can be pointed out for all types of DBMS: the fewer server resources are expended when executing…

SQL SERVER – Contest Post – Notes from the Field – Learning Performance Tuning and Database Health

February 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same. Inceptions of Notes from the Field There are two aspects of any technology 1)…

SQLAuthority News – Two Whitepapers from AzureCAT Team on SQL Database

February 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Recently I was reading about SQL Database on Azure. There are lots of confusion around SQL Database around SQL Azure and I have been looking for a good authentic documentation which I can refer as well as I can use that in my day job. After a quick research I…

SQLAuthority News – 4 Whitepapers on Windows Azure

February 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL White Papers

Windows Azure is getting quite a lot of traction in the industry and I often get questions about if there is authentic learning on this subject. Microsoft has published following 4 white paper which covers many interesting topics related to SQL Server and Windows Azure. Application Patterns and Development Strategies…

SQL SERVER – Statistical Analysis in SQL Server – A Quick Introduction

February 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

SQL Server has very few statistical functions. Oracle has lots of them. XLeratorDB closes the gap. If you want to try out the example of this blog post, I suggest you download the 15-day free trial of XLeratorDB NOW. Most SQL Server users would never think of T-SQL as a…

SQL SERVER – Finding the Last Backup for All Databases – Notes from the Field #016

February 20, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Notes from Pinal]: During my presentation, I always ask developer a simple question – When did you take your last database backup? I get two different kinds of answers – 1) few replies with No Idea and 2) few replies with some date time. When I further ask if they…