INF & IND errors

How do I update or delete a record with this floating point error in X
field? And, what the heck causes it?
Thanks!
Chris
Are you seeing 1.#inf values? That generally has something
to do with Microsoft's implementation of the IEEE standard
for floating point values - there are some values where the
representation of the value gets hosed out.
Are you trying to use column X in the where clause of your
delete or update statement?
-Sue
On Fri, 7 Oct 2005 10:43:54 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:

>How do I update or delete a record with this floating point error in X
>field? And, what the heck causes it?
>Thanks!
>Chris
>

INF & IND errors

How do I update or delete a record with this floating point error in X
field? And, what the heck causes it?
Thanks!
ChrisAre you seeing 1.#inf values? That generally has something
to do with Microsoft's implementation of the IEEE standard
for floating point values - there are some values where the
representation of the value gets hosed out.
Are you trying to use column X in the where clause of your
delete or update statement?
-Sue
On Fri, 7 Oct 2005 10:43:54 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:

>How do I update or delete a record with this floating point error in X
>field? And, what the heck causes it?
>Thanks!
>Chris
>

Indexed Views disabled in Database Engine Tuning Advisor

Hi,
When running the Database Engine Tuning Advisor on an SQL 2005 DataBase, the
two options with "indexed views" were disabled. What causes this SQL Server
isntance not to accept indexed views? I noticed that is't version was
9.0.3042 and not 9.0.3054 as mine: does this has anything to do with it?
thanks a lot and kind regards,
PieterHi Pieter,
Indexed views options are disabled on the GUI if you are using SQL Server
Standard Edition.
Hope this helps,
Ben Nevarez
"Pieter" wrote:
> Hi,
>
> When running the Database Engine Tuning Advisor on an SQL 2005 DataBase, the
> two options with "indexed views" were disabled. What causes this SQL Server
> isntance not to accept indexed views? I noticed that is't version was
> 9.0.3042 and not 9.0.3054 as mine: does this has anything to do with it?
>
> thanks a lot and kind regards,
>
> Pieter
>
>|||Ah, it's indeed a Standard Edition. Thanks! :-)
"Ben Nevarez" <bnevarez@.no.spam.please.sunamerica.com> wrote in message
news:46A1EEC7-F83D-44DC-80D6-43CED822F26C@.microsoft.com...
> Hi Pieter,
> Indexed views options are disabled on the GUI if you are using SQL Server
> Standard Edition.
> Hope this helps,
> Ben Nevarez
>
>
> "Pieter" wrote:
>> Hi,
>>
>> When running the Database Engine Tuning Advisor on an SQL 2005 DataBase,
>> the
>> two options with "indexed views" were disabled. What causes this SQL
>> Server
>> isntance not to accept indexed views? I noticed that is't version was
>> 9.0.3042 and not 9.0.3054 as mine: does this has anything to do with it?
>>
>> thanks a lot and kind regards,
>>
>> Pieter
>>