Development

SQLServerCentral Article

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

SQLServerCentral Article

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

SQLServerCentral Article

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

20,029 reads

External Article

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

SQLServerCentral Article

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

Blogs

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Read the latest Blogs

Forums

Can't upload all files from the S3 bucket

By christi1711

Hi all, I have a package that uploaded files from S3 bucket. Currently I...

Splitting table into multiple tables

By SQLAddict01

I have a requirement where we have a table of 1 billion rows, which...

AlwaysON on one Node

By Arsh

Hi friends, Is it possible to configure ALwaysON with two instances on one node...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers