Viewing 12 posts - 31 through 42 (of 42 total)
How are you connecting to the server? ADO?
Here is an ADO connection that sets the timeout.
Set cn = New ADODB.Connection
cn.ConnectionTimeout = 60
cn.CommandTimeout =...
November 4, 2002 at 11:20 am
It should be faster if other concurrent accesses to the table(s) were getting locked out. The trade off is concurrency versus data integrity.
By lowering the isolation level you are...
November 4, 2002 at 11:13 am
(Cont. Part 2 of 2)
1996-1998Olicon Imaging Products, Inc. Responsible for the design and implementation of MS-SQL database to track medical images for product under FDA approval. Designed and...
October 2, 2002 at 12:43 pm
Lee,
As a programmer and a DBA let me acknowledge that there are some programmers that do know their way around a database from both a design and administrative viewpoint. ...
September 12, 2002 at 12:52 pm
1) LOL SQL# (Shouldn't that be SQL#.Net++)
2) Ask any DBA worth their salt and they'll tell you that programmers don't understand databases. In particular, they don't understand the...
September 12, 2002 at 10:49 am
How to make sure that the objects created are owned by dbo:
1) What we do - You can specify the owner name as part of the create statement. (e.g. CREATE...
September 12, 2002 at 10:05 am
This link leads to a DMO based application that can be used to move indexes from various
filegroups.
Look under the Downloads section.
HTH
Steve Hendricks
August 21, 2002 at 10:10 am
Why would you want to express millisecond, a three digit quantity, in six digits? The system clock only has a granularity of approximately three milliseconds. The extra digits...
August 12, 2002 at 2:28 pm
If you need to move a few indexes, Enterprise Manager will let you change the location. Bring the table up in Design mode, show the "Table and Index Properties",...
July 29, 2002 at 10:12 am
I have found that the tool will sometimes return a false negative. After using the tool to find the missing patches, I have applied the patch and re-run the...
July 29, 2002 at 9:42 am
The preamble intrigued me because it mentioned new Query Analyzer features would be covered. Instead, we are covering SQL security modes (regardless of Query Analyzer) and how to resolve...
February 21, 2002 at 10:06 am
Andy,
Thank-you. This is useful information.
The .GetIndexedColumnDESC is in the Object Browser (Surprise! Surprise!). I must have been blurry-eyed when I was trying to find this.
It looks like the...
February 14, 2002 at 9:50 am
Viewing 12 posts - 31 through 42 (of 42 total)