Ian Munro's Q&A profile

• SQL Server LIMIT Clause

  It seems current version of SQL Server doesn't support LIMIT clause in SELECT statement. Will future version of SQL Server support it Thx. Maximilian, I don't know if the keyword LIMIT will be supported, but even in the current version, you should be able to get the same functionality with the enhanced TOP syntax and/or the new ranking functions. For example, to delete just 10 rows: delete top (10) from ... and to select rows 50-59 in some order: with T as ( select row_number() over (order by someColumn) as rn, * from someTable ) select * from T where rn >= 50 and rn It seems current version of SQ ...Show All

• .NET Development Webclient.uploadfile don't work if WebDav not implement on the server

  Hello, I try to use webclient with visual studio 2003, and it success just with the PUT method and only if a webdav service is activated on the server (IIS). with the POST method it return each time the error 405 : not - authorized method (translated from franch : "Methode non autorisee". How can i do with the POST method, how configure the server Thanks This doesn't look like a WebClient problem to me. It appears POST is not enabled on the server side. You have to go to the server side, open IIS, go to the f ...Show All

• Windows Live Developer Forums possible bug or maybe just one of my annoyances??

  ok just a small problem ive been having with the beta. ive noticed that when any of my contacts sign in or out my contact list jumps to about halfway down my contact list. seemingly following the contact thats signed out. (dont understand why it does it when they sign in.) Im guessing that its something thats supposed to happen possibly but i do really find it annoying. Can anyone else confirm this for me Does it happen for you Is there anyway to turn it off The purpose of this forum is to discuss MSN and Windows Live application development using the Messenger Activity API, and Windows Live Bots. If you ...Show All

• SQL Server Query performance

   have a database table. The table has number of fields. Out of those fields one is Company and another is DateTime. The table has thousands of records. I want to get the most recent record for each company. In order to do that I am using the following query SELECT * from CompanyDetail AS X WHERE [DateTime]=(SELECT max([DateTime]) FROM CompanyDetail WHERE Company=X.Company) ORDER BY Company Note: There is only one record exists for the given company on a given date The problem is that this query is very slow. Am I doing something wrong or there could be another alternative way to improve it Just to clarify that I am using Access datab ...Show All

• Smart Device Development Connection Manager: controlling which "provider" is used (i.e. which connection method is used)

  With the documented connection manager API, it appears that you can only control which "Destination" is used (i.e. "Internet", "Work") when using "ConnMgrEstablishConnection" However the device may be configured with multiple "providers" (I think that is the correct term - confusing...) - for example, GPRS, WIFI, WIFI with proxy, Dialup, etc. I would like my software to be able to control which method of actually connecting to the internet is used, or at least be able to know (and therefore decide to not connect). For example, to try WIFI first (and not cause GPRS or dialup to try connecting) ...Show All

• Visual Studio Two Help Collections provide duplicate content

  I've got SQL Server 2005, MSDN 2005 and VS.NET 2005 installed on the same machine. Therefore, I've got the SQL Books Online in two places - in MS.VSIPCC.v80 and MS.MSDN.v80. The symptom is similar to that seen when installing VS.NET 2003 and MSDN - you would typically de-select one of the collections from inside the viewer launched from VS.NET. What's the process now Thanks! Hello rbellamy, When you said " de-select one of the collections from inside the viewer launched from VS.NET " are you talking about Preferred Collection drop down in Tools> Options>Help in Visual Studio 2003 &n ...Show All

• .NET Development Help need with XML?

  Hi, http://www.microsoft.com/downloads/details.aspx familyid=E0FAA0AF-A185-4296-B74D-A9FE870C92CC&displaylang=en i downloaded one exe "OfficeWordWordMLtoXSL-FOSample.exe" from the above link and they given some steps how to convert xml file in to fo file, i did the same thing and fo is also created. but i want to convert that fo file in to pdf is there any tool microsoft provides and also that fo file format is different than what normal fo is having ie normally fo is having root element,masterpage set and sequence master page etc.. that things are not there in that fo file (which created by using the above procedure) Can ...Show All

• Visual Studio Do all custom properties have GUIDs?

  Do all elements in a domain model including custom properties have by default a GUID assigned I can query If not how could I do that Two thoughts: 1) Calculating a custom property value ( http://forums.microsoft.com/msdn/ShowPost.aspx PostID=15445 ) If yes, where exactly do I have to implement method "GetValueForCustomStoredAttribute" 2) Creating a custom property of type GUID and assign the actual GUID at runtime as asked in http://forums.microsoft.com/msdn/ShowPost.aspx PostID=68141 Cheers, Alex Hi Harry, I think that decision is probably lost in the mists of time to be quite honest with you.  The ma ...Show All

• .NET Development FileSystemInfo missing functionality - GetSize() and GetSizeOnDisk()

  It's a bummer that I can't get the file/dir size and size on disk e.g. FileSystemInfo.GetSize() and FileSystemInfo.GetSizeOnDisk().  It would be great to get this in the next version unless this functionality is already in the framework somewhere. Yeah I realize that properties are implemented by accessor methods under the covers.  However, the .NET Guidelines state that properties should behave more like simple state set/get.  Any property that is long running should probably be re-written as a Get*() method.  Which is why I was expecting to find a GetSizeOnDisk() *method* (rather t ...Show All

• SQL Server nvarchar vs char

  Hi, This is a design question but performance and efficiency related so I hope this is the right forum. If I define a table column to be nvarchar(2) would it be more efficient to define it as char(2) I am thinking that for an nvarchar(2) there would be a byte or two of storage used to hold a length of the value held and SQL server would need to do some work to interpret this. I have reference which suggests using char(2) is the way to go but it gives no reason. Any comments Denis   Fist, nvarchar is Unicode and char is not. For Unicode, every letter uses two bytes. But le ...Show All

• SQL Server Multiple details sections, possible?

  In a table the details section is called "table1_Details_Group". Is it possible to add a second details group so that I can have the two groups have different group properties I'm trying to avoid creating a second table and using an expression to only show one at a time. Again Thanks. possible poss bile poss-bile possibler possibly Edit... Revert to "possbile" See this tutorial on adding groupings to a report. It uses a table for an example. http://msdn2.microsoft.com/en-us/library/ms170623.aspx ...Show All

• .NET Development How to use System.Net.Mail.SmtpClient via SSL and Authentication?

    Below is my code, and is just blocked there. There is no any error message. '=============================================>         Dim msg As String = "---"         Try             Dim strAddress As String = " xxx@xxxx.com "             Dim sm As New SmtpClient(Host, Port)             With sm               &nbs ...Show All

• Visual C# string to int

  Hello everyone, Im trying to setup a progress bar, right now this is basically how it is set up, first I have the app count lines in a text file, this works ok: textBox2.Text = rowCount.ToString(); rowCount++; inputstring1 = StreamReader1.ReadLine(); then later, I have this where the listbox is being populated, the progress bar should show the progress of the population. textBox2 displays the number of rows, and the maximum should be this number but when I try to compile it, it gives me an error saying that it cant convert string to int, so I tried this with no luck.: progressBar1.Minimum = 0; progressBar1.Maximum = Conv ...Show All

• Visual Studio Team System Required Domain Accounts - why?

  Why does the single-server deployment installation require one to use separate accounts for VSTF I would much rather use the service account so that I don't have to change these passwords every 90 days (our policy). Do I really need these three accounts (TFSSetup, TFSService and TFSReports) for a single-server deployment What Chris said was exactly right and the principle of "least privilege" certain plays a role in these kinds of decisions.  However there's another reason.  We imagine that many people will write reports.  We want to limit the permissions of the account that reports run as so that a report can't change d ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Reading compressed textures

  Hi, I have been working on a small 3d project for myself and i was wondering if anyone can help or point me in the right direction. Im trying to read in dxt compressed textures, i have been reading about the format in msdn and have been looking for some source code or tutorials on how to read these formats in. Im using C# and MDX i have posted the the source code that i have been playing with so far, this is to read a DXT1 compressed image. If anyone has some sample code, links or a better way to go about this please let me know. Thanks for any help,     -Dave   // CODE SurfaceDescription s = t ...Show All