SQL Server is going to grab all the memory it can regardless of how much you put in there. If you add memory I wouldn't adjust the max memory...

I'd definitely suggest adding a dedicated SSRS box. Until then I'd reduce the max memory for the SQL Server database engine to free up memory for SSRS and the...

I'd also do one per function. The only case might be an Upsert/Merge proc that does insert or update. Again, it is about modularity and maintenance.

A wide table...

Darn, I'm only getting $25 per post. Of course you probably are worth twice as much as I am.:-D

Is the column collation Case insensitive? You can set collation per column. Lynn's test modified:

CREATE TABLE #Test(TestVal VARCHAR(10) COLLATE Latin1_General_CS_AS);

INSERT INTO #Test

SELECT 'ABC' UNION ALL

SELECT 'Abc' UNION ALL

SELECT...

Hard to say because the content of the question(s). I'd have a hard time not coming across as snarky if I posted any answers on that...

I don't think there is a way to do this, but I don't know for sure. You could use a rowcount after the conditional split and if it is...

Have you seen this blog post, http://blogs.msdn.com/b/sql_protocols/archive/2009/03/09/understanding-the-error-an-operation-on-a-socket-could-not-be-performed-because-the-system-lacked-sufficient-buffer-space-or-because-a-queue-was-full.aspx?

It's been years since I've connected to DB2, but I seem to recall seeing an error like this for a linked server or .NET...

A calendar table is definitely the best way to do this. You can do it with a numbers/tally table or cte as well. Something like this:

WITH ...

Have you seen this blog post: http://www.sqlservercentral.com/blogs/pearlknows/2009/08/25/database-mirroring-across-domains-using-certificates/

I don't remember exactly when I started answering questions, but as almost everyone else has said, I did it because I first learned from this site and wanted to contribute....

A couple of things:

1. You need a GROUP BY on your query.

2. You can address NULL values for Ac_Billbook.CostsNet 2 ways. You wrap the SUM with an...

So does that mean you need to have BO or be able to remove BO?

For those not on tiwtter, just signed the papers for my new house. Went from no debt to hundreds of thousands, but in the long run it'll be great!

Any...

I don't have the answer either. I think I have accomplished what you are trying to accomplish with subreports by nestin tables. It has been a couple years...