A response on my post on Serverfault.com indicated that this is I/O related as well, which means I can re-benchmark after SAN and SQL 2005 migration.

Perhaps you could reconstitute the procedure into a series of temporary tables as opposed to using that many views, or use indexed views. How much data are you dealing with...

It's very difficult to say what's going on unless you reproduce the stored procedure here for review. Do that, and then perhaps we can help 🙂

Without sounding disrespectful, I think perhaps SQL is not the best way to do this. You will have more luck using Paste Special > Transpose in Microsoft Excel for each...

You can build up a delimited string based on the product table, per tenant. There are many ways to go about this, depending on how much time you want to...

Nice tip, John! I'm going to use it myself 🙂

Hi again

Yes, you can link to the 64-bit SQL 2005 from 32-bit SQL 2000, but you will have to read through the topic I posted earlier, to find the stored...

There are attack vectors other than through your ASP.NET application. Locking that down, as you have done (I'm not an expert in ASP.NET security, mind you), is one step.

If you're...

You didn't provide much detail about the edition of SQL you upgraded to, so have a look at this topic as well, if you're trying to link to a 64-bit...

SQL BOL has a splendid article on how to use the PIVOT command, with examples. I'd recommend that as your first port of call.

ajain (5/27/2009)

1) Is it OK if I were to host both the web site and the database server on the same IP? If not, then how these should...

View > Object Explorer Details - select the objects you want to delete, right-click, and delete.

In future, make sure you have the right execution context before running a script. Next...

If you have set up cascading deletes (*shudder*), you can just delete the summary record, and the detail will go as well.

I never turn on cascading deletes myself, so I'd...

Hi Terry

Consider playing around with the Security page on the Linked Server properties, with Impersonation and security contexts.

Regards

Randolph

Our latest project for a financial institution is scoped for an estimated 1 billion rows in the first year. I'm having fun explaining to the powers that be (through my...