Mauricio, what version of SSRS are you using that's giving you so many headaches?

Vik

Thanks for the input, Michael.

I realize that rolling our own solution would require reinventing the wheel regarding scheduling, automating report generation, etc.  But given our previous experience with the sheer,...

Troy,

This is a common problem in Canada, which has a blanket 7% GST rate in every province for most products.  Most of the implementations I've seen do not track a...

Dunno if anyone's mentioned Jurassic Park -- they're all trapped in the compound at the end of the movie and can't get the computers working, whereupon the 12 year old...

And you're safer in doing so... if you get into the habit of using EM for queries, you may end up doing it on a production server, which may have...

Hi covhilomi,

I haven't gone thorugh this exercise myself, but would you not have to also worry about collation settings for the databases?  Or perhaps not because the European databases were...

Remi,

I had checked the execution plan for the view and nothing leapt out at me in terms of resources for the sort, so didn't pursue it further.

In any case, I...

Ron,

We've used ORDER BY in views for a while, but never really saw any noticeable problems or performance issues.  The other fellows' responses indicated that ORDER BY was bad news...

PW, thanks for the explanation, that makes sense.

Noel, thanks for your help in pointing out that I should RTFM.  Yeah, I saw that further info about optimizations.

Remi, thanks for.... barking...

noeld,

A DYNAMIC cursor?  OK.. I thought that FAST_FORWARD was equivalent to FORWARD_ONLY  READ_ONLY, but I just noticed that the description for FORWARD_ONLY states that unless STATIC, KEYSET, or DYNAMIC is...

PW,

1. Removing the ORDER BY clause magically made everything work again.

2. We had just recently done a similar test, different database, same situation, same cursor type, approx'ly 80k records processed...

Remi,

Of course, there are many ways around this process.  Don't be so quick to judge my situation, however.

The decision to fetch so many rows within a sproc was made in...

noeld,

The sproc never gets past the first fetch.  Here's the declaration:

Declare CreateTicketsCursor Cursor Local Forward_Only Read_Only For Select CustomerId, BranchesId, CustInvoiceGroupId, CustTicketGroupId, CalculationType, ChainId, MonthEnd, CustomerServiceId, InvoiceAmount, ServiceAmount, RenewalAmount,...

Antares,

All good points.  Yeah, this pdf is pure propaganda -- old pricing, all kinds of nonsense about zero administration, boasts about functionality that is basic to pretty much any DBMS...

We've used the "Locks" table method to great success over the past few years, albeit in relatively small (~10 GB) databases with user populations in the dozens.  Our application code...