Feb 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
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQLAuthority News – I am a MVP and I Love SQL Server

July 9, 2010
Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
MVP, SQL User Group
I am very glad that I received this prestigious award for the third time in a row. I am very thankful to Microsoft for introducing this wonderful technology of SQL Server. I enjoy getting involved with the community, which also helps in my self-improvement as well. I would like to…
Read More

SQL SERVER – The Self Join – Inner Join and Outer Join

July 8, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Joins, SQL Scripts
Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The…
Read More

SQL SERVER – Upper Case Shortcut SQL Server Management Studio

July 7, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio
Few days ago, I received code which is very similar to code shown below. select * from Sales.SalesOrderDetail where ProductID > 777 I am not the guy who go crazy for formatting but I do appreciate proper coding. I like if the code was formatted like below. SELECT * FROM…
Read More

SQLAuthority News – I am Microsoft Certified Trainer (MCT)

July 6, 2010
Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Training
I am a Microsoft Certified Trainer and I am very much proud of it. Because I am a MCT, I have the support of great community leaders and trainers who help me constantly to improve in what I do. I have many Microsoft Certifications and I constantly try to take…
Read More

SQL SERVER – PowerShell Version Info

July 5, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Powershell, SQL Scripts
I have multiple computer systems at home. I have previously taken a picture of my home office and published it here. Also, I recently had a scenario where I was listing a PowerShell version installed in my computer systems. While searching online, I found two different commands that can determine…
Read More

SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats

July 4, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Index, SQL Scripts
In the recent Query Tuning project, one of the developers who were helping me out in the project asked me if there is any way that he could know how many pages are used by any Index,  and if there is any way I could demonstrate the different levels of…
Read More

SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan

July 3, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Execution Plan, SQL Scripts, SQL Server Management Studio, SQL XML
Earlier I wrote a blog post on SQL SERVER – Parallelism – Row per Processor – Row per Thread, where I mentioned the XML Plan. As a follow up on the blog post, I received the request to send the same execution plan so that the blog readers can also…
Read More
Previous 1 … 230 231 232 233 234 235 236 … 393 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version