Development

Building a Partitioned Table

  • Article

One of the nice new features in SQL Server 2005 is the ability to partition a table based on some sort of range in the data. New author Irfan Baig brings us a short article that explains exactly how you can get started using this new feature.

4.17 (6)

2007-08-14

8,192 reads

Multi-Select Parameters for Reporting Services

  • Article

Reporting Services is a very handy way to get your SQL Server 2005 data out to end users quickly. It is included with your license and provides a great development environment for reports. New author Adriaan Davel brings us a quick technique for ensuring that multi-select parameters are handled correctly.

1.5 (2)

2007-08-13

11,567 reads

Table Partitioning

  • Article

One of the techniques that you can use for increasing performance, especially in large SQL Server tables, is partitioning. Andy Warren brings us an overview of what this is and how you can use it in your SQL Server 2005 applications.

4.2 (5)

2007-08-09

19,984 reads

Transaction Isolation and the New Snapshot Isolation Level

  • Article

Concurrency and transaction isolation are a prickly subject, difficult to explain with any kind of clarity without boring the reader and leaving their poor brain in a complete muddle. Therefore, it is often ignored in the vain hope it won't affect us and we can forget all about it. Well you can't ignore it any more and with SQL Server 2005 there's a whole new isolation level added to the four that already exist.

2007-07-19

2,385 reads

Dynamic Connection Strings in Reporting Services 2005

  • Article

Reporting Services is one of the most popular features of SQL Server 2005 and there have been a tremendous number of enhancements to this subsystem. New author Bilal Khawaja brings us a look at dynamic connection strings and how you can have one report pulling data from different servers.

4.63 (19)

2008-04-03 (first published: )

19,813 reads

Blogs

Daily Coping 22 Apr 2021

By

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

Altering a Computed Column in a Temporal Table in Azure SQL

By

System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...

Basic OFFSET–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

SQL Server 2016 SP1 to SP2

By Brian.Tran

We are currently on SQL server SP1.  Should we go ahead and apply SP2? ...

Cant cast VARCHAR(MAX) To XML Variable

By Weegee71

Hi there I would like to cast a NVARCHAR(MAX) variable string to an XML...

SQL server 2019 reporting need help

By juliava

Hello sql server reporting 2019, i created temp for 180 days and not sure...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers