Viewing 15 posts - 3,676 through 3,690 (of 7,429 total)
Usually blocking is due to one holding resources the other needs and vice versa. Make sure your queries access the data in the same order.
For us to better understand if...
January 6, 2003 at 4:03 am
quote:
Does anyone have an idea how much of a performance hit this causes? Also, if the owner of the sp_ is...
January 5, 2003 at 6:11 pm
No you can only restore the complete device to another location then export the data via bcp or other method to import into the original.
January 5, 2003 at 6:09 pm
Due to the fact there are no forms it is generally smaller. As it depedns a lot on the objects in your access DB such as Queries, Forms, Reports and...
January 3, 2003 at 10:55 am
Actually running the cast to float came out with these results
0.20000000000000001
3.0
100.0
0.00165
Works fine in some cases but not all.
It is due to it's nature that this occurrs.
Approximate number data types...
January 3, 2003 at 10:19 am
quote:
Thanks , for valuable suggestionsI am doing Trnasaction Log backup once in an hour (appending to old TL BACKUPS) and the...
January 3, 2003 at 4:16 am
quote:
Why have a spare disk sitting idle when you could stick it in as a mirror and deduce the risk in the...
January 3, 2003 at 4:06 am
I have to agree there. However if you do use any encryption from the client a few easy things to rememeber is this.
1 Do not use easily recognized names for...
January 2, 2003 at 5:38 pm
Issues do exist but not with working with tables and such. The only real issues I have run into are these.
1) Opening EM and trying to connect to a SQL...
January 2, 2003 at 5:19 pm
If you are talking about what to put when responding here I don't think it matters much. I most times use the user name and not the real name unless...
January 2, 2003 at 5:06 pm
OPENDATASOURCE is available both 7/2k. It is a function within TSQL and can be utilized with ADO by connecting to the SQL Server. However with ADO to an Excel file...
January 2, 2003 at 2:47 pm
I too favor explicit instead of implicit. I ran into an issue with differences between SQL 7 and 2000 on this very issue and decided it is far easier to...
January 2, 2003 at 2:39 pm
I forget the actual number but it is very high as for SQL. The things that matter most are connection and the hardware of the server itself. Plus the method...
January 2, 2003 at 6:10 am
Ahh to have a server available. Anyway here is another option that may have some bennifits as well.
select
REPLACE(RTRIM(REPLACE(LEFT(cast(decv as varchar(20)),
LEN(cast(decv as varchar(20))) -
(PATINDEX('%[.,1-9]%', REVERSE(cast(decv as varchar(20)))) -...
January 2, 2003 at 5:48 am
Sorry I haven't seen TOAD. Can you provide a link so I can check it out?
January 2, 2003 at 5:30 am
Viewing 15 posts - 3,676 through 3,690 (of 7,429 total)