BIG S's Q&A profile

• Visual Studio Team System Invaild Process Performance Counter (% Processor Time = 8,056?)

  Could any one explain why VSTS reports that w3wp uses 8,056% of the processor This is consistently happening See Q4 here http://picasaweb.google.com/jakeb16/Questions -Jacob Blumberg This looks strange. I believe it is possible to see a value greater than 100% on multi-processor systems (for the _Total instance), but that is certainly not the case here. The screen shot shows that it may be happening on a one minute interval. Is this the case I would be interested in knowing if perfmon is also reporting the same value for this performance counter on one minute intervals. Thanks, Rick ...Show All

• .NET Development SqlBulkCopy: the locale id '0' of the source column '<column name> ' and the locale id '1033' of the destination column '<colum

  Hi, I am using the sqlbulkcopy object to transfer large amount of data from one SQL server to Other. The code look like this.. SqlDataReader readerSrc = null ; SqlBulkCopy bulkCopy = new SqlBulkCopy (connDest); //Prepare Destination Table. SqlCommand cmdDelete = new SqlCommand ( "DELETE FROM " + destTableName, connDest); //Set the sqlcommand text SqlCommand cmdGet = new SqlCommand ( "SELECT * FROM " + srcTableName, connSrc); //Open source connection. connSrc.Open(); //Open destination connection. connDest.Open(); int delete = cmdDelete.ExecuteNonQuery(); //Get the data. readerSrc = cmdGet.ExecuteReader(); //begin transfering data to destination bulkCopy.DestinationTableName = destTableName; bulkCop ...Show All

• SQL Server Cannot set a Variable from a select statement that contains a variable??? Help Please

  I am trying to set a vaiable from a select statement DECLARE @VALUE_KEEP NVARCHAR ( 120 ), @COLUMN_NAME NVARCHAR ( 120 ) SET @COLUMN_NAME = ( SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CONTACTS' AND COLUMN_NAME = 'FIRSTNAME' ) SET @VALUE_KEEP = ( SELECT @COLUMN_NAME FROM CONTACTS WHERE CONTACT_ID = 3 ) PRINT @VALUE_KEEP PRINT @COLUMN_NAME RESULTS ------------------------------------------------------------------------------------------- FirstName <-----------@VALUE_KEEP FirstName <-----------@COLUMN_NAME SELECT @COLUMN_NAME FROM CONTACTS returns: FirstName SELECT FirstName from Contacts retu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Sun to affect a terrain? How?

  Hi. I have an FX code that I wanted to show you (if it helps) to process the light to the terrain. Here is the code: float4x4 WorldViewProjection : WORLDVIEWPROJECTION; texture UserTexture; float4x4 xRot; float4 xLightPos; float4 eye; float4 ambientMaterial; float4 diffuseMaterial; float alpha; float xLightPower; struct VS_OUTPUT { float4 position : POSITION; float2 textureCoordinate : TEXCOORD0; float3 normal : TEXCOORD7; }; sampler textureSampler = sampler_state { Texture = < UserTexture >; magfilter = LINEAR ; mipfilter = LINEAR ; }; struct Pi ...Show All

• .NET Development Yet another MSIL question (ldsfld, ldarg_0 problem)

  Hello everyone, I really hope someone can help me out as this is a major break point in my development process. I've been googling for info to no avail, and sadly my knowledge reaches a certain extent, being self-taught. I've been working with IL lately, and I came to the point where optimization was needed (since I'm working in a real-time 3d environment). The code - which was working (thanks to S. Senthil Kumar) - contained ldarg_0 instructions. Too many in my opinion, since the argument was already loaded onto the stack, as far as I know. I was passing to the dynamic method an object array (defined as params object[] in the delegate). Argument: object[] objectParams ldarg_0 ldc.I4 0 ldelem_ref call (calling some method in ...Show All

• SQL Server Meta Data Services SQL 2000 "msdb database could not be opened"

  Hello anyone / everyone, If you are having trouble accessing Meta Data Services on W2k3 and SQL 2000 and get the error that the "msdb database could not be opened" I found that hot fix 912812 on the operating system is the culprit. Remove it and Meta Data goes back to working, although I am being asked to approve the ActiveX control every time the page refreshes. Hope this helps somebody, to took me long enough to track it down. If anyone has a resolution to the ActiveX question I'd love to know the answer. Thank you, Uncle Davy That would seem the logical choice. However, I tried permitting every activeX and it was still giving me the error! ...Show All

• Windows Search Technologies how I can get Vista to index Office 2007 Outlook instead of Windows Mail?

  Hi there, Now that Vista and Office 2007 have been RTM'd, I have installed Windows Vista and then opened Windows Mail to check an installation issue on a Vista Newsgroup. I then installed Office 2007 and connected to our company Exchange server. Unfortunately I now find that Vista Search only finds indexed Windows Mail items and not any Office 2007 Outlook items. I have followed the suggestion of changing Start Properties menu to point to Microsoft Office Outlook and then rebooted and have even rebuild entire search index again, but it still only indexes Windows Mail items instead of Microsoft Office Outlook! I have also opened the control panel - Index Options - Advanced - File Types tap and ...Show All

• Visual C# enumerator modification

  i want to delete an object from arraylist after performing a method. but when it says Collection was modified; enumeration operation may not execute. this is my code: while ( true ) { lock (m_lockobj) { //creates the enumerator to loop through all elements in the array list IEnumerator enumerator = arrlst_ResetActionTable.GetEnumerator(); while (enumerator.MoveNext()) { ResetActionFire m_ResetActionFire = ( ResetActionFire )enumerator.Current; TimeSpan diffenceInterval = ( DateTime .Now) - ( DateTime )(m_ResetActionFire.lastTimeStamp[0]); long lThresholdDuration = ( long )diffenceInterval.TotalSeconds; if (lThresholdDuration >= m_ResetActionFire.lResetThresholdDuration) ...Show All

• SQL Server Catalog Population performance

  Question on what affects performance of catalog population... We just got new servers with faster CPUs, More memory, and faster hard drives... However when we get everything going the new servers seem faster in all aspects except catalog population. The examples I can give are we have 3 catalogs with a 4th in development... our smallest took under 20 minutes on the old servers and now take over an hour... our largest catalog used to take about 10 hours but it currently is about 14 hours into population and only is about 70% done... Help Please.... any thing to look at for all aspects.... Oh... SQL 2000 standard SP3, Windows 2003 Enterprise, 16Gb ram, 2 SCSI drives mirrored... Only difference from old system is faster har ...Show All

• Visual Studio Express Editions I am stuck! PLEASE HELP!

  Hi! Well i am trying to make a browser. I want to let the users change their home.But i cant find one single word!Heres the code:(thanks!) private void button7_Click(object sender, EventArgs e) { webBrowser1. (textBox1.Text); } The spot is marked with: thx leo you have a couple of options of saving it. you can either save it to an xml file for example or save it into an application settings file - this would be better. To use application settings...take a look at this: http://msdn2.microsoft.com/en-us/library/ms973902.aspx using Application settings would be the best way really, since you can read/write back easily and its kind of a standard to save settings for your application ...Show All

• Visual C# win forms needing a bit of help

  Hi im needing a bit of help and i think this is the right place i need my win form to show text from a .ini file when it loads but i need the text from lets say line1 in the.ini file to show in textbox1 like a loadfile dialog with out the dialog thanks ok well, you could use a StreamReader and treat it like reading a normal text file. using (StreamReader theReader = new StreamReader("file.ini")) {    if (theReader.EndOfStream == false)    {       this.theTextBox.Text = theReader.ReadLine();    } }   this will read the first line and place the text read into the textbox. Remember to import the System.IO namespace to ...Show All

• SQL Server Can't see or access tables through linked server

  Apparently I am doing something wrong and I don't know what! I am needing to link a remote Oracle Server to SQL Server 2005. I have (I think) followed the steps precisely to create the linked server both by code or through the SQL Server Management Studio and I get the same results eith way. I can see the linked server and there are no apparent errors but I can't see or access the tables from Oracle. If I try a Select statement on a table from the linked server I get the error "Msg 208, Level 16, Stat 1, Server {servername}, Line 1 Invalid object name" I am assuming this is a permissions issue but I don't see it. I am an admin on both the SQL Server DB and the Oracle DB with full access and I am using w ...Show All

• Visual Studio Express Editions C# Equivalency of VB function "DoEvents"

  Basically the DoEvents function does something mainly used for waiting. Here's an example: Do Until Winsock1.State = 7 DoEvents Loop That example waits for the winsock control to successfully connect. So how would I perform the same task in C# Thanks in advance ...Show All

• Visual Studio Express Editions run method from a different class - oop issue :-(

  I'm struggling to get my head round OOP properly - please help! On my Form1 i have a button. this button calls a method "launchmMenu()" which is written within "public partial class Form1 : Form" now my head is hurting I read that post, can see how it relates to getting to variables, but can't see how i can use it to call the method ! raising an event from the other class sounds more like what i need - can anyone point me in the right direction of how to do this please ...Show All

• Visual Studio Team System Avg.Response time deatail

  Hi, In our load test result we have avg.response time max = 9.38 and we would like to find out what request or test scenrio happened during that time which caused peak time. Is is possilbe to find out For some of my requests, the page counter is not recorded at all. So for instance i will have 224 *requests* to shop.aspx, but only 42 total "page views" to Shop.aspx. Shouldn't the total requests and the total page views be equal ...Show All