May 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
Apr20

SQL SERVER – Identifiers As Valid Object Names

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL System Table
1 Comment
Previous I wrote blog post about SQL SERVER – Explanation and Example Four Part Name. It was explaining the new feature of SQL Server 2005 of Schema. Few days ago I received email from Chi-Ho, Min of Taiwan, he suggested that he was successfully able to use column without completely…
Read More
Apr19

SQL SERVER – Is Cursor Database Object or Datatype?

Pinal Dave
SQL Interview Questions and Answers
SQL Cursor, SQL Server
34 Comments

Whenever we want to loop something we always look for logic like WHILE LOOP or FOR LOOP. Trust me on my word that both of them are cursor when it is about SQL Server.

Read More
Apr18

SQL SERVER – Generate Foreign Key Scripts For Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys
14 Comments
Regular reader of SQLAuthority.com blog Madhaiyan Seenivasan has send email with one very interesting script. This script generates all the foreign key addition script for your database. Many times there are situations where one need to drop all the foreign key and add them back. This SQL Script can be…
Read More
Apr17

SQLAuthority News – My Favorite Link of This Blog

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
1 Comment
I have written more than 500 article on this blog so far and the number is increasing. Many times I get this question, which one link do I click the most. It is very interesting for myself to read my previous articles, as I often like to read them and…
Read More
Apr16

SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure
7 Comments
While playing with SQL Server 2008 I found new feature of “Row Constructors”, where I can load temp table from stored procedure directly. Look at the following SQL where I have to use OpenQuery from server to itself creating loopback server and execute stored procedure and insert into temp table.…
Read More
Apr15

SQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Database, SQL Server Management Studio
No Comments
Read my article published at SQL Server Magazine Surface Area Configuration Tools Reduce Exposure To Security Risks [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More
Apr14

SQL SERVER – SQL Slammer (Computer Worm)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Server Security
2 Comments
Just a day ago, while talking with my outsourcing team one of the DBA asked me question. Is there any virus associated with SQL Server? I really find this question very interesting as I did not know if there are any viruses associated with SQL Server. I searched Google for…
Read More
Previous 1 … 750 751 752 753 754 755 756 … 830 Next
SQL SERVER - Adding Values Containing NULLs 133-DeleteTrigger-yt-800x450

Remove Trigger for Delete – SQL in Sixty Seconds #133

SQL SERVER - Adding Values Containing NULLs outputclause-800x418

SQL SERVER – 7 Questions about OUTPUT Clause Answered

SQL SERVER - Adding Values Containing NULLs AfterUpgrading-800x413

SQL SERVER 2019 – Performance Issues After Upgrading from SQL Server 2012

SQL SERVER - Adding Values Containing NULLs 134-MultipleTableDrop-yt-800x450

Multi Tables – 1 Drop Statement – SQL in Sixty Seconds #134

SQL SERVER - Adding Values Containing NULLs 135-7Output-yt-800x450

5 Questions Answered OUTPUT Clause – SQL in Sixty Seconds #135

SQL SERVER - Adding Values Containing NULLs edge1-800x435

What is EDGE in SQL Server Execution Plan? – Interview Question of the Week #298

SQL SERVER - Adding Values Containing NULLs addingvalues-800x345

SQL SERVER – Adding Values Containing NULLs

Previous 1 … 750 751 752 753 754 755 756 … 830 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 104 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.


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