• Home
  • Blog
  • About
  • Contact

"platform to share ideas and knowledge about SQL"

Be aware when you use two digit year in date

SQL Basic Raj Leave a Comment

When you execute the below query, as you expect, the result will be “September 26th 2049” Now, Lets see what happen when we pass 50 instead of 49 You will…

Read more »

How to find whether the date is end date of the month in SQL

How to topics Raj Leave a Comment

Working with date is very interesting, I have seen people add too much code to get desired result while it can be achievable with simple logic. Below sample is to…

Read more »

How to find the Date is first day of the Week in SQL

How to topics Raj Leave a Comment

Some time you may need to find the given date is first day of the week or not? here is the code.

Read more »

Recent Posts

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

Categories

  • Data warehouse
  • How to topics
  • Index
  • Partition
  • Performance & Troubleshooting
  • quick bite
  • SQL Basic
  • SSIS

Topics

Compression Data warehouse Date DBCC DMV Error Handling Fact How to topics Identity Index JOIN OUTPUT Query Performance ROLLBACK SELECT SQL Server misc SSIS Table Table Partition Table Value Transaction TRUNCATE

Contact Us

  • Email
    contact@intellectSQL.com

Recent Posts

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

Site Links

  • About
  • Blog
  • Contact
  • Home
  • Privacy Policy

Contact

  • Email
    contact@intellectSQL.com

RSS blog – feed

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

About intellectSQL

intellectSQL is a platform to share ideas and knowledge about SQL, Data engineering, warehouse and more …

© 2025 intellectSQL
  • Home
  • Blog
  • About
  • Contact