Martin Kristensen's Q&A profile

• SQL Server Update query runs very slow in SQL 2005 than SQL 2000

  We have upgraded our database server from SQL 2000 to SQL 2005. To migrate the DB I attached the mdf file in SQL 2005. After migration website loads quicker than earlier but records updation ( no of records are 20k) got slowdown. I have found that update query run very slow in SQL 2005 as compared to SQL 2000. Although other select query run very faster. Query is called from ASP (active server page) page. Changing of fill factor option from 0 to 70 also did not work. I also have set the competible leve to 90. OLD Sever Config: dual xeon 1GHz, 512MB RAM, window 2000, MS SQL 2000 New server Config: Dual Core Xeon with 2 CPU, 10 GB RAM, window 2003, MS SQL 2005 size of mdf file is 16GB Rebuilting of index did not improved the p ...Show All

• Windows Forms HyperLink in DataGrid

  Hi I'm using a GridView in VB.Net 2005. One of the column of the GridView is Hyperlink Column. When i click the hyperlink i want some message to be displayed in tne redirected page. The message displays in each link should be different. How can i achieve this Where should i write my coding Thanks Is the ID column a part of the datagridview. If so, you can get the data in the id column like this Me.DataGridView1.Rows(rowIndex).Cells(idColIndex).Value ...Show All

• SQL Server SQL Server 2005 Security:

  Hi I have a sitaution where I have domain admins logging on to SQL SErver and automatically accessing SQL Server as syadmin. Here are the steps I am planning to take to fix this problem! 1. Create a a non administrative domain account called SQLDBA and add it as sysadmin on SQL Server. 2. Make sure the SQL Services are using a special account called SQLServices non administrative domain account with Log on as service rights and added as a sysadmin on sql server. 3. Remove the builtin\administrators from sql server The way I envision this is anyone who log on with a domain admin acct will need to specially log on to sql server with a restrictive sql login instead of how they use to automatically get logged in. Are there an ...Show All

• Software Development for Windows Vista GetVersionEx weirdness on Vista. Please help

  I am calling GetVersionEx to get the windows version. I am using code sample provided at http://www.codeproject.com/win32/osdetect.asp . On WindowsXP it correctly returns 5 as the major version. But on Windows Vista, it returns 5 again instead of 6. Has anyone see this issue or any ideas why GetVersionEx returns incorrect value on Vista So far I have tried compiling with different settings of _WIN32_WINNT, reinstalled Vista just to be sure, tried to run this on a different Vista system with the same incorrect result. I also tried GetVersion instead of GetVersionEx too without success. Should I check for some registry keys or something I am stuck on this for more than a day now. Appreciate any help. Thanks. ...Show All

• Visual Studio While doing analyze

  Hi all, While analyzing the DB, i am getting message like.... The file 'd:\vssdb\data\f\freaaaaa' appears to be corrupt. Unable to read the format or header. The file 'd:\vssdb\data\g\greaaaaa' appears to be corrupt. Unable to read the format or header. The file 'd:\vssdb\data\i\ireaaaaa' appears to be corrupt. Unable to read the format or header. The file 'd:\vssdb\data\m\mreaaaaa' appears to be corrupt. Unable to read the format or header. The file 'd:\vssdb\data\q\qreaaaaa' appears to be corrupt. Unable to read the format or header. The file 'd:\vssdb\data\r\rreaaaaa' appears to be corrupt. Unable to read the format or header. The file 'd:\vssdb\data\s\sreaaaaa' appears to be corrupt. Unable to read the format or header. The fi ...Show All

• Visual Studio Tools for Office Post It Note Type Comments Control In Word Document

  I knew there was a reason I was looking at VSTO, I have a C# Windows App, and I am showing the user a Word doc using the DsoFramer control for viewing and editing. All this works fine, what I would like to know how to do (and I do not know if an AddIn or a WordProject is my best bet) is how do you create a "Post It Note" type control allowing the editor of the document to "Add Post It Note" , and also veiw other comments that were previously created. (preferably in a yellow balloon or box like a "Post It Note"). A super plush would be a way to toggle "View Comments - turn them all on if they are there - and Hide Comments - make them all invisible if there are any. Another plus (or point to note) is ...Show All

• SQL Server Local Cube Distinct Count Behavior in SP2

  I am the lead designer of CubeSlice, a local cube generating product. Our product allows a user to create local cube files either with ASSL using an Analysis Server 2005 connection or ASSL with a relational data source connection. We allow users to include Distinct Count measures in their local cubes. When using an Analysis Server connection we convert the Distinct Count measure into an equivalent calculated measure. When using a relational data source connection we use the Distinct Count measure directly. Using the Distinct Count measure directly provides significantly better browsing speed. The local cube creation behavior appears to be changed now with SP2. When a Distinct Count measure is used in a local cube created with a relation ...Show All

• SQL Server Urgent: ASP.NET 2.0 and SQL 2000

  When using Form authentication, can we not use SQL SERVER 2000 When I am working with the ASP.NET Web Site Administration Tool Wizard, it tells me that: Your application is currently configured to use: Advanced provider settings How can I use my existing database on SQL SERVER 2000 Please help. Do a quick check on your web server. Make sure: It has .NET Framework 2.0 installed Your IIS can access your SQL Server machine (use both ping to IP and DNS name of the SQL Server machine) ...Show All

• Visual C# waveIn usage in .NET

  I need to incorporate some recording functions, for example the ones that begin with "waveIn...", into a visual studio program written in C#, but adding "using System.Media" still does not allow them. I am talking about functions described in <ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.WIN32COM.v10.en/multimed/htm/_win32_waveform_audio_reference.htm>. What do I need to do Those are Windows API functions, you'll need P/Invoke to call them. Visit www.pinvoke.com and see if you find the required declarations... ...Show All

• Visual Studio Express Editions how to modify a timer?

  hi all, i found this simple timer on http://www.developer.com/lang/other/article.php/792901  5:  using System; 6:  using System.Timers; 7:  8:  class myApp 9:  { 10:    public static void Main() 11:    { 12:      Timer myTimer = new Timer(); 13:      myTimer.Elapsed += new ElapsedEventHandler( DisplayTimeEvent ); 14:      myTimer.Interval = 1000; 15:      myTimer.Start(); 16:  17:      18:      19:        20:      21:    } 22: 23:    pub ...Show All

• .NET Development Hight CPU Usage on idle

  Hey guys, Could anyone please have a look at this code. As soon as the Listener is started the CPU runs up to +40%. Code: Imports System.Net Imports System.Net.Sockets Imports System.Text Public Class clsServer     Public Clients As New Collection     Private Listener As TcpListener     Private t As System.Threading.Thread     Private reader As System.IO.StreamReader     Private writer As System.IO.StreamWriter     Private Lock As String     Public Sub StartListening()         'We'll use the local IP (127.0.0.1) and port 2501         Listener = New TcpLis ...Show All

• Visual Studio Express Editions Help!!! new to programming c++

  I am taking c++ at my university. I have an assignment due on Tuesday. I am having trouble getting this program to work.. I'm using visual studio 2005, I barely understand what I'm doing.. Please help me!!!! Chrissy // assignment1.cpp : Defines the entry point for the console application. //Converts distance in miles to kilometers. #include "iostream.h" using name space std; int _main() //start of main function { const float KM_PER_MILE = 1.609; //1..609 km in a mile float miles, KMS; //input: distance in miles //get the distance in miles cout << "Enter the distance in miles. "; cin >> miles; //convert the distance to kilometers. kms = KM_PER_MILE = miles; //d ...Show All

• SQL Server I need a duplicate "empty" database created from an existing "populated" with data. sql 2005

  I need a duplicate "empty" database created from an existing "populated" database with data. I need this to be created on a new Server not the existing box. Any suggestions In SSMS, right-click on the database, select [Tasks], then [Generate Scripts]. On the second screen, select your database, and at the bottom of the window is a checkbox to [Script All Objects in the Selected Database]. You can either save the script to re-run as often as needed, or execute immediately. Change the database name in the CREATE DATABASE script. You can also change the filenames and locations if needed. ...Show All

• Windows Forms Adding help to an application

  I have used HelpStudio lite to generate help content but I can't figure out how to add it to my application. The help keeps talking about adding / registering it to Visual Studio, but I just want it to be relevent to the application I am developing. How do I display the help window How do I get the help content being displayed to be the help content I produced Thanks, John This may sound like a stupid question but... Are you trying to create a help file to be used outside of VS2005 IDE ...Show All

• .NET Development i dont know what Im doing wrong.

  Hi, im a beginner so bear with me. Im trying to invoke this webservice : http://www.webservicex.net/airport.asmx WSDL I've added a web refernce in my project and I've written some code in an asp.net web application project. The problem is that when I try display the results of the webserive in a list box the properties of the web service dont appear here is my code using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; namespace AirportInfo1 { /// <summary> /// Su ...Show All