SQL Scripts Archives - Page 248 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution

June 26, 2009

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Does the title of this post trigger your mind? If you all remember, a few days back I had written an article on my interesting observation regarding logon triggers. I would advise you to first read SQL SERVER – Interesting Observation of Logon Trigger On All Servers before continuing with…

SQL SERVER – Delete Duplicate Rows

June 23, 2009

Pinal Dave

SQL Video

Duplicate Records, SQL Function, SQL Scripts, SQL Server

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.

SQL Server – Understanding Table Hints with Examples

June 20, 2009

Pinal Dave

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

Query Hint, SQL Joins, SQL Scripts

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…

SQL SERVER – List Schema Name and Table Name for Database

June 17, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

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…

SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You

June 15, 2009

Pinal Dave

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

Query Hint, SQL Scripts

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…

SQL SERVER – 2008 – SSMS Feature – Multi-server Queries

June 14, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

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.…

SQL SERVER – Performance Counters from System Views – By Kevin Mckenna

June 10, 2009

Pinal Dave

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

SQL Scripts, SQL System Table

I just love social media and all the new concepts of Web 2.0. There are bloggers who are overwhelmed by the new concepts of technology and are not able to keep pace with it. But I like taking such challenges. Twitter has acquired tremendous popularity nowadays and just like everybody…