“There is insufficient system memory in resource pool ‘internal’ to run this query”

During Initial versions(RTM) of SQL 2008 and R2 I have observed multiple posts related to the error “There is insufficient system memory in resource pool ‘internal’ to run this query”.

Mostly the error comes up if a Full Text Query is ran which uses compound words,however the same error comes up on different situations too and there was a BUG which was opened for this case too

http://connect.microsoft.com/SQLServer/feedback/details/484787/there-is-insufficient-system-memory-in-resource-pool-internal-to-run-this-query

The good news is that SQL Server Product team have fixed this issue and if you are facing this error in your systems(RTM) right now,then you can go ahead and deploy the latest service pack for SQL Server 2008 and R2.

SP3 for SQL Server 2008

http://www.microsoft.com/download/en/details.aspx?id=27594

SP1 for SQL Server 2008 R2

http://www.microsoft.com/download/en/details.aspx?id=26727

Visual Studio .NET Code Editing Tips & Tricks

While surfing the net, I bumped up an interesting document that contains tips & tricks to increase your productivity in Visual Studio .NET.

VSDOTNETCodeEditingTipsAndTricks (Pdf)

Note : Most of the tips in the article are handy shortcuts.

Creating and using code snippets

I really like working in Visual Studio, and love the new features and user friendly tips and tricks to make my work more easy, today i would share one of the features that I really appreciate in Visual Studio is “code snippets”. Code snippets help you to speed up the development by giving you shortcuts to frequently used code.

For example if you want to create a for loop, you simply type for and press the “TAB” button twice.

Visual Studio will then automatically generate the code for you as you can see below.

By using the tab key, you can navigate to the marked words which enables to specify your own names.
That’s not all. The nicest thing about code snippets is that you can create your own code snippets.
In the following example, I’ll show you how.
Create a new file cend.snippet within Visual Studio 2005 and save it under the …\My Documents\Visual Studio 2005\Code Snippets\Visual C#\My Code Snippets folder.

Copy the following code in the file, I’ll explain the code in a minute:

<!–?xml version=”1.0″ encoding=”utf-8″ ?>
<CodeSnippets xmlns=”http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet”&gt;
<CodeSnippet Format=”1.0″>
<Header>
<Shortcut>cend</Shortcut>
<Title>End console</Title>
<Description>Code snippet for ending a console application</Description>
</Header>
<Snippet>
<Declarations>
<Literal>
<ID>EndMessage</ID>
<Default>Press any key to continue … </Default>
</Literal>
</Declarations>
<Code Language=”CSharp”>
<!–[CDATA[
Console.WriteLine(“$EndMessage$”);
Console.ReadLine();
]]>
</Code>
</Snippet>
</CodeSnippet>
<!–CodeSnippets>

Save the file and open a C# application. In one of the .cs files, type cend which will popup the intellisense menu.

When you press the “TAB” key twice, the following code will be generated:

How does it work:
The second line in the snippet file informs Visual Studio to use an xsd to help you by providing intellisense (the xsd is located in C:\Program Files\Microsoft Visual Studio 8\Xml\Schemas\1033\snippetformat.xsd depending on where you installed VS):

xmlns=”http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet”&gt;

The shortcut contains the shortcut that you can use to reference to your code snippet. You can also reference the code snippets via the menu or via the Ctrl+K, Ctrl+X combination.

A literal is a variable that can be used within your code snippet. When using the code snippet, each literal is a placeholder for user input. You can add a default value as done in the sample.

Within the code element, comes the real code snippet. It is embedded in a CDATA element to be able to include special elements in the xml document.

It is also possible to create multiple snippets (1 snippet per file) 🙂

Reference : Geert Verhoeven Blog

Enabling InfoPath Forms Services 2007

I know most of the companies are using SharePoint 2010 and majority have migrated to it or planning to, but there are still a lot of clients still using and happy with the working of SharePoint 2007. Just like mine :).

So recently got a chance to configure the Info-Path on my clients site, the below are the steps to enable the Info-Path Forms Services.

It is quite simple to enable Info-Path Forms Services 2007 on your Microsoft Office SharePoint Portal 2007. Follow the steps below to use browser-enabled forms:

Central administration

1. Go to the Central Administration
2. Click on Application Management
3. Click on Configure Info-Path Form Services under the Info-Path Forms Services section.

(http://myserver/_admin/ipfsConfig.aspx)

4. Make sure that browser-enabled form templates are allowed
(Check all check boxes in User Browser-Enabled Form Templates)

5. You can specify other options if necessary. Click on OK to apply the changes.
6. You can close the Central Administration Website.

List Configuration


I created a new Document Library on my site called ‘Info-Path Forms’. This document does not open Info-Path forms in your browser directly. You must configure this list in this way:

1. Open the List which contains browser-enabled Info-Path Forms
2. Click on Settings and select Document Library Settings

3. Select Advanced Settings Under ‘General Settings’
4. Configure the Browser-enabled Documents section and select ‘Display as a Web page’

5. Click on OK to confirm the changes

Publishing Info-Path Templates

Use the Publish Wizard to deploy the form on your Sharepoint Portal Server.
Define the location, promote the fields and publish!
(In this example you must update an existing Document Library)

Use following URL structure to deploy

http://myserver/SiteDirectory/mySite/myList/Forms/AllItems.aspx

Testing the deployed form

Create a new document in your ‘Info-Path Forms’ list. The form will be automatically open in your browser.

Tips

You can manage the toolbars at the top/bottom in Info-Path 2007.
(menu Tools > Form Options > Browser > ‘Show toolbar at top/bottom of form’)

Reference : Very Helpful Post