SQL Tips and Tricks Archives - Page 474 of 535 - SQL Authority with Pinal Dave

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 3

March 11, 2008

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

Please read SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL before continuing this article. I had asked users to come up with alternate solution of the same problem. Khadar Khan came up with good solution using CTE SQL SERVER – How to Retrieve TOP and…

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2 – CTE

March 10, 2008

Pinal Dave

SQL Tips and Tricks

CTE, SQL Function, SQL Joins, SQL Scripts, SQL Server

Please read SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL before continuing this article. I had asked users to come up with an alternate solution of the same problem. In this blog post we will see solution with the help of CTE.

SQLAuthority News – Authors Most Visited Article on Blog

March 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Stored Procedure, SQL Utility

I received many emails regarding SQLAuthority News – 500th Post – An Interesting Journey with SQL Server. One of the email asked interesting question regarding my most visited article on this blog. It was interesting to know that reader wants to know which article I visit the most. Following is…

SQL SERVER – Find Nth Highest Record from Database Table

March 8, 2008

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

I had previously written SQL SERVER – Query to Retrieve the Nth Maximum value. I just received an email that if I can write this using AdventureWorks database as it is a default sample database for SQL Server 2005 and the user can run the query against it and understand it better. Let us see how we can find highest record from database.

SQLAuthority News – 500th Post – An Interesting Journey with SQL Server

March 7, 2008

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, Software Development, SQLAuthority Author Visit

I am very pleased to write my 500th post. After 500 posts, I still have same feeling when I wrote first post on this blog. I would like to thank my family for their continuous support in writing this blog. Most of all I want to thank all of YOU…

SQLAuthority News – SQL Server 2005 is The Data Platform Leader

March 6, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Data Warehousing, Database, DBA, Software Development

Questions I often get asked : How big is market for SQL Server? Is SQL Server industry leader? Does learning SQL Server technology will help future career? Why did you pick SQL Server as your expertise? I just love SQL Server. Let us read following article taken directly from Microsoft,…

SQL SERVER – Simple Example of Cursor – Sample Cursor Part 2

March 5, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Scripts

I have recently received email that I should update SQL SERVER – Simple Example of Cursor with example of AdventureWorks database. Simple Example of Cursor using AdventureWorks Database is listed here. USE AdventureWorks GO DECLARE @ProductID INT DECLARE @getProductID CURSOR SET @getProductID = CURSOR FOR SELECT ProductID FROM Production.Product OPEN @getProductID FETCH…