If it were limited to T-SQL querying alone, then I think this would be fairly straightforward. Trying to incorporate that into SSRS's scripting would be difficult and laborious. Not...

Well, after weighing some options I used a rectangle on the main report with subreports calling each of the five charts individually. I them left justified all five subreports,...

I've considered options similar those, but they all felt "kludgy" so I didn't go far to implement. I kicked around the subreport option a bit, but I thought there...

Hey, thanks for the reply.

Actually when mocked up, in Excel - I think, but not sure how it was done, the charts looked "presentable" as there were only...

OK, I found a resolution for this. Using a rectangle in the left half of the report so that the top of the rectangle is along side the table...

The file is created by either the SQL Server service of the SQL Agent service depending on how the job was set up. Are both of those services running...

Two questions:

Does the service account for SQL Agent have write access to the UNC path?

Does the file get created but is empty or does it not even get created?

There are options like using joins or correlated sub-queries, but without having a better idea of what you're trying to accomplish, its really hard to come up with concrete suggestions.

This is the closest thing I have found over the past few years. MS has shied away from promoting the true system tables so people don't code against them...

Compression might help, though it might make writes slightly slower. Adding clustered indexes will ultimately help to ease database maintenance and allow defragmentation, but I don't think I'd expect...

You'll also probably want to CAST your data types so your UNION doesn't blow up with data type conversions and add NULL to your select if you have one result...

Good article, Steve.

I have mixed feelings about certifications. It does give me exposure to features that I wouldn't get to try out otherwise.... I am more apt to study...

This is a good article.

I, too, have had a variety of problems with the Transfer Objects task. The one I am currently fighting is that it wasn't able to...

The organization I work for has also been very slow to adopt SQL Server 2005. We do have an instance of it (standard version) and despite having virtually zero...