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 formatting one column at a time · Be familiar with the expression language. Neither of the aforementioned choices are difficult, but maybe time constraints eliminates both as viable options. Therefore, ...
Read More
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 tip that could help reduce fragmentation. If you are constantly switching data into your partition table you could potentially introduce some unwanted fragmentation in your database. The fol...
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. I have never attempted this approach, but I was confident that it could be done. Using the AdventureWorks database I initially wrote a T-SQL PIVOT statement that uses a derived table, which is as follows: USE AdventureWorks ...
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 filling up quickly. This is a free event where you can network and learn from some of the most talented SQL Server Professionals in the industry. Talk to you soon, Patrick LeBlanc Founder www.TSQLScripts.com and www.SQLLunch.com . Visit www...
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 embarked on my latest challenge. After one quick search I found a great video posted on SQL Share by SQL Server MVP, Jessica Moss , Designing a KPI in Reporting Services . Using her example, with a few modifications I was a...