modeling age

I'm a newcomer to AS, but familiar with traditional SQL/relational stuff. I'm getting used to dimensional modeling techniques, and have come across a question. We have a situation where users can specify age in different units, for example if the age is 10 months, the the age is marked as 10, the age "class" is months. Or it may be 10 for age, and the "class" is years. The classes can range from minutes --> hours --> up to years. The age quantity is dependant on the value provided for the age class. For example, if they provide the "months" class, then the age must fall between 1 & 12.

I'm wondering what the best way to model this both in the dimensional relational database that will feed AS, and is there any AS tools (calculations/hierarchies, etc.) that would make this easier. And if so - can someone point me in the right direction.

I can think of two possible options.

1) store the data in one single format and then use calculations to display the different classes.

2) create a different measure for each class type.

I would not mix different units of data in the one measure. It means you cannot aggregate the data and will lead to lots of head aches down the track. Option 1) might loose a little bit of accuracy if you need to span time frames between years and seconds, option 2) would use more storage space, but you could keep the orginal fidelity of the data.

|||

Darren - thanks for the response. A follow up question....don't know much about measure groups (as you may see in my question) - but in our situation the age is not the measure, so sure not your suggestion will do. For instance our users aren't querying average age by City. They're querying # of events by age. Isn't age then a dimension (or part of one?). Then how do you do a measure group or measure on age?

I guess I'm a little lost when it comes to measure groups. Actually I'm a little lost when it comes to anything that ventures outside of the wizards in AS.

|||

If you want to filter and slice other measures by age, then you are right, you would model it as an attribute, not as a measure. I think this makes it even more important to normalize the ages. I am thinking that if one user enters "120 minutes" and another "2 hours", then you want both of these ages to come up as being equivalent.

It probably depends more on what type of analysis your users will be doing. Often in this type of situation you would set-up an age dimension with some useful breakdowns. You can then do your breakdowns at any granularity that makes sense and group things together into hierarchies.

eg. Your could even do something like the following

AgeId

Age Group1 Group2 1 0-30 Minutes 1 Day Upto 1 month 2 31-60 Minutes 1 Day Upto 1 month 3 1-2 Hours 1 Day Upto 1 month 4 3-6 Hours 1 Day Upto 1 month 5 7-12 Hours 1 Day Upto 1 month 6 13-24 Hours 1 Day Upto 1 month 7 1-2 Days 2-10 Days Upto 1 month 8 3-5 Days 2-10 Days Upto 1 month 9 5-10 Days 2-10 Days Upto 1 month 10 11-20 days 11-30 Days Upto 1 month 11 21-30 Days 11-30 Days Upto 1 month 12 31-60 Days 2-3 Months 2 months to 1 year 13 61-90 Days 2-3 Months 2 months to 1 year 14 4-6 Months 4-12 Months 2 months to 1 year 15 7-12 months 4-12 Months 2 months to 1 year 16 1-2 Years More than 1 year More than 1 year 17

3-5 Years More than 1 year More than 1 year

Then as you populated your fact table you would insert the appropriate AgeID into it.

modeling age

I'm a newcomer to AS, but familiar with traditional SQL/relational stuff. I'm getting used to dimensional modeling techniques, and have come across a question. We have a situation where users can specify age in different units, for example if the age is 10 months, the the age is marked as 10, the age "class" is months. Or it may be 10 for age, and the "class" is years. The classes can range from minutes --> hours --> up to years. The age quantity is dependant on the value provided for the age class. For example, if they provide the "months" class, then the age must fall between 1 & 12.

I'm wondering what the best way to model this both in the dimensional relational database that will feed AS, and is there any AS tools (calculations/hierarchies, etc.) that would make this easier. And if so - can someone point me in the right direction.

I can think of two possible options.

1) store the data in one single format and then use calculations to display the different classes.

2) create a different measure for each class type.

I would not mix different units of data in the one measure. It means you cannot aggregate the data and will lead to lots of head aches down the track. Option 1) might loose a little bit of accuracy if you need to span time frames between years and seconds, option 2) would use more storage space, but you could keep the orginal fidelity of the data.

|||

Darren - thanks for the response. A follow up question....don't know much about measure groups (as you may see in my question) - but in our situation the age is not the measure, so sure not your suggestion will do. For instance our users aren't querying average age by City. They're querying # of events by age. Isn't age then a dimension (or part of one?). Then how do you do a measure group or measure on age?

I guess I'm a little lost when it comes to measure groups. Actually I'm a little lost when it comes to anything that ventures outside of the wizards in AS.

|||

If you want to filter and slice other measures by age, then you are right, you would model it as an attribute, not as a measure. I think this makes it even more important to normalize the ages. I am thinking that if one user enters "120 minutes" and another "2 hours", then you want both of these ages to come up as being equivalent.

It probably depends more on what type of analysis your users will be doing. Often in this type of situation you would set-up an age dimension with some useful breakdowns. You can then do your breakdowns at any granularity that makes sense and group things together into hierarchies.

eg. Your could even do something like the following

AgeId

Age Group1 Group2 1 0-30 Minutes 1 Day Upto 1 month 2 31-60 Minutes 1 Day Upto 1 month 3 1-2 Hours 1 Day Upto 1 month 4 3-6 Hours 1 Day Upto 1 month 5 7-12 Hours 1 Day Upto 1 month 6 13-24 Hours 1 Day Upto 1 month 7 1-2 Days 2-10 Days Upto 1 month 8 3-5 Days 2-10 Days Upto 1 month 9 5-10 Days 2-10 Days Upto 1 month 10 11-20 days 11-30 Days Upto 1 month 11 21-30 Days 11-30 Days Upto 1 month 12 31-60 Days 2-3 Months 2 months to 1 year 13 61-90 Days 2-3 Months 2 months to 1 year 14 4-6 Months 4-12 Months 2 months to 1 year 15 7-12 months 4-12 Months 2 months to 1 year 16 1-2 Years More than 1 year More than 1 year 17

3-5 Years More than 1 year More than 1 year

Then as you populated your fact table you would insert the appropriate AgeID into it.

MNS cluster / SQL

Is it possible to have a stretched cluster (MNS) across 2 datacenters running
SQL?
For example, a SAN in each datacenter with replication, and 1 node located
in each site.
We are trying to design our new datacenter infrastructure, and our IT
Director believes there is a way to have 1 node in each site, each accessing
a local SAN which replicates it's content and using a MNS cluster.
I have searched around but cannot find any info. He is also suggesting we
use Win2k8, but I can't find any info on this sort of setup. We currently
have a mix of SQL 2k5/2000.
It is possible to have a "stretch" cluster, but not using Majority Node Set.
Since SQL needs a central data repository, using MNS for the cluster qourum
creates no benefit. There are not any native tools to implement a
geocluster (as it is properly called), but third-party vendors offer some
bolt-on solutions. If we are lucky, Linchi will chime in with some answers
here. He is the best resource I know for this information. NSI's
Doubletake has a geocluster offering as does EMC's SRDF (part of their
storage systems suite).
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"daesimps" <daesimps@.discussions.microsoft.com> wrote in message
news:0043808E-D696-4A59-A557-15F648FE5D14@.microsoft.com...
> Is it possible to have a stretched cluster (MNS) across 2 datacenters
> running
> SQL?
> For example, a SAN in each datacenter with replication, and 1 node located
> in each site.
> We are trying to design our new datacenter infrastructure, and our IT
> Director believes there is a way to have 1 node in each site, each
> accessing
> a local SAN which replicates it's content and using a MNS cluster.
> I have searched around but cannot find any info. He is also suggesting we
> use Win2k8, but I can't find any info on this sort of setup. We currently
> have a mix of SQL 2k5/2000.
|||Sorry for the use of the term "stretched". I have been trying to correct the
director every time he uses that term, but it would seem it has rubbed off on
me!! :-)
Your reply seems to be along the same lines as my response to him, but you
know management. They always seem to know better than the Technical staff
they employ!
Thanks
Daesimps
"Geoff N. Hiten" wrote:

> It is possible to have a "stretch" cluster, but not using Majority Node Set.
> Since SQL needs a central data repository, using MNS for the cluster qourum
> creates no benefit. There are not any native tools to implement a
> geocluster (as it is properly called), but third-party vendors offer some
> bolt-on solutions. If we are lucky, Linchi will chime in with some answers
> here. He is the best resource I know for this information. NSI's
> Doubletake has a geocluster offering as does EMC's SRDF (part of their
> storage systems suite).
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
>
> "daesimps" <daesimps@.discussions.microsoft.com> wrote in message
> news:0043808E-D696-4A59-A557-15F648FE5D14@.microsoft.com...
>
|||Well, if you are planning on a cluster that spans two geographically
separate data centers, your director is correct in that it is a stretched
cluster. 'Stretch clusters' or geo clusters are almost always vendor
specific. EMC has a product called SRDF/CE, standing for Cluster Enabler.
Basically, what it does is to have one or more nodes in each of the two data
centers, data is replicated synchronously at disk array level via SRDF, and
SRDF/CE creates an illusion to MSCS in that the storage appears to MSCS as a
single shared drive(s). So as far as MSCS is concerned, it's a regular
Microsoft failover cluster. For many companies, the problem is often the
requirement of having the VLAN spanning two different data centers and the
network folks often don't like that idea. Fortunately, in Win2K8 the same
VLAN requirement will be dropped.
That said, I'm not sure such a stretched cluster is the best solution for
whatever DR requirements you try to meet. It's complex and over too many
layers. If you don't have SRDF already, it requires putting in place an
expensive infrastructure. Even if you already have SRDF, SRDF/CE is separate
license. Often, you can meet your DR requirements with some other
approach(es).
Linchi
"daesimps" <daesimps@.discussions.microsoft.com> wrote in message
news:FC36D7EA-9036-48A5-8086-1782CFC4394E@.microsoft.com...[vbcol=seagreen]
> Sorry for the use of the term "stretched". I have been trying to correct
> the
> director every time he uses that term, but it would seem it has rubbed off
> on
> me!! :-)
> Your reply seems to be along the same lines as my response to him, but you
> know management. They always seem to know better than the Technical staff
> they employ!
> Thanks
> Daesimps
> "Geoff N. Hiten" wrote:
|||See. I told you he was the expert.
Thanks, Linchi.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:%234nsIQTOIHA.4272@.TK2MSFTNGP06.phx.gbl...
> Well, if you are planning on a cluster that spans two geographically
> separate data centers, your director is correct in that it is a stretched
> cluster. 'Stretch clusters' or geo clusters are almost always vendor
> specific. EMC has a product called SRDF/CE, standing for Cluster Enabler.
> Basically, what it does is to have one or more nodes in each of the two
> data centers, data is replicated synchronously at disk array level via
> SRDF, and SRDF/CE creates an illusion to MSCS in that the storage appears
> to MSCS as a single shared drive(s). So as far as MSCS is concerned, it's
> a regular Microsoft failover cluster. For many companies, the problem is
> often the requirement of having the VLAN spanning two different data
> centers and the network folks often don't like that idea. Fortunately, in
> Win2K8 the same VLAN requirement will be dropped.
> That said, I'm not sure such a stretched cluster is the best solution for
> whatever DR requirements you try to meet. It's complex and over too many
> layers. If you don't have SRDF already, it requires putting in place an
> expensive infrastructure. Even if you already have SRDF, SRDF/CE is
> separate license. Often, you can meet your DR requirements with some other
> approach(es).
> Linchi
> "daesimps" <daesimps@.discussions.microsoft.com> wrote in message
> news:FC36D7EA-9036-48A5-8086-1782CFC4394E@.microsoft.com...
>
|||Thanks for the info. We use HP Eva 6000 Storage equipment, so we'll have to
investigate if there is an equivalent to the EMC cluster enabler.
"Geoff N. Hiten" wrote:

> See. I told you he was the expert.
> Thanks, Linchi.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:%234nsIQTOIHA.4272@.TK2MSFTNGP06.phx.gbl...
>
|||On Dec 8, 7:51 am, daesimps <daesi...@.discussions.microsoft.com>
wrote:
> Thanks for the info. We use HP Eva 6000 Storage equipment, so we'll have to
> investigate if there is an equivalent to the EMC cluster enabler.
>
> "Geoff N. Hiten" wrote:
>
>
>
>
>
>
>
>
> - Show quoted text -
What is your RTO and RPO? There are other options that are SQL
specific, including database mirroring, transactional replication, etc.
sql

Missing Record - Phantom Record

Hi All,

Have come across something weird and am after some help.

Say i run this query where rec_id is a column of table arlhrl,

select * from arlhrl where rec_id >= 14260

This returns to me 2 records with rec_id's of 14260 and 14261

Then I run this query

select * from arlhrl where rec_id >= 14263

This returns 7 records with rec_ids of 14263 up.

How come the first query doesn't return the records returned by the
2nd query also?

If I select for 14262 no records are returned. It is like this is a
phantom record or has an end of file character in it.

I tried re-creating the indexes but to no avail. If anyone has any
ideas about what could be causing it or how to fix it it would be much
appreciated.

Thanks in advance,

AndrewAndrew wrote:
> Hi All,
> Have come across something weird and am after some help.
> Say i run this query where rec_id is a column of table arlhrl,
> select * from arlhrl where rec_id >= 14260
> This returns to me 2 records with rec_id's of 14260 and 14261
> Then I run this query
> select * from arlhrl where rec_id >= 14263
> This returns 7 records with rec_ids of 14263 up.
> How come the first query doesn't return the records returned by the
> 2nd query also?
> If I select for 14262 no records are returned. It is like this is a
> phantom record or has an end of file character in it.
> I tried re-creating the indexes but to no avail. If anyone has any
> ideas about what could be causing it or how to fix it it would be much
> appreciated.
> Thanks in advance,
> Andrew

Hi,

First, stupid question - is the field 'rec_id' of integer type?
Why i am asking is because i had a similar example myself when i started with my new job - i was
quering an id field and got weird results as you do. Then i found that some 'smart ass' made this
comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)

Second, what i'd do when i get into an unexplainable glitch:

SELECT * INTO <new table> FROM <your table
And try to query the records from the new table without setting any indexes - just as is - as you
know SELECT INTO just copies raw data without any underlying stuff.
See what you'll get.
From my experience there are a of of people who are allowed to mess with SQL databases but don't
have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just
hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never
imagine what another person could do - believe me, i just got quite a few awsome examples within the
last month since i got this job :)

Let me know how it works!

Andrey|||Andrey <leyandrew@.yahoo.com> wrote in message news:<7wt3d.78769$D%.11878@.attbi_s51>...
> Andrew wrote:
> > Hi All,
> > Have come across something weird and am after some help.
> > Say i run this query where rec_id is a column of table arlhrl,
> > select * from arlhrl where rec_id >= 14260
> > This returns to me 2 records with rec_id's of 14260 and 14261
> > Then I run this query
> > select * from arlhrl where rec_id >= 14263
> > This returns 7 records with rec_ids of 14263 up.
> > How come the first query doesn't return the records returned by the
> > 2nd query also?
> > If I select for 14262 no records are returned. It is like this is a
> > phantom record or has an end of file character in it.
> > I tried re-creating the indexes but to no avail. If anyone has any
> > ideas about what could be causing it or how to fix it it would be much
> > appreciated.
> > Thanks in advance,
> > Andrew
>
> Hi,
> First, stupid question - is the field 'rec_id' of integer type?
> Why i am asking is because i had a similar example myself when i started with my new job - i was
> quering an id field and got weird results as you do. Then i found that some 'smart ass' made this
> comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)
>
> Second, what i'd do when i get into an unexplainable glitch:
> SELECT * INTO <new table> FROM <your table>
> And try to query the records from the new table without setting any indexes - just as is - as you
> know SELECT INTO just copies raw data without any underlying stuff.
> See what you'll get.
> From my experience there are a of of people who are allowed to mess with SQL databases but don't
> have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just
> hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never
> imagine what another person could do - believe me, i just got quite a few awsome examples within the
> last month since i got this job :)
> Let me know how it works!
> Andrey

Hi Andrey,

Thanks for your reply. I tried as you mentioned, inserting into new
table etc but to no avail. I did figure out what the problem was
though.

This particular table had been upsized from a foxpro table. One of the
columns in the foxpro table had a maximum value of numeric 9999.
Somehow, someone had tried to insert a value large than this so foxpro
put in ****. On the upsize, and I can only assume here, sql must have
thought 'hang on, you must mean infinity here' and put a bit-wise
pattern (1.#INF) for infinity into this particular column for the
record.

This only became evident when using Enterprise Manager and returning
all rows on the given table, it did display the record with the value
1.#INF in the column for the 'missing' record. As to why it displayed
in EM and not Query Analyser is anyone's guess, but surely the queries
that led me to this initial discovery shouldn't have behaved like
this!!??

posting

http://groups.google.com/groups?q=%...le .com&rnum=1

gives some ideas.

Thanks anyway,

Andrew|||Andrew wrote:

> Andrey <leyandrew@.yahoo.com> wrote in message news:<7wt3d.78769$D%.11878@.attbi_s51>...
>>Andrew wrote:
>>
>>>Hi All,
>>>
>>>Have come across something weird and am after some help.
>>>
>>>Say i run this query where rec_id is a column of table arlhrl,
>>>
>>>select * from arlhrl where rec_id >= 14260
>>>
>>>This returns to me 2 records with rec_id's of 14260 and 14261
>>>
>>>Then I run this query
>>>
>>>select * from arlhrl where rec_id >= 14263
>>>
>>>This returns 7 records with rec_ids of 14263 up.
>>>
>>>How come the first query doesn't return the records returned by the
>>>2nd query also?
>>>
>>>If I select for 14262 no records are returned. It is like this is a
>>>phantom record or has an end of file character in it.
>>>
>>>I tried re-creating the indexes but to no avail. If anyone has any
>>>ideas about what could be causing it or how to fix it it would be much
>>>appreciated.
>>>
>>>Thanks in advance,
>>>
>>>Andrew
>>
>>
>>Hi,
>>
>>First, stupid question - is the field 'rec_id' of integer type?
>>Why i am asking is because i had a similar example myself when i started with my new job - i was
>>quering an id field and got weird results as you do. Then i found that some 'smart ass' made this
>>comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)
>>
>>
>>Second, what i'd do when i get into an unexplainable glitch:
>>
>>SELECT * INTO <new table> FROM <your table>
>>
>>And try to query the records from the new table without setting any indexes - just as is - as you
>>know SELECT INTO just copies raw data without any underlying stuff.
>>See what you'll get.
>> From my experience there are a of of people who are allowed to mess with SQL databases but don't
>>have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just
>>hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never
>>imagine what another person could do - believe me, i just got quite a few awsome examples within the
>>last month since i got this job :)
>>
>>Let me know how it works!
>>
>>Andrey
>
> Hi Andrey,
> Thanks for your reply. I tried as you mentioned, inserting into new
> table etc but to no avail. I did figure out what the problem was
> though.
> This particular table had been upsized from a foxpro table. One of the
> columns in the foxpro table had a maximum value of numeric 9999.
> Somehow, someone had tried to insert a value large than this so foxpro
> put in ****. On the upsize, and I can only assume here, sql must have
> thought 'hang on, you must mean infinity here' and put a bit-wise
> pattern (1.#INF) for infinity into this particular column for the
> record.
> This only became evident when using Enterprise Manager and returning
> all rows on the given table, it did display the record with the value
> 1.#INF in the column for the 'missing' record. As to why it displayed
> in EM and not Query Analyser is anyone's guess, but surely the queries
> that led me to this initial discovery shouldn't have behaved like
> this!!??
> posting
> http://groups.google.com/groups?q=%...le .com&rnum=1
> gives some ideas.
> Thanks anyway,
> Andrew

Well, EM and QA might show you diferent results because they are using diferent methods of 'talking'
to sql server.
QA is using isql.com, precisely it's isqlw.com version, which is an old DB lib based way of connection.
EM, i guess, is using ODBC or OLEDB connection.

I also had a headache not long time ago, when i used sql console tools to make Python work with sql
server. I had a table with varcha fields which had around couple thousand characters of text each.

When i used isql.com to retreive those text records, text returned truncated, around 300 to 600
characters left.. SO i started using osql.com instead, and no headache.

So resume is - every time you're in doubt, use both EM and QA

PS. BTW, I didn't know sql server can store 'infinity' values. Thanks for the info!

WYGL,
Andrey|||Andrew wrote:

> Andrey <leyandrew@.yahoo.com> wrote in message news:<7wt3d.78769$D%.11878@.attbi_s51>...
>>Andrew wrote:
>>
>>>Hi All,
>>>
>>>Have come across something weird and am after some help.
>>>
>>>Say i run this query where rec_id is a column of table arlhrl,
>>>
>>>select * from arlhrl where rec_id >= 14260
>>>
>>>This returns to me 2 records with rec_id's of 14260 and 14261
>>>
>>>Then I run this query
>>>
>>>select * from arlhrl where rec_id >= 14263
>>>
>>>This returns 7 records with rec_ids of 14263 up.
>>>
>>>How come the first query doesn't return the records returned by the
>>>2nd query also?
>>>
>>>If I select for 14262 no records are returned. It is like this is a
>>>phantom record or has an end of file character in it.
>>>
>>>I tried re-creating the indexes but to no avail. If anyone has any
>>>ideas about what could be causing it or how to fix it it would be much
>>>appreciated.
>>>
>>>Thanks in advance,
>>>
>>>Andrew
>>
>>
>>Hi,
>>
>>First, stupid question - is the field 'rec_id' of integer type?
>>Why i am asking is because i had a similar example myself when i started with my new job - i was
>>quering an id field and got weird results as you do. Then i found that some 'smart ass' made this
>>comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)
>>
>>
>>Second, what i'd do when i get into an unexplainable glitch:
>>
>>SELECT * INTO <new table> FROM <your table>
>>
>>And try to query the records from the new table without setting any indexes - just as is - as you
>>know SELECT INTO just copies raw data without any underlying stuff.
>>See what you'll get.
>> From my experience there are a of of people who are allowed to mess with SQL databases but don't
>>have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just
>>hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never
>>imagine what another person could do - believe me, i just got quite a few awsome examples within the
>>last month since i got this job :)
>>
>>Let me know how it works!
>>
>>Andrey
>
> Hi Andrey,
> Thanks for your reply. I tried as you mentioned, inserting into new
> table etc but to no avail. I did figure out what the problem was
> though.
> This particular table had been upsized from a foxpro table. One of the
> columns in the foxpro table had a maximum value of numeric 9999.
> Somehow, someone had tried to insert a value large than this so foxpro
> put in ****. On the upsize, and I can only assume here, sql must have
> thought 'hang on, you must mean infinity here' and put a bit-wise
> pattern (1.#INF) for infinity into this particular column for the
> record.
> This only became evident when using Enterprise Manager and returning
> all rows on the given table, it did display the record with the value
> 1.#INF in the column for the 'missing' record. As to why it displayed
> in EM and not Query Analyser is anyone's guess, but surely the queries
> that led me to this initial discovery shouldn't have behaved like
> this!!??
> posting
> http://groups.google.com/groups?q=%...le .com&rnum=1
> gives some ideas.
> Thanks anyway,
> Andrew

And how did you get rid of that infinity value in the in field?|||I got rid of the infinity value using EM open table then typed in the
value I wanted.

Andrey <leyandrew@.yahoo.com> wrote in message news:<pir4d.28770$wV.19066@.attbi_s54>...
> Andrew wrote:
> > Andrey <leyandrew@.yahoo.com> wrote in message news:<7wt3d.78769$D%.11878@.attbi_s51>...
> >>Andrew wrote:
> >>
> >>>Hi All,
> >>>
> >>>Have come across something weird and am after some help.
> >>>
> >>>Say i run this query where rec_id is a column of table arlhrl,
> >>>
> >>>select * from arlhrl where rec_id >= 14260
> >>>
> >>>This returns to me 2 records with rec_id's of 14260 and 14261
> >>>
> >>>Then I run this query
> >>>
> >>>select * from arlhrl where rec_id >= 14263
> >>>
> >>>This returns 7 records with rec_ids of 14263 up.
> >>>
> >>>How come the first query doesn't return the records returned by the
> >>>2nd query also?
> >>>
> >>>If I select for 14262 no records are returned. It is like this is a
> >>>phantom record or has an end of file character in it.
> >>>
> >>>I tried re-creating the indexes but to no avail. If anyone has any
> >>>ideas about what could be causing it or how to fix it it would be much
> >>>appreciated.
> >>>
> >>>Thanks in advance,
> >>>
> >>>Andrew
> >>
> >>
> >>Hi,
> >>
> >>First, stupid question - is the field 'rec_id' of integer type?
> >>Why i am asking is because i had a similar example myself when i started with my new job - i was
> >>quering an id field and got weird results as you do. Then i found that some 'smart ass' made this
> >>comlumn a varchar for no reason - just because she was doing like that in Access all the time before :)
> >>
> >>
> >>Second, what i'd do when i get into an unexplainable glitch:
> >>
> >>SELECT * INTO <new table> FROM <your table>
> >>
> >>And try to query the records from the new table without setting any indexes - just as is - as you
> >>know SELECT INTO just copies raw data without any underlying stuff.
> >>See what you'll get.
> >> From my experience there are a of of people who are allowed to mess with SQL databases but don't
> >>have a clue what they are doing, and when you start using their 'smart ideas' sometimes it's just
> >>hard to follow their logic :) So maybe some setting were set a wrong way somewhere, you can never
> >>imagine what another person could do - believe me, i just got quite a few awsome examples within the
> >>last month since i got this job :)
> >>
> >>Let me know how it works!
> >>
> >>Andrey
> > Hi Andrey,
> > Thanks for your reply. I tried as you mentioned, inserting into new
> > table etc but to no avail. I did figure out what the problem was
> > though.
> > This particular table had been upsized from a foxpro table. One of the
> > columns in the foxpro table had a maximum value of numeric 9999.
> > Somehow, someone had tried to insert a value large than this so foxpro
> > put in ****. On the upsize, and I can only assume here, sql must have
> > thought 'hang on, you must mean infinity here' and put a bit-wise
> > pattern (1.#INF) for infinity into this particular column for the
> > record.
> > This only became evident when using Enterprise Manager and returning
> > all rows on the given table, it did display the record with the value
> > 1.#INF in the column for the 'missing' record. As to why it displayed
> > in EM and not Query Analyser is anyone's guess, but surely the queries
> > that led me to this initial discovery shouldn't have behaved like
> > this!!??
> > posting
> > http://groups.google.com/groups?q=%...le .com&rnum=1
> > gives some ideas.
> > Thanks anyway,
> > Andrew
>
> And how did you get rid of that infinity value in the in field?

Missing New Data Driven Subscriptions

Hello, I just migrated my reporting services to 2005 from 2000. My reports
have come across fine but I don't see the schedules that were set up for them.
Also, when I try to create a 'New Data-driven subscription' I don't see this
option; I used this feature in 2000. Is there some setting I need to change
somewhere?
ThanksOn Oct 4, 6:59 pm, Don <D...@.discussions.microsoft.com> wrote:
> Hello, I just migrated my reporting services to 2005 from 2000. My reports
> have come across fine but I don't see the schedules that were set up for them.
> Also, when I try to create a 'New Data-driven subscription' I don't see this
> option; I used this feature in 2000. Is there some setting I need to change
> somewhere?
> Thanks
If you do not have the SQL Server 2005 Enterprise Edition, this will
be the reason that they are not available (reference:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||So it was a feature in the regular version of 2000 but limited to Enterprise
in 2005
"EMartinez" wrote:
> On Oct 4, 6:59 pm, Don <D...@.discussions.microsoft.com> wrote:
> > Hello, I just migrated my reporting services to 2005 from 2000. My reports
> > have come across fine but I don't see the schedules that were set up for them.
> >
> > Also, when I try to create a 'New Data-driven subscription' I don't see this
> > option; I used this feature in 2000. Is there some setting I need to change
> > somewhere?
> >
> > Thanks
>
> If you do not have the SQL Server 2005 Enterprise Edition, this will
> be the reason that they are not available (reference:
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> ). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Missing Elements in Report Manager

Has anyone run across this before? I'm missing the Contents and Properties tab along with the button bar containing the "New Folder", "New Data Source", "Upload File" and "Show Details" buttons in the Report Manager. Also, which I think may be related, when I attempt to deploy a report I get the error: "A connection could not be made to the report server http://MyServer/Reports.

I can connect to the SQL Server without problem, and I can browse to the URL containing report manager

Interestingly, I had access to all of this a couple of weeks ago and then all of this suddenly happened. All the other developers have no problems and I am a member of the group which has access.

Any ideas?

Thanks in advance!

JohnMIt sounds like the permission are not set correctly. Perhaps you user account has been specified with more restrictive permissions?|||

Hi John,

Have you managed to resolve the issue? I have the exact same problem! :(

Kind Regards,

Casey.

|||

Has anyone figured this out? I have run into this exact issue and can not figure it out. All rights appear correct.

If there is a fix, can you please email me at mradomski@.lpsintegration.com

Missing Elements in Report Manager

Has anyone run across this before? I'm missing the Contents and Properties tab along with the button bar containing the "New Folder", "New Data Source", "Upload File" and "Show Details" buttons in the Report Manager. Also, which I think may be related, when I attempt to deploy a report I get the error: "A connection could not be made to the report server http://MyServer/Reports.

I can connect to the SQL Server without problem, and I can browse to the URL containing report manager

Interestingly, I had access to all of this a couple of weeks ago and then all of this suddenly happened. All the other developers have no problems and I am a member of the group which has access.

Any ideas?

Thanks in advance!

JohnMIt sounds like the permission are not set correctly. Perhaps you user account has been specified with more restrictive permissions?|||

Hi John,

Have you managed to resolve the issue? I have the exact same problem! :(

Kind Regards,

Casey.

|||

Has anyone figured this out? I have run into this exact issue and can not figure it out. All rights appear correct.

If there is a fix, can you please email me at mradomski@.lpsintegration.com

Missing Elements in Report Manager

Has anyone run across this before? I'm missing the Contents and Properties tab along with the button bar containing the "New Folder", "New Data Source", "Upload File" and "Show Details" buttons in the Report Manager. Also, which I think may be related, when I attempt to deploy a report I get the error: "A connection could not be made to the report server http://MyServer/Reports.

I can connect to the SQL Server without problem, and I can browse to the URL containing report manager

Interestingly, I had access to all of this a couple of weeks ago and then all of this suddenly happened. All the other developers have no problems and I am a member of the group which has access.

Any ideas?

Thanks in advance!

JohnMIt sounds like the permission are not set correctly. Perhaps you user account has been specified with more restrictive permissions?|||

Hi John,

Have you managed to resolve the issue? I have the exact same problem! :(

Kind Regards,

Casey.

|||

Has anyone figured this out? I have run into this exact issue and can not figure it out. All rights appear correct.

If there is a fix, can you please email me at mradomski@.lpsintegration.com