Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Fast Web paging in SQL Server 2005
- Tim Chapman demonstrates how to design a stored procedure to page data automatically using the new ROW_NUMBER ranking function in SQL Server 2005. Paging, the grouping together of records usually for display purposes, has never been easy to accomplish or very efficient in SQL Server. In the...
- Tags: Web, Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, ROW_NUMBER, Databases, paging, new ROW_NUMBER, SQL Server Newsletter, Procedure, Data, Listing B, Enterprise Software, Software, Data Management
- Technical articles 2006-12-11
Additional Resources
- De-duplicate tables using Oracle's analytic functions
- Oracle 9i introduced analytic functions, which offer an easier way to remove duplicate rows in tables. Bob Watkins presents sample code that demonstrates how you can use ROW_NUMBER to remove duplicates in your tables. Tables that don't have a Primary Key constraint protecting them can have duplicate rows...
- Tags: Oracle Corp., ROW_NUMBER, Databases, Bob Watkins, analytic function, ROWID, Oracle Tips Newsletter, Row, Enterprise Software, Storage, Software, Data Management, Hardware
- Technical articles 2006-06-06
- MySQL LIMIT in SQL Server
- Is there a way to mimick the MySQL LIMIT function in MS SQL Server?been a while but it'sSET RECORDS = 100or something like that anyway.Not quiteAcually SET ROWCOUNT will return the first set of records. e.g.SET ROWCOUNT 100SELECT * FROM Customerswill return the first 100 Customers. But in MySQLSELECT *...
- Tags: just_chilin, Microsoft SQL Server, MySQL, SELECT, server, software
- Discussion threads 2005-02-10
- SQL Question: Pivots, Analytics and the judicious use of Row_Number()
- A few days ago I answered a question from brat about converting 1 field into multiple rows. We solved that question but now we want to handle multiple rows in our source table.Just a note of warning. This article will really make a lot more sense if you...
- Tags: SQL
- Blog posts 2006-06-26
- De-duplicate tables using Oracle's analytic functions
- Comment on De-duplicate tables using Oracle's analytic functionsBob:Many thanks. Your solution is simple and elegant. I often encounter tables where only two or more fields will constitute a duplicate record (e.g. a record is only a duplicate if the account and email address are the same, but an...
- Tags: analytic function, De-duplicate table, De-duplicate, oracle, Tom R., software, Oracle Corp.
- Discussion threads 2006-06-07
- Implement custom paging with SQL Server 2005
- In previous columns, I covered the basics of using the .NET 3.5 ListView control and explained how to pair it with the DataPager control. Now I'll show you how to use these controls with a SQL Server 2005 backend to implement custom paging, in which only a subset of the...
- Tags: Function, Microsoft SQL Server, Data, Paging, Row, Microsoft SQL Server 2005, DataPager, ViewState, GetData Method, ID, newIndex, Servers, Databases, Enterprise Software, Hardware, Software, Data Management, Tony Patton
- Blog posts 2008-03-25
- Find blocking processes using recursion in SQL Server 2005
- Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set or subset of records. This causes the second process to wait until the first process is done so it can acquire the records; this...
- Tags: Process, Microsoft SQL Server, Statement, Information, Microsoft SQL Server 2005, #Processes, BlockingSPID, SELECT, RowNo, LevelRow, usp_StoredProcedure3, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-01-28
- << Previous
- page 1 of 1
- Next >>
