Browse by Tags

While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command

Published 27 August 7 5:47 AM | SSQA.net

Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google either. Any help would be appreciated. When performing the data mining cube process - Error: Memory error: Allocation failure : Not enough storage is...

Filed under: sql server, performance, memory, server, process, cube, Analysis Services

32bit vs 64 bit what other factors you need to consider?

Published 14 August 7 8:16 AM | SSQA.net

Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of...

Filed under: sql server, performance, memory, server, windows, x64, system, hardware, 32 bit, 64 bit

Performace overhead and resolution when using CLR vs TSQL

Published 31 July 7 3:42 AM | SSQA.net

Integration with .NET framework CLR within SQL Server gives extra flexibility for the developers to use other programming languages such as C# or VB.net by creating functions, stored procedures, triggers, data types, and aggregates are among the kinds...

Filed under: sql server, performance, memory, server, clr, tsql, managed code

/3GB /PAE and AWE blurb what is it you hear within your environment?

Published 25 July 7 9:6 AM | SSQA.net

You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From...

Filed under: sql server, performance, management, memory, microsoft, security, server, windows, awe, /3gb, pae