SQL SERVER – Find Monday of the Current Week
Very Simple Script which find Monday of the Current Week SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) MondayOfCurrentWeek Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQLAuthority News – Book Review – Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes (Sams Teach Yourself) by Ben Forta Link to Amazon Short Review: If T-SQL (Transact-Structured Query Language) is foreign tongue to you, after reading this book, you will speak T-SQL. This book is SQL Server version of best-selling book Sams Teach…
Read MoreSQL SERVER – Find Last Day of Any Month – Current Previous Next
Few questions are always popular. They keep on coming up through email, comments or from co-workers. Finding Last Day of Any Month is similar question. I have received it many times and I enjoy answering it as well. I have answered this question twice before here: SQL SERVER – Script/Function…
Read MoreSQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop
SQL Server 2005 Enterprise Edition supports online index operations. Index operations are creating, rebuilding and dropping indexes. The question which I receive quite often – what is online operation? Is online operation is related to web, internet or local network? Online operation means when online operations are happening the database…
Read MoreSQLAuthority News – Subscribed to SQLAuthority Emails
I have got many request about alert system when new post is published on this blog. I use feedburner email service, which sends email whenever new post is published on my blog. Many times, I update my post based on feedback from comments or news. If you want updated information,…
Read More
SQL SERVER – 2008 – Book On-Line Link – BOL
I am researching SQL Server. Those who are asking me questions about SQL Server 2008, please refer following link. I will post my tutorials and articles very soon. Books Online is commonly known as BOL.
SQL SERVER – 2005 – Difference and Similarity Between NEWSEQUENTIALID() and NEWID()
NEWSEQUENTIALID() and NEWID() both generates the GUID of datatype of uniqueidentifier. NEWID() generates the GUID in random order whereas NEWSEQUENTIALID() generates the GUID in sequential order. Let us see example first demonstrating both of the function. USE AdventureWorks; GO ----Create Test Table for with default columns values CREATE TABLE TestTable…
Read More