Viewing 15 posts - 16 through 30 (of 36 total)
piyush_srivastava (12/7/2011)
I am not aware of recursive cte, please help me by providing the query which can solve my above problem.I tried lot but coudn't get through.
Regards!
Piyush
I put together a...
December 7, 2011 at 2:24 am
I prefer to use a CTE for such updates: it makes the code more readable and maintainable. Plus you can quickly test the result of the CTE by using a...
December 7, 2011 at 2:01 am
eseosaoregie (12/5/2011)
I am not really sure on how I to create PIVOT with multiple aggregates. Could you give me some pointers.
How about creating multiple pivots for each kind of aggregate...
December 6, 2011 at 7:38 am
Maybe you can benefit from using a PIVOT operator instead of the case list in the procedure [prv].[sp_TradeAggregate_Equity]?
Also consider creating a separate column in the [FactTradeOrderAllocation] table where you can...
December 5, 2011 at 10:00 am
I had to get the info myself en for what I can see, the firmware of the iLo hasn't been upgraded to 1.9 or above, it's at version 1.8.3790.0. From...
April 16, 2007 at 2:59 am
As far as I can see, that's the only cluster participating in the TCP-C benchmark... which makes those results pretty useless.
As you stated yourself, MS SQL Server does a great...
April 11, 2007 at 2:55 pm
hi Mike
Try http://www.microsoft.com/sql/solutions/upgrade/default.mspx for several resources about upgrading to SQL Server 2005.
This is also a good article about clustering: http://www.sql-server-performance.com/bm_cluster_infrastructure.asp
April 11, 2007 at 2:37 pm
In case of the 32bit environment, you will natively be limited to 4GB memory usage, of which your OS will need some as well.
If possible, go for a 64bit system,...
April 11, 2007 at 2:19 pm
Hi Karl
The note is about the effect of the trace flag in the previous line (see underlined text):
To move the model database, you must start SQL Server together...
April 11, 2007 at 1:50 pm
You can also use a unique constraint, that way you can put your primary key on 1 column (datatype integer) for better performance when joining tables on that key.
This next...
April 11, 2007 at 1:38 pm
I'll have to ask the sysadmin about that info... I'll post it in here when I get his reply.
April 11, 2007 at 12:53 pm
We are no longer experiencing problems:
We're not using the memory tweak, but HP has updated the firmware. This fixed the problem and the error hasn't occured againg in...
April 11, 2007 at 5:46 am
nothing useful to my eyes of course this is a snapshot of it's current state, not of the time the error actually occured.
here...
January 11, 2007 at 4:43 am
Hi
I've also seen this error, on a SQL 2005 64bit with SP1 running on Windows Server 2003 64bit (clustered HP bladeservers). But I also don't know what is causing it....
January 11, 2007 at 2:30 am
Derek,
The problem is that the DBA responsible for that database had ignored the error for a while since it only occured (not daily, but frequently) at night during the execution...
April 13, 2006 at 8:21 am
Viewing 15 posts - 16 through 30 (of 36 total)