Viewing 15 posts - 1,831 through 1,845 (of 7,429 total)
Depedns on how you want done. You could use the META TAG to force a refresh to a new page (this is a redirect client side). Or if they are...
June 5, 2004 at 9:22 am
Just keep in mind if you step on a SPID that is making changes then all the work it is doing is going to attempt to roll back. Also be...
June 5, 2004 at 9:19 am
As long as the tables are all built on the Oracle server and you have a compatible Oracle Client version installed (with the ole Oracle drivers) you can use DTS...
June 3, 2004 at 6:39 pm
Even simpler considering datetime values are stored as two part intergers.
Datetime is two 4 byte integers (equal to two int datatypes together) and smalledatetime is two 2 byte intergers (equalk...
June 3, 2004 at 11:40 am
Joins occurr before the where condition.
And when multiple joins exist the occurr top to bottom, inside to outside.
So say you have (IJ = Inner Join)
SELECT
...
FROM
tA
IJ
tB
IJ
tC
ON
tC.Col = tB.Col
ON
tB.Col = tA.Col
IJ
tD
ON
tD.Col =...
June 3, 2004 at 7:24 am
You might need to run profiler on the server itself while you test from the place the issue is occurring so you can see what SQL sees happening.
June 3, 2004 at 7:10 am
Not that I have seen. I however believe you should use the smallest datatype that meets your needs and uses the least amount of size when stored. Also consider the...
June 3, 2004 at 7:04 am
Other than sometimes needing to rebuild the indexes and updateing the stats I have had not particualr issue. However I have heard complaints of performance differences of 7 databases move...
June 3, 2004 at 6:57 am
From BOL "CREATE FUNCTION" article arguments section
Is the parameter data type. All scalar data types, including bigint and sql_variant, can be used as a parameter for user-defined functions. The timestamp...
June 3, 2004 at 6:20 am
Just and additional comment.
The
status > 0
is added to cover items like dtproperties which is a system table but marked as a user table. All system objects have a bitmask...
June 3, 2004 at 6:18 am
Or optionally you can create input fields with a type of hidden for the same data so the user cannot touch them and they submit fine.
June 3, 2004 at 6:09 am
Even thou SQl can handle a lot of connections you have to consider if 10000 connections hit SQL at the same time it will take roughly .3 GB of Memory...
June 2, 2004 at 8:24 am
First off which did you run first. If you ran the one with the variables then the other you have to consider the fact cached data was involved (which to...
June 2, 2004 at 7:57 am
Are you saying that table A contains the data as built for the report on the fly and is deleted between runs? If so then you potentially could have multiple...
June 2, 2004 at 7:15 am
If that meets you needs then yes, just schedule and be very happy. Just remember to keep in mind the balance between how often it would actualy run on average...
June 2, 2004 at 5:59 am
Viewing 15 posts - 1,831 through 1,845 (of 7,429 total)