RyanB88's Q&A profile

• .NET Development Memory Costs (Static class versus instance)

  Hi every one! I have a rather big class "A" (~2000 lines of code, and yes I wish I could break it up into smaller ones...) that is used for image processing by class "B" and now I would just like to ask you all a basic question about memory costs. I have a choice between making "A" a static class or creating an instance of "A" and pass a reference to it to "B" or making it a private static member of "B" or making it a private instance member of "B". The question is what would be the initial difference in memory costs between these approaches, if any Or to put it more general, is there a noticable difference between creating an instance of a (utility) cl ...Show All

• SQL Server Custom Task and Reading Package Configuration

  Hello All, I have searched on this forum for a similar question but couldn't find it so I apologize if this has been asked. If so, I'd greatly appreciate a link to the question. I have created a custom task and am trying to read an xml package configuration file within my custom task. To be more specific, I have added an ADO.Net Connection to my database onto the package and have generated the appropriate tags within my package's configuration xml file. I'm not seeing the classes I should use to access the configuration file of the package I've created. Does anybody have any ideas how I can accomplish this or a link to a document that might cover the material Thanks! Jay_G Hello Kirk, Th ...Show All

• SQL Server Upgrading Reporting Services 2005

  Hello all, I have a SQL Server 2005 64-bit Standard Edition install of the database engine and Reporting Services on a server. The BI team would like us to upgrade the server from Standard Edition to Enterprise Edition of SQL Server and Reporting Services to take advantage of data driven subscriptions. Does anyone know if this is a straightforward upgrade (another words .. install EE on top of SE), or is it better to backup the databases, remove SQL Server and RS, do a clean install, and restore the databases back to the server Thanks, Eric Eric, You should be able to just run EE setup.exe and it will upgrade the edition. It is recommended to backup the RS databases (in Management Studio) a ...Show All

• .NET Development Can a WSE 3.0 client talk to a WSE 2.0 server

  I have developed a new client webservice using .net 2.0 so I had to upgrade to WSE 3.0 security. The webservice that I have been using is secured with WSE 2.0. Is it possible to encrypt and sign my usernameToken using 3.0 in a way that the 2.0 server will accept the message. I have had no luck so far and I am starting to think that is may not be possible. If anyone know how this can be done please advice. The code I used in my 2.0 clients to sucure the message follows: Dim token As New UsernameToken( "name" , "password" , PasswordOption.SendNone) Service.RequestSoapContext.Security.Tokens.Add(token) Service.RequestSoapContext.Security.Timestamp.TtlInSeconds = 60 'message signature Dim tokenKeys ...Show All

• SQL Server Sql Delete Question

  I don't know if this is where I should post or not. I am trying to figure out how to get this select statement which generates all of the records I need to delete. Here is the select statement. SELECT * FROM SrcComputer as c join SrcDriverEntry as d on c . DriverEntryId = d . DriverEntryId join SrcFileList as f on d . FileListId = f . FileListId where c . compid = 567721765 I tried writing the Delete statement like this, but lo luck. DELETE FROM SrcComputer as c join SrcDriverEntry as d on c . DriverEntryId = d . DriverEntryId join SrcFileList as f on d . FileListId = f . FileListId where c . compid = 567721765 How would I re-write the statement t ...Show All

• Architecture Planning transactions with N-tier, distributed transactions, multiple databases

  Hi Forum I would like to know if there are some best practices for planning/documenting transactions in order to avoid deadlocks. We unfortunately have the bad habit of going into production before discovering deadlocks. The problem is that we have an N-tier architecture where developers can choose to start transactions that spans not just multiple tables but also multiple databases. So it is distributed transactions. It gets quite complex when many people implement transactions, not necessarily calling the resources in the same order. What should I as an architect do - Should I put together a document and have the developers document all transactions, including isolation level and in what order they are calling resour ...Show All

• .NET Development Itanium Web Services

  We are deploying a web service to an Itanium box. Everything works great on the 32 bit development platform but when we move it over it to the Itanium box errors are thrown. Does anyone know if it is possible to run debug on a Web Service that is located on an Itanium server If so, how is it done Thanks What kind of errors are being thrown Have you installed the itanium version of .net 2.0 - http://www.microsoft.com/downloads/details.aspx familyid=53C2548B-BEC7-4AB4-8CBE-33E07CFC83A7&displaylang=en ...Show All

• SQL Server Wrap Matrix after set number of columns

  I have a matrix that can grow in size from 10 to an infinite number of columns. I want to put a max number of columns to show before the matrix goes to the next line. I thought it would be something simple, but it doesn't appear that way. That or I am missing something completely obvious. Any ideas David, Did you find a way to achieve that functionality. I needed the same functionality and i was not able to wrap the matrix. It would be great if you can help me. Thank you, Raj ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Build speed with many projects

  I've been working on my first large XNA project and am finding that building my projects takes forever. I have both my Windows and 360 projects in the same solution, and there are 5-6 projects each. Normal setups like this in Visual Studio are a incredibly quick to build on average, but with GSE I notice that it seems to be invoking MSBuild for every project regardless of the solution configuration or dirty state. For example, if I have platform set to x86, my build output window still scrolls the 360 projects, each one taking 1-2 seconds to find out it's not set to build. Worse yet, it does this for every project, every time I build, even if I just made a one line change in an assembly with no dependencies; builds take 25-30 seconds! M ...Show All

• SQL Server Noise words

  Could someone tell me how I "turn off" the noise word filtering for SQL server My problem is that I use the neutral language (defaults to english) and it strips out some words I do not want stripped from my queries. So in this particular case, I would like to be able to turn off noise word filtering altogether. Ideas Noise words are stored in a text file, by default, it is in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\ Just edit the noiseNEU.txt for neutral language. Delete the word in the file. You may need to restart sql server and recrawl your index. ...Show All

• Visual Studio 2008 (Pre-release) Specifying behaviorConfiguration in code

  Is there a way to set the behaviorConfiguration for a ServiceHost (or Client for that matter) in code All examples that I've seen show it being set in app.config. I need the ability to define the behavior in the app.config, but then create the ServiceHost and endpoint objects entirely in code, passing to them the name of the config entry to use. I do something similar now for the bindings. I define the binding configurations in the app.config, but when I create the binding in code (for example wsHttpBinding), I use the overloaded constructor that allows me to pass in the string name of the entry in the app.config. I'd like to do the same thing for services and clients. Any ideas. Thanks. Bruce Bukovics Author of .NET 2.0 Interoperability ...Show All

• SQL Server Whole number to decimal format

  I have a report that returns an amount. The problem is that the amount shows on the report as a whole dollar amount example: 498, 99, 397 and so forth. I would like to be able to format the numbers to 4.98, 0.99 and 3.97 but I can not figure out how to format the decimal place two spaces to the left instead of the right of the whole number. If someone out there could help me out on this I would be extremely greatful. Thanks, Jen Duh!... I think I have officially earned idiot of the day and it is time for me to go home. I told everyone that my pregnancy was affecting my thinking skills. At least I have the temporary excuse that pregnancy shrinks a womans brain. Thank you so much for hel ...Show All

• Visual C++ NetUserGetInfo returns 1008 (GetLastError)

  Hi, I am developing a dll which uses NetUserGetInfo to retreive the home directory of a Domain user. NetUserGetInfo returns 1008 error code. my usage of function: NetUserGetInfo(Domain-server,domain-user,11,buf) The problem i was thinking was, The dll is launched by a local user(admin privilages) on a system which is in the same domain. SO may be the local user does not have enough permissions to use the NetUserGetInfo function to retreive the necessary information. My questions: 1. Is it possible to provide enough permissions for the local-user to access domain users properties, How 2. The other alternate is to connect to domain-server with some power user and then use the NetUserGetInfo function. But I do not find suitable function to c ...Show All

• Visual Studio 2008 (Pre-release) Working with Subscribe-Publish

  Is anyone familiar with the Publish-Subscribe project It's available online and I think it was written by people from IDesign. I'm trying to figure out ways to save the Transient Subscribers info in the database in case the host server goes down. I've noticed the list of transient subscribers are retrieved by: T subscriber = OperationContext.Current.GetCallbackChannel<T>(). Is it possible to save the subscriber data in the database Thanks. The IDesign Demo offers as persistent subscriber as well, if you downloaded the demo off of the idesidn site it should have came with it, including SQL scripts. Here's a link which may help: http://msdn.microsoft.com/msdnmag/issues/06/10/wcfess ...Show All

• Visual Basic What's the deal with Generics

  Hi, I have the following Function Public Function EnterOrder( ByVal custCollection As Generic.List( Of CustomerDTO), ByVal OrderDTO As OrderDTO) As Boolean Dim customerBOCollection As New Generic.List( Of CustomerBO)(custCollection) ...............Do stuff End Function I get an error when I run the program basically saying unable to convert CustomerDTO to CustomerBO. What other way around this do I have CustomerDTO is my serialized object and CustomerBO (name speaks for itself) is the one with the rules etc. With one customer it works like this Dim customerBO as new CustomerBO(CustomerDTO) I now need to pass a collection of customers and I was turning to Generics for assistance. Any ideas ...Show All