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

SQL Contest – Win Amazon Gift Cards – Learn How to Get Started with ClustrixDB

March 11, 2014

It has been a long time since we contest where we can learn something new and win something cool. I reached out to the good folks of Clustrix with the request to help me to build a contest where readers can learn and explore new technology, while stand a good…

SQL SERVER – Retrieve Maximum Length of Object Name with sp_server_info

March 7, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

A very common question which I often receive is – “How big my table name can be?” The answer is simple 128. You can figure this out by executing stored procedure sp_server_info on SQL Server. Execute following stored procedure in SQL Server. EXEC sp_server_info It will return following resultset. attribute_id…

SQL SERVER – How to Synchronize Data Across Databases and Servers

March 4, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

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…