Viewing 15 posts - 1,906 through 1,920 (of 1,999 total)
i'd recommend using query analyser to look at your insert execution plans, then use a product like NETiq to find out what SQL is being run on your server. that...
July 22, 2004 at 11:10 am
is there a primary key on the table? if so is it clustered???
have you looked at the data load options in your dts package ??? are you using the fast...
July 22, 2004 at 11:05 am
well some idiot specified this system to the police force. and now we're left picking up the peices. - they've spent so much on the system (because some network techie...
July 22, 2004 at 10:14 am
with client network you can create an alias for TCP/IP, but only for a port number - you can't specify the IP it listens on....
both cards have different addresses.
July 22, 2004 at 2:30 am
unfortunatley it wasn't my choice to run from a NAS (they call it a SAN but it's not) - we inherited support of an existin server.
NAS is supported for...
July 22, 2004 at 2:27 am
just a thought - are you appending to the existing backups?
or is it a new file every day ?
July 21, 2004 at 5:14 am
see the micorosfoft page
http://support.microsoft.com/default.aspx?scid=kb;en-us;834124
this has all the details - you're having problems running xp_logininfo system stored procedure - this could be down to SQL permissions, but it ocurs in...
July 19, 2004 at 5:13 am
ok ,
first thing first, in Enterprise manager you can check in the taskpad view of any database what the actual size of the data is in the datafile (there...
July 19, 2004 at 4:54 am
excuse my ignorance, but why would hyperthreading affectthe tempDB, growth factor or Transaction log size??
sureley most of these relate to HD size and space constraints.
July 19, 2004 at 2:15 am
looks like it could be growth.
but i'd def look at your tempdb as well.
maybe this needs a bigger growth factor.
July 16, 2004 at 3:11 am
good point-
why don't you get the DTS to remove all of the other rows
July 15, 2004 at 2:23 am
quite right.
there are several options in DTS packages that avoid using Contraints, triggers and relationships.
you chould also consider adding the following
if @@rowcount=1
as your delete from ...where ...
will...
July 15, 2004 at 2:19 am
tried to CREATE a database in vb2005 express beta
you get the message "unable to connect to database - this feature is not supported"
if enterprise manager you can see the...
July 14, 2004 at 3:22 am
Viewing 15 posts - 1,906 through 1,920 (of 1,999 total)