SQL Archives - Page 182 of 46 - SQL Authority with Pinal Dave

SQL SERVER – How to Synchronize Data Across Databases and Servers

March 4, 2014

If you are developer you must have faced situations which I am going to mention next. A Developer’s Wish Have you ever built a database application where you are driving your navigation with the help of Data? Have you ever realized that you are running query much faster on your…

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

March 3, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

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…

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

March 2, 2014

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…

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

March 1, 2014

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

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