March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQLAuthority News – T-SQL Challenges and Hints and Suggestions

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Server

Those who read my blog are for sure know my very good friend Jacob Sebastian. He is SQL Server MVP and founder of wonderful site T-SQL Challenges. No matter how expert we are, challenges are made to make us think and try to go to next level. There are certain people who writes always challenging code, however there are many who are yet not expert but the passion of T-SQL is on them. Jacob has many wonderful ideas and T-SQL challenge is his contribution to community, where he helps community to think, help them to mentor and help them to become one better coder.

Read More

SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)

Pinal Dave
SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
Best Practices, SQL Scripts
Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click…
Read More

SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Stored Procedure
It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of all the…
Read More