Advanced Querying

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

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,664 reads

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,020 reads

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,323 reads

Blogs

sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019

By

sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Read the latest Blogs

Forums

Slow running "ranking" problem

By richardmgreen1

Hi all   I've got a table that contains 1.8million (yes, million) records in...

Opening Azure database in SSMS

By DaveBriCam

I triad to open an Azure database in SSMS and it opens fine, I...

removing stretch on a restore

By MVDBA (Mike Vessey)

Hi We've been forced to use "Stretch" for some history tables where our existing...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers