Advanced Querying

Technical Article

Why Read-only Table Parameters is Not Enough

  • Article

In this article I discuss a new feature in SQL 2008, table-valued parameters and particularly the restriction that they have to be read-only. I argue that this makes this feature considerably less useful that it could be, and that in order to build scalable applications be able to pass read-write table parameters between stored procedures is essential.

2008-04-02

2,677 reads

SQLServerCentral Article

SQL Server 2008 - The Power of Merge

  • Article

We have a first look at one of the features in SQL Server 2008 that was cut from SQL Server 2005, but which has been highly anticipated. How many times have you written an "insert new, update match" routine? Jacob Sebastion shows us easy this becomes with the new MERGE keyword in SQL Server 2008.

4.8 (5)

2007-09-11

13,859 reads

SQLServerCentral Article

Server Side Paging With SQL Server 2005

  • Article

One of the more common requests of an application working with SQL Server is to deal with pages, or sections, or data rather than an entire result set. Often an application retreives the entire result set and then only shows the user a few records, repeating the process with the next page. Regular columnist Jacob Sebastian brings us a more efficient method of implementing paging in SQL Server 2005.

4.86 (7)

2007-08-29

13,306 reads

SQLServerCentral Article

Getting Random Results

  • Article

One common need that DBAs run into is building a report that returns data in some random order. Especially if you're doing some type of contest, like giving something away at your User Group meeting. Andy Warren brings us a short article on this with a look at the performance impact of randomly ordering results.

5 (2)

2007-08-23

4,325 reads

Blogs

Daily Coping 12 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My Toolbox - Greenshot

By

Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...

Daily Coping 11 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Groupinig using Lists in a report

By Jason

I am trying to create a list type report and can't seem to get...

SSMS: Remove highlight in current cell of grid output

By Aaron N. Cutshall

I'm trying to capture some screen shots of query results for documentation. I'd like...

Need to rollup some rows to columns

By sqlfriend

Hello, thanks in advance for any help. I have a query like this: select...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers