Search results for query: *

what is the tpch website?

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...

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

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.

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.

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"

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...

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

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...

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 =...

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...

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.

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.

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.

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

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...

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...

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..

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...

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..