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,762 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,184 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

A Live Conference Experience at Data Minds Connect 2021

By

Last week I was privileged to attend a live conference in Belgium. dataMinds Connect...

Daily Coping 25 Oct 2021

By

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

A New Form of Address: Mx

By

When I was presenting at the dataMinds Connect conference, I called on someone in...

Read the latest Blogs

Forums

Need advice with backup plan and transaction log file

By dubem1-878067

I am missing something I guess.  Here's our backup Plan Full backup weekly Differential...

cannot generate SSPI context

By premkuttan

We have one user who face this issue while connecting to SQL server ''Cannot...

Database Corruption - LOB

By database diva

Hello, I have recently inherited a SQL 2012 database (no backups available), running in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

A Simple Error

See possible answers