Viewing 15 posts - 3,346 through 3,360 (of 7,429 total)
Another way you could try is like so but not sure what the total cost may be compared to the way you listed.
SELECT MAX(IVal)
FROM
(
SELECT int1 AS IVal in table1
UNION ALL
SELECT...
February 18, 2003 at 1:24 pm
Consider the fact each CPU can process one thread at a pyhsical time division each and yes it can provide extra throughput.
As for connection. A connection can always be reused...
February 18, 2003 at 1:12 pm
Check your users language settings. These do have bering on dates during inserts.
February 18, 2003 at 1:06 pm
Known issue. There are two ways to handle.
1) Do a replace on ' with '' in the server side ASP code.
2) Wrap the insert logic into an SP then use...
February 18, 2003 at 4:42 am
One of the key things asked for was no decimal places. The only other option I see off hand that may perform a hair better or about the same (since...
February 18, 2003 at 4:40 am
Ok, can you walk us thru the flow of your SP on server 1 and how it gets to Server 2. Also, how is the connection to Server 2 defined...
February 18, 2003 at 4:18 am
It is being trapped becaue NULL is not a value and that warning is thrown when doing SUMS and other calculation related functions.
February 16, 2003 at 8:43 am
I thought some of those folks were pushing back since they purchased a product and has no bearing on the actual test other than as study material. So Transcenders excuse...
February 15, 2003 at 8:41 am
In the case above it would be the SUM of 0 so should not have an adverse effect. As it will be 1 or 0 and 0 adds nothing to...
February 15, 2003 at 8:38 am
The problem I always found with doing it using set was the fact it includes the variable name.
If you say do
SET WINDIR
you get
windir=C:\WINDOWS
I instead suggest use echo if you are...
February 14, 2003 at 12:46 pm
Basically this is the same algorithm used by all MS products that generate GUIDS. The only exact statement on the what if was this with VB.
February 14, 2003 at 12:24 pm
Those values represent the value of the coulms to be included in the output. By using | to generate a bitmask of them together the engine knows which ones to...
February 14, 2003 at 10:42 am
Can you show us your output and what you are comparing with. 20 is a space but what is the table structure and why are you looking at with DEBUG?
...
February 14, 2003 at 10:26 am
quote:
There is no way to do this for SQL except by backtracking the transaction logs with something like Log Explorer.Steve Jones
http://www.sqlservercentral.com/columnists/sjones
February 13, 2003 at 2:52 pm
First run
SET SHOWPLAN_TEXT ON
GO
Run the out of wack query and save output results.
GO
SET SHOWPLAN_TEXT OFF
GO
Then do the following basic maintainence next.
DBCC DBREINDEX all table indexes.
DBCC UPDATEUSAGE to insure sysindexes is...
February 13, 2003 at 2:40 pm
Viewing 15 posts - 3,346 through 3,360 (of 7,429 total)