Viewing 15 posts - 4,501 through 4,515 (of 7,429 total)
Got to love documentation. DBTYPE_DECIMAL is an ADO/OLE data type and not really a VBScript thing. Go to http://msdn.microsoft.com and search for it for help.
Another great problem with VBScript is...
November 4, 2002 at 4:48 am
I am not 100% on this but I believe it is correct and you should be able to validate thur setting up a test copy on a small machine.
With...
November 4, 2002 at 4:31 am
Float goes out far enough that rounding will never be an issue as the rounding is only to the secound decimal place when you define a cast of decimal with...
November 4, 2002 at 4:14 am
Also, to save some round trips to the SQL server you may want to add using the ADODB.Command object so you can specify Stored Procedure with not return.
' Our SQL...
November 4, 2002 at 4:02 am
As for SELECT INTO causing locks that can become an issue. This relates to locks on the tempdb while trying to create the temp table, which were a problem in...
November 4, 2002 at 3:53 am
It would never be actual only average and is relative to other threads on the server running. If was only thread it would one thing, but when other threads are...
November 2, 2002 at 9:27 pm
In current activity in EM or sp_who in QA is tempdb showing a log backup taking place? I have a similar occurrance with slow downs and seemed to be focused...
November 2, 2002 at 9:11 pm
SQL LiteSpeed does, check out at http://www.sqllitespeed.com/slsdefault.asp
November 2, 2002 at 9:01 pm
What datatype is the field already? I am wondering if the current type is overriding the data somehow. Float I have heard of doing this because they are not precise.
...
November 2, 2002 at 9:53 am
A couple of things for the NOT IN you are using Pernum, this has been found in the past that the value will be that of the outer query when...
November 2, 2002 at 9:48 am
DOn't believe that is it, that should be an informational message, look for warning or error type message.
November 2, 2002 at 9:36 am
THe last batch refers to the last time a query was SQL batch was pushed thru that connection. Does not mean it has been running that long. If the state...
November 2, 2002 at 9:13 am
Interesting, I will have to look into this is one of our test environments if I can get time.
November 2, 2002 at 9:05 am
Profiler with SQL stmt begin and, exceptions will be you best approximation.
November 1, 2002 at 4:27 pm
Do a search on SQLUP and SQL-UP in the search of this site. I have not used it, but have seen threads in the past discuss it.
November 1, 2002 at 4:25 pm
Viewing 15 posts - 4,501 through 4,515 (of 7,429 total)