I had previously penned down two popular snippets regarding deleting duplicate rows and counting duplicate rows. Today, we will examine another very quick code snippet where we will delete duplicate rows using CTE and ROW_NUMBER() feature of SQL Server 2005 and SQL Server 2008.
SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success
TechEd on Road Ahmedabad In India, TechEd was held in Hyderabad in the month of May. You can read myTechEd summary article here. A similar event will be organized in 10 major cities in India. Ahmedabad saw its first TechEd on Road and it was wholeheartedly welcomed by technology enthusiasts.…
Read MoreSQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1
Note : Download Risk and Health Assessment Utility by Microsoft Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1 is a practical download package intended exclusively for Microsoft Premier Customers. This package paraphernalia includes all the scoping tools required to prepare and qualify your environment to…
Read MoreSQL Server – Understanding Table Hints with Examples
Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how…
Read MoreSQL SERVER – Why You Should Attend PASS Summit Unite 2009- Seattle
PASS Summit Unite 2009 – the premier event for SQL Server professionals – will be held in Seattle from November 2 to November 5. It is the largest and the most intensive Microsoft SQL Server conference in the world organized by SQL Server users for SQL Server users. This year…
Read More
SQL SERVER – Clustered Index on Separate Drive From Table Location
How to improve performance of SQL Server Queries is a common topic of discussion among many of us. Much has been said, much has been discussed. Few days back, I had an interesting discussion with one of the Junior developers regarding performance improvement of SQL Server Queries. We discussed on how by using a separate hard drive for several database objects can right away improve performance. I suggested him that non clustered index and tempdb can be created on a separate disk to improve performance.
SQL SERVER – List Schema Name and Table Name for Database
Just a day ago, I was looking for script which generates all the tables in database along with its schema name. I tried to Search@SQLAuthority.com but got too many results. For the same reason, I am going to write down today’s quick and small blog post and I will remember…
Read MoreSQLAuthority News – 1000th Article Milestone – 8 Millions Views – Solid Quality Mentors
Achieving a milestone gives a great sense of accomplishment! Today, I am writing my 1000th Article on this blog. I am extremely happy and gratified. It is indeed a long journey since I started a few years back and at that time I had no idea that within a short…
Read MoreSQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You
While cleaning up my bookmarks this week, I stumbled upon a very small interesting thing. I can proudly call myself a pro at finding stuffs, but after continuously hunting online I could not gather comprehensive information about this topic. I was actually looking for a practical example for Query Optimizer…
Read MoreSQL SERVER – 2008 – SSMS Feature – Multi-server Queries
In my recent visit to TechEd India 2009 at Hyderabad, I had taken a technical session on SQL Server Management Studio 2008 New Features, which was attended by a huge number of participants and was very successful. I got loads of requests from my readers for posting the session online.…
Read More