Blog Home Page - Page 431 of 831 - SQL Authority with Pinal Dave

Mar3

SQL SERVER – Images and media file management in SQL Server and MySQL – Coding Media Management Tools is Never Easy

A core element to both web and mobile app development is rich media management. How you approach the control of images in particular can be tricky. In most cases you have two avenues: You either save it as a database BLOB or simply link to it as a file. Going…

Mar2

SQL SERVER – Listing Primary Key of Table with Stored Procedure sp_pkeys

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys

Here is a follow up blog post of my earlier blog post on very similar subject Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys. In previous blog post we listed foreign keys and now we will list the primary key of the table with the help of Stored…

Mar1

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

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys

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

Feb28

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

Pinal Dave

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

SQL Scripts, SQL Wait Stats

No Comments

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…

Feb27

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

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…

Feb26

SQL SERVER – Find Anything in Object Explorer in SSMS

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:…

Feb25

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

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 – Listing Primary Key of Table with Stored Procedure sp_pkeys

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

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

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

SQL SERVER – Find Anything in Object Explorer in SSMS

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

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.