June 2008 - Page 5 of 5 - SQL Authority with Pinal Dave

Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Order Of Column In Index

June 2, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

I just found one of my Jr. DBA to create many indexes with lots of column in it. After talking with him I found out that he really does not understand how really Index works. He was under impression that if he has more columns in one index, that index…

SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 4

June 1, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

I have been asked many times when there is DATENAME function available why do I go in exercise of writing UDF For the getting the day of the week. Answer is : I just like it! SELECT DATENAME(dw, GETDATE()) Reference : Pinal Dave (https://blog.sqlauthority.com)