Tag Archives: SQL Server 2005

Dynamic PIVOT by SQL Server Instructor Jeff Jones

Posted on December 14, 2006 by Jeff Jones

One aspect of using the PIVOT is to include a list of columns that will be used as the crosstab of the query.  For example, if you wish to display the total quantity ordered by Productid by Year you need … Continue Reading

Moving DTS packages to a SQL Server 2005 Server by Jeff Jones

Posted on October 20, 2006 by Jeff Jones

I have a bunch of DTS packages sitting in the MSDB database on my SQL Server 2000 system. I want to move the packages to my SQL Server 2005 server to continue executing them while I begin the migration. It … Continue Reading

Using SQL Server 2005 CLR Features to Create Aggregates

Posted on September 27, 2006 by Dan Wahlin

I played around with SQL Server 2005 a bit this past week to explore (more in-depth) some of the different CLR features that are available.  I'll be posting a few of the things I've experimented with over the next few days.  One … Continue Reading

SQL Server 2005 Displaying Object Owners

Posted on September 27, 2006 by Jeff Jones

I got a question in class to as to how to figure out the owner of a stored procedure or a view. After looking at the sys.all_objects system view, saw that the principal_id column had a NULL in each row. … Continue Reading

SQL Server 2005 OVER Clause

Posted on September 15, 2006 by Jeff Jones

One of the features of SQL Server 2005 that does not get a lot of press is the new window-based calculation clause called OVER. You can now generate different aggregates with different grouping columns in the same query, without having … Continue Reading