Viewing 15 posts - 13,006 through 13,020 (of 13,457 total)
i looked in google groups and everyone who responded witht eh same error had instaleld the free copy, and then the production copy, which was technically a different version:
sounds...
July 17, 2006 at 3:09 pm
post the query; most likely we can help tune it ; most likely the WHERE clause can be tuned to use SARG-able arguments, which will then use the proper indexes...
July 17, 2006 at 2:14 pm
If you create an empty database, but make the space allocated 10 GIG, you'll need 10 GIG to restore that backup, even though the database might be empty, or much...
July 12, 2006 at 3:14 pm
nice, concise example to show someone why float is not a good solution for moeny. Thanks!
July 12, 2006 at 7:08 am
after you've created your new filegroup, this script might help: it writes the sql statements you could use to move some of your indexes; i've used it just for regular...
June 30, 2006 at 8:02 am
wouldn't the sp need to be recompiled after the table is truncated, as the previous executtion plan would probably be invalid? i would think the proc is slow because of...
June 29, 2006 at 6:06 am
here's a script i've used to generate the SQLs needed to change collation of a database for the existing items alzdba mentioned above;
I wouldn't try to modify this to fiddle...
June 29, 2006 at 5:49 am
you should change your design a bit;
your update trigger should populate a table of emails to be sent, and a job that runs every minute or five minutes or whatever...
June 14, 2006 at 1:10 pm
i believe the issue is related to the way oracle 10 handles BLOB and CLOB columns;
if we don't use the updated drivers that are part of the Ora10 client install,...
June 9, 2006 at 11:06 am
this might be of some help; what SP is on your i searched the KB and found something that references the dccc shrink command on a win2K SP2; fixed...
June 9, 2006 at 9:18 am
I like David McFarlands idea; just looping thru the text of the view/stored proc/whatever object, looking for specific strings is MUCH better than trying to write a dynamic string reader to...
June 9, 2006 at 9:04 am
and comma delimited list after the FROM in case the older style join structure is used: FROM TABLE1,TABLE2 , TABLE3
June 9, 2006 at 6:06 am
which SQL server are you trying to connect to from yuor host's web site?
part of your connection string: Data Source=hostsserver****,1433; is not really clear since it is...
June 8, 2006 at 7:12 am
If you've created any maintenance plans for those databases, this specific operation would be part of the scheduled job:
Data Base Maintenance>>Integrity Tab>>Checkboxes for Check Database Integrity & Include Indexes
you would...
June 8, 2006 at 6:55 am
Google and SQL Server Books On Line are your friends! use them first, and use the forums to clarify anything you didn't understand.
the first link in google for a search...
June 7, 2006 at 10:08 pm
Viewing 15 posts - 13,006 through 13,020 (of 13,457 total)