Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Apr29

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets – New

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
After reading my earlier article SQL SERVER – Denali – Executing Stored Procedure with Result Sets, one of the readers asked if this new feature (syntax) support multiple resultset of the stored procedure? Very interesting question indeed as most of the stored procedures that I usually come across have more than…
Read More
Apr28

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure
15 Comments
Here is a normal conversation I heard when I saw that the function (UDF) was used instead of the procedure (SP). Q: Why are you using User Defined Function instead of Stored Procedure? A: I cannot SELECT from SP, but I can from UDF. SQL Server’s next version ‘Denali’ is…
Read More
Apr27

SQL SERVER – Introduction to SQL Azure – Creating Database and Connecting Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
5 Comments
I recently logged into new Azure Portal and I really think the product team has done excellent job to make it user-friendly and self intuitive. Here are the quick steps I have done after I logged into the portal here: Purchased subscription Created Server Created Database Connect using Database Honestly…
Read More
Apr26

SQLAuthority News – Pluralsight On-Demand FREE for SQL Server Course

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, SQL Scripts, SQL Training
16 Comments
The Moral of Story You can watch the most popular SQL Server – TSQL course on Pluralsight On-Demand for FREE for the next 48 hours. It starts NOW! The Story Learning is always difficult. After learning how to apply your knowledge, learning in real life is even more difficult. Technology…
Read More
Apr25

SQLAuthority News – 1700th Blog Posts – Over 25 Millions of Views – A SQL Milestone

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
Database
6 Comments
It has been a tradition in this blog to write a “milestone blog post” for every 100th post. I am always looking forward to this because I am given a chance to do only three times a year. This year 2011 has been very nice to me so far- lots…
Read More
Apr24

SQL SERVER – How to ALTER CONSTRAINT

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts
13 Comments
After reading my earlier blog post SQL SERVER – Prevent Constraint to Allow NULL. I recently received question from user regarding how to alter the constraint. No. We cannot alter the constraint, only thing we can do is drop and recreate it. Here is the CREATE and DROP script. CREATE…
Read More
Apr23

SQL SERVER – How to Use Decode in SQL Server?

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server
16 Comments

One of the reader of the blog has sent me question regarding how to use DECODE function in SQL Server.

Read More
Previous 1 … 585 586 587 588 589 590 591 … 831 Next

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets – New

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

SQL SERVER – Introduction to SQL Azure – Creating Database and Connecting Database

SQLAuthority News – Pluralsight On-Demand FREE for SQL Server Course

SQLAuthority News – 1700th Blog Posts – Over 25 Millions of Views – A SQL Milestone

SQL SERVER – How to ALTER CONSTRAINT

SQL SERVER - How to Use Decode in SQL Server? decode

SQL SERVER – How to Use Decode in SQL Server?

Previous 1 … 585 586 587 588 589 590 591 … 831 Next

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.

Comprehensive Database Performance Health Check

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.


SQL Server Performance Tuning Practical Workshop

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.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com