View Complete Post
I want to find out how to get memory information from SQL Server using DMVs that will equal to or be very close to the memory shown in Mem Usage column of Windows Task Manager for sqlservr.exe. I have tried to sum
single_pages_kb, multi_pages_kb, and virtual_memory_committed_kb from sys.dm_os_memory_clerks but the combined total is still less than the Mem Usage from Windows Task Manager.
My memory in task manager reaches about 900,000K and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.
Edited by Nancy Michell
MSDN Magazine June 2004
I have a series of Crystal Reports that I can view/edit using Visual Studio 2005 with no issues. The method I'm using is to simply click on the *.rpt file and it opens in the VS crystal editor with no issues. The problem I'm having is that we are upgrading to Visual Studio 2008, and when I open the *.rpt file in 2008 it opens as a binary file. I guess I'm used to everything else in Visual Studio prompting me to convert the older version to the newer version, so I'm not sure what to do in this case.
Is this normal? Is there an easy conversion method that I'm simply overlooking? Am I screwed? Who invented liquid soap, and why?
Answers to any of these questions would be greatly appreciated...
Hi and thanks.
I'm getting an error on serveral reports that I built in VWD2005 (express) using the reportviewer control. Trying to edit the rdlc file in VS2010, VS2010 asks if i want to convert the file to RDLC 2008 format and I click ok. When I build the site, I get this error (and of course also when the report is ran):
Error 1 The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. C:\inetpub\wwwroot\mastercardlcm\Reports\WorkLists\OpenSRStatus.rdlc 1
Here is my web.config concerning the RDLC assemblies, etc.
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=22.214.171.124, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
<add assembly="Microsoft.ReportViewer.WebForms, Version=126.96.36.199, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
Am in the process learning C#, My instructor uses Visual C# 2005 Express and on my side I have Visual Studio 2008 Pro.
Do you think it will affect me in my Coding practice due to the different IDE Versions? Wha do I have to heed when coding?
i cant install sql server 2005 nor 2008 on my windows 7 os
i read about somthing like adding new account when installing sql 2008 to provision the server or so, but didnt know how,,,
can you plz help me??