SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2010

SSRS - Formatting Mutiple Columns

Often when designing reports you are required to apply the same formatting to multiple columns in one table or matrix. Since SSRS 2008 does not allow the developer to change the format of a column using Textbox Properties when multiple columns are selected, the developer must either:

· Change the… Read more

0 comments, 1,559 reads

Posted in SQLDownSouth on 19 March 2010

Minimizing Fragmentation when Moving data using a Switch

Yesterday was the first day of the SQL Server 2008 R2 airlift.  I attended a great session on Implementing a Fast Track Data Warehouse.   Lots of really interesting information was discussed during the meeting. However, an offline discussion about switching partitioned data in from a stage table provided a good… Read more

3 comments, 801 reads

Posted in SQLDownSouth on 17 March 2010

Using a CTE with a T-SQL Pivot Statement

During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a Common Table Expression (CTE).  In other words, instead of using the method outlined in SQL Server Books Online that uses a derived table, replace the derived table with a CTE. Read more

0 comments, 9,545 reads

Posted in SQLDownSouth on 9 March 2010

Speaking at Charlotte, NC - SQL Saturday #33

If you are near Charlotte, NC, I will be speaking at their SQL Saturday on March 6th, 2010.  My session, SQL Server Compression 101 is at 1:30 PM.  This is the first SQL Saturday under PASS management.  If you have not registered for this event do so, seats are… Read more

0 comments, 494 reads

Posted in SQLDownSouth on 1 March 2010

SSRS – KPIs without Analysis Services

During a recent project I was asked if it was possible to simulate Key Performance Indicator (KPI) images in SQL Server Reporting Services (SSRS) without Analysis Services. Off the top of my head I thought of a couple of things, but I decided to do a little searching before I…

Read more

10 comments, 2,374 reads

Posted in SQLDownSouth on 1 March 2010