Peter Larsson

SQLServerCentral Article

Pivot table for Microsoft SQL Server

One of the seeminly more popular enhancements in SQL Server 2005 to T-SQL is the PIVOT operator. There have been quite a few articles, but new author Peter Larsson decomposes in detail how you can perform this operation with previous versions.

4.68 (22)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

75,602 reads

SQLServerCentral Article

How many more Mondays until I retire?

Depending on your age, you may not want to know this number, but as you advance in your career, this might be a problem that you look to solve one day. Peter Larsson takes a few minutes to work out a function in T-SQL that can be used to solve this or any similar question.

5 (3)

You rated this post out of 5. Change rating


14,064 reads


Cloud Databases Made Simple: Creating Your First AWS RDS Instance


I recently started full time learning of Amazon Web Services (AWS). I found that...

First Time Speaking with a Mask at an Event


Over the past couple of months, I have started losing my ability to talk...

A New Word: Apolytus


apolytus– n. the moment you realize you are changing as a person, finally outgrowing...

Read the latest Blogs


Hardcoded filter vs filter by parameter

By blom0344

I am trying to set a date filter on several  large transaction tables to...

Do you listen to music when you work?

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Do you listen to music...

Slow update on temp table

By dpaproskijr

I have a job running each night starting at 4:30AM and usually finishing at...

Visit the forum

Question of the Day

Read Only Replica in SQL Server Standard

Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?

See possible answers