Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dhoward007

    Benchmark Testing

    what is the tpch website?
  2. dhoward007

    Hard Drive Failure, SQL Server won't start!

    There is a way to recover the server... I just performed this today.. you go to the command line in the microsoft sql server\binn and run the sqlervr -c -f that will start the sever up .. then you must move the location of the tempdb by opening sql query analyzer and run the commands below...
  3. dhoward007

    Benchmark Testing

    Does anyone have a good method or script they use for benchmarking new sql servers?
  4. dhoward007

    Remove Non Ascii Characters from a column in a table

    That might do the trick.. If you don't mind passing it along.. If that doesn't work, I will probably create some kind of update statement to look for certain characters and remove them.. Thanks for the help.
  5. dhoward007

    Remove Non Ascii Characters from a column in a table

    Is there a way to run an update in SQL using some function to remove any non ascii characters from the column? We are loading data from AS400 and somtimes there are extra characters and we need to remove them.
  6. dhoward007

    change response.redirect dynamically?

    I tried the fix above and I get a 404 error.. The page does exist but I cannot figure out why it will not work. If I hard code the page it works.. any clues? response.redirect "editoncall.asp"
  7. dhoward007

    change response.redirect dynamically?

    Is there a way to change the page response.redirect sends the user to? I have a combo box that has a list of values and depending on what the user selects, I am refreshing the page and running a db query to get the file to redirect the user to based on their selection. Below is the code to the...
  8. dhoward007

    Compare Integers

    Thanks Guys. I wasn't multiplying the minutes by 60 therefore I wasn't getting the results that I expected.. It works now..
  9. dhoward007

    Compare Integers

    Well.. Here is a section of the code that I am using.. First, I create one recordset for the comparison. 'Get the duration Hours from the srcboduration table for populating the durationHour combo box. drQryH = "select cbovalue, cboname from srcboduration where cboType = 'H'" SET...
  10. dhoward007

    Compare Integers

    I am building an asp application and cannot figure out how to compare two integers.. Is this possible using vbscript? Below is a brief example of what I am trying to do.. Any suggestions?? dim strIntOne dim strIntTwo strIntOne = CInt(rsValues("value")) strIntTwo =...
  11. dhoward007

    sp_resolve_logins

    I have setup log shipping on a primary and secondary server. I am testing the fail over and am having trouble with the sp_resolve_logins procedure. I can successfull bring up the standby server as the primary but when I use the resolve logins procedure i run into problems. Has anyone...
  12. dhoward007

    Storing Time in a database

    Thanks ClaireHsu I have decided to store my time as numeric in seconds. I can format it when I report. Thanks for your help. I believe this will make things much easier this way.
  13. dhoward007

    Storing Time in a database

    I guess my question is Should I use the data type date time or should I use the numeric data type to store the time.
  14. dhoward007

    Storing Time in a database

    I have an application that I need to track time spent on a specific task.. My question is, should I use date time to do this? Later I will need to run totals on the time spent on each task.
  15. dhoward007

    vbscript or asp solution

    That is awesome.. I know it works but can it be done using vbscript? Or do you have to use javascript?
  16. dhoward007

    vbscript or asp solution

    I am looking for a solution if possible using asp or vbscript to talk between browsers. If you have ever used yahoo mail and when you compose a message, you have an option to open another window and select the address you want to send the email to. when you select that user, that value passed...
  17. dhoward007

    VBScript or ASP

    I am looking for a solution if possible using asp or vbscript to talk between browsers. If you have ever used yahoo mail and when you compose a message, you have an option to open another window and select the address you want to send the email to. when you select that user, that value passed...
  18. dhoward007

    Moving SQL database from Drive C:/ to Drive D.

    You should be able to detach your databases, move them to the appropriate partition and then reattach.. I have never tried to detach and reattach the master or other system databases so you might want to read up on that..
  19. dhoward007

    SQL Constraints?

    Has anyone ever had to drop constraints on one schema, truncate data and then move data from an identicle schema and then recreated the constraints.. My question is, is there an easy way to do something like this?? I have tried it a few times and for some reason I get some primary key...
  20. dhoward007

    Indexed View

    WoW!!!!! tlbroadbent.. This was 100%faster.. It works great!!!! This query went from 30 seconds to not even 1 second.. That is amazing.. I will start rewriting some of my queries .. I have been looking for a quicker way to get results.. This seems to be it.. Thank you very much..

Part and Inventory Search

Back
Top