Showing posts with label regular. Show all posts
Showing posts with label regular. Show all posts

Sunday, March 25, 2012

Dimension processing taking too long

A regular dimension with some hierarchies is defined.

StorageMode:Molap

ProcessingGroup:ByAttribute

ProcessingMode:Regular

then on processing this dimension individually, why is a "select distinct" from the relational table done for each attribute of the dimension separately and finally a select distinct <all attribs> is done in one query.

What is the purpose of this ? this slows down processing for a large dimension table.

This is not done for rolap dimensions though.

Is there a way to speed up processing for Molap dimensions.

Also what is the significance of the ProcessingGroup property for a dimension?

Regards

mat

Processing by table seems to process all dimensions from that table at the AS server while by attribute gets each unique set of attributes from the database and then indexes them etc. According to a post I've just read there may be an issue with processing by table.|||

Try modifying EnableTableGrouping server property.

See description in http://msdn2.microsoft.com/en-us/library/ms174469.aspx

EnableTableGrouping

A Boolean property that specifies whether table grouping is enabled. If True, when processing dimensions, entire dimension tables are queried at once, as opposed to separate queries for each attribute.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Dimension processing taking too long

A regular dimension with some hierarchies is defined.

StorageMode:Molap

ProcessingGroup:ByAttribute

ProcessingMode:Regular

then on processing this dimension individually, why is a "select distinct" from the relational table done for each attribute of the dimension separately and finally a select distinct <all attribs> is done in one query.

What is the purpose of this ? this slows down processing for a large dimension table.

This is not done for rolap dimensions though.

Is there a way to speed up processing for Molap dimensions.

Also what is the significance of the ProcessingGroup property for a dimension?

Regards

mat

Processing by table seems to process all dimensions from that table at the AS server while by attribute gets each unique set of attributes from the database and then indexes them etc. According to a post I've just read there may be an issue with processing by table.|||

Try modifying EnableTableGrouping server property.

See description in http://msdn2.microsoft.com/en-us/library/ms174469.aspx

EnableTableGrouping

A Boolean property that specifies whether table grouping is enabled. If True, when processing dimensions, entire dimension tables are queried at once, as opposed to separate queries for each attribute.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

sql

Sunday, March 11, 2012

Differential Backup disproportionately large

Hello,
Just recently I noticed that on one of our databases, the diff backups
are HUGE compared to the full backups.
For example, the regular full backup is only 80 MB, however the diff
backups are 800 MB to 1.2 GB in size. The activity on this database is
low. Our other databases are not exhibiting this anomaly, whereas they
have much higher activiity.
Is there any logical explanation for this? How I can see what's going
on with the diff backups?
Thanks muchAre you sure you don't have several backups on the same file? Use RESTORE HEADERONLY.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<tootsuite@.gmail.com> wrote in message news:1161877716.372685.197900@.h48g2000cwc.googlegroups.com...
> Hello,
> Just recently I noticed that on one of our databases, the diff backups
> are HUGE compared to the full backups.
> For example, the regular full backup is only 80 MB, however the diff
> backups are 800 MB to 1.2 GB in size. The activity on this database is
> low. Our other databases are not exhibiting this anomaly, whereas they
> have much higher activiity.
> Is there any logical explanation for this? How I can see what's going
> on with the diff backups?
> Thanks much
>|||No, it's not possible. For example, I just now deleted all the DIFF
backups and started from zero. I ran the differential backup again. It
ran for about 5 minutes and created a diff backup that is 1.6 GB in
size! The db itself is only 90 MB in size, and the log is 137 MB in
size.
? Not sure how to go about troubleshooting this one... never seen
this problem before.
Tibor Karaszi wrote:
> Are you sure you don't have several backups on the same file? Use RESTORE HEADERONLY.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <tootsuite@.gmail.com> wrote in message news:1161877716.372685.197900@.h48g2000cwc.googlegroups.com...
> > Hello,
> >
> > Just recently I noticed that on one of our databases, the diff backups
> > are HUGE compared to the full backups.
> >
> > For example, the regular full backup is only 80 MB, however the diff
> > backups are 800 MB to 1.2 GB in size. The activity on this database is
> > low. Our other databases are not exhibiting this anomaly, whereas they
> > have much higher activiity.
> >
> > Is there any logical explanation for this? How I can see what's going
> > on with the diff backups?
> >
> > Thanks much
> >|||Strange... What does RESTORE HEADERONLY and RESTORE FILELISTONLY say? Anything out of the ordinary?
Does the size go down after doing a database backup?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<tootsuite@.gmail.com> wrote in message news:1161878879.100901.263140@.k70g2000cwa.googlegroups.com...
> No, it's not possible. For example, I just now deleted all the DIFF
> backups and started from zero. I ran the differential backup again. It
> ran for about 5 minutes and created a diff backup that is 1.6 GB in
> size! The db itself is only 90 MB in size, and the log is 137 MB in
> size.
> ? Not sure how to go about troubleshooting this one... never seen
> this problem before.
>
>
> Tibor Karaszi wrote:
>> Are you sure you don't have several backups on the same file? Use RESTORE HEADERONLY.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> <tootsuite@.gmail.com> wrote in message
>> news:1161877716.372685.197900@.h48g2000cwc.googlegroups.com...
>> > Hello,
>> >
>> > Just recently I noticed that on one of our databases, the diff backups
>> > are HUGE compared to the full backups.
>> >
>> > For example, the regular full backup is only 80 MB, however the diff
>> > backups are 800 MB to 1.2 GB in size. The activity on this database is
>> > low. Our other databases are not exhibiting this anomaly, whereas they
>> > have much higher activiity.
>> >
>> > Is there any logical explanation for this? How I can see what's going
>> > on with the diff backups?
>> >
>> > Thanks much
>> >
>|||Hi Tibor, thanks for the suggestion, RESTORE FILELISTONLY revealed the
problem.
Tibor Karaszi wrote:
> Strange... What does RESTORE HEADERONLY and RESTORE FILELISTONLY say? Anything out of the ordinary?
> Does the size go down after doing a database backup?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <tootsuite@.gmail.com> wrote in message news:1161878879.100901.263140@.k70g2000cwa.googlegroups.com...
> > No, it's not possible. For example, I just now deleted all the DIFF
> > backups and started from zero. I ran the differential backup again. It
> > ran for about 5 minutes and created a diff backup that is 1.6 GB in
> > size! The db itself is only 90 MB in size, and the log is 137 MB in
> > size.
> >
> > ? Not sure how to go about troubleshooting this one... never seen
> > this problem before.
> >
> >
> >
> >
> > Tibor Karaszi wrote:
> >> Are you sure you don't have several backups on the same file? Use RESTORE HEADERONLY.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> <tootsuite@.gmail.com> wrote in message
> >> news:1161877716.372685.197900@.h48g2000cwc.googlegroups.com...
> >> > Hello,
> >> >
> >> > Just recently I noticed that on one of our databases, the diff backups
> >> > are HUGE compared to the full backups.
> >> >
> >> > For example, the regular full backup is only 80 MB, however the diff
> >> > backups are 800 MB to 1.2 GB in size. The activity on this database is
> >> > low. Our other databases are not exhibiting this anomaly, whereas they
> >> > have much higher activiity.
> >> >
> >> > Is there any logical explanation for this? How I can see what's going
> >> > on with the diff backups?
> >> >
> >> > Thanks much
> >> >
> >|||tootsuite@.gmail.com wrote:
> Hi Tibor, thanks for the suggestion, RESTORE FILELISTONLY revealed the
> problem.
>
Don't leave us hanging! What was the problem?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It's embarassingly stupid, I'm afraid - was backing up the wrong
database :-)
Tracy McKibben wrote:
> tootsuite@.gmail.com wrote:
> > Hi Tibor, thanks for the suggestion, RESTORE FILELISTONLY revealed the
> > problem.
> >
> Don't leave us hanging! What was the problem?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||<tootsuite@.gmail.com> wrote in message
news:1161888872.392346.209340@.e3g2000cwe.googlegroups.com...
> It's embarassingly stupid, I'm afraid - was backing up the wrong
> database :-)
>
LOL!
If it's any consolation, you're not the only person who has done stuff like
that. :-)
> Tracy McKibben wrote:
>> tootsuite@.gmail.com wrote:
>> > Hi Tibor, thanks for the suggestion, RESTORE FILELISTONLY revealed the
>> > problem.
>> >
>> Don't leave us hanging! What was the problem?
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com
>

Differential Backup disproportionately large

Hello,
Just recently I noticed that on one of our databases, the diff backups
are HUGE compared to the full backups.
For example, the regular full backup is only 80 MB, however the diff
backups are 800 MB to 1.2 GB in size. The activity on this database is
low. Our other databases are not exhibiting this anomaly, whereas they
have much higher activiity.
Is there any logical explanation for this? How I can see what's going
on with the diff backups?
Thanks muchAre you sure you don't have several backups on the same file? Use RESTORE HE
ADERONLY.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<tootsuite@.gmail.com> wrote in message news:1161877716.372685.197900@.h48g2000cwc.googlegroup
s.com...
> Hello,
> Just recently I noticed that on one of our databases, the diff backups
> are HUGE compared to the full backups.
> For example, the regular full backup is only 80 MB, however the diff
> backups are 800 MB to 1.2 GB in size. The activity on this database is
> low. Our other databases are not exhibiting this anomaly, whereas they
> have much higher activiity.
> Is there any logical explanation for this? How I can see what's going
> on with the diff backups?
> Thanks much
>|||No, it's not possible. For example, I just now deleted all the DIFF
backups and started from zero. I ran the differential backup again. It
ran for about 5 minutes and created a diff backup that is 1.6 GB in
size! The db itself is only 90 MB in size, and the log is 137 MB in
size.
? Not sure how to go about troubleshooting this one... never seen
this problem before.
Tibor Karaszi wrote:[vbcol=seagreen]
> Are you sure you don't have several backups on the same file? Use RESTORE
HEADERONLY.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <tootsuite@.gmail.com> wrote in message news:1161877716.372685.197900@.h48g2
000cwc.googlegroups.com...|||Strange... What does RESTORE HEADERONLY and RESTORE FILELISTONLY say? Anythi
ng out of the ordinary?
Does the size go down after doing a database backup?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<tootsuite@.gmail.com> wrote in message news:1161878879.100901.263140@.k70g2000cwa.googlegroup
s.com...
> No, it's not possible. For example, I just now deleted all the DIFF
> backups and started from zero. I ran the differential backup again. It
> ran for about 5 minutes and created a diff backup that is 1.6 GB in
> size! The db itself is only 90 MB in size, and the log is 137 MB in
> size.
> ? Not sure how to go about troubleshooting this one... never seen
> this problem before.
>
>
> Tibor Karaszi wrote:
>|||Hi Tibor, thanks for the suggestion, RESTORE FILELISTONLY revealed the
problem.
Tibor Karaszi wrote:[vbcol=seagreen]
> Strange... What does RESTORE HEADERONLY and RESTORE FILELISTONLY say? Anyt
hing out of the ordinary?
> Does the size go down after doing a database backup?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <tootsuite@.gmail.com> wrote in message news:1161878879.100901.263140@.k70g2
000cwa.googlegroups.com...|||tootsuite@.gmail.com wrote:
> Hi Tibor, thanks for the suggestion, RESTORE FILELISTONLY revealed the
> problem.
>
Don't leave us hanging! What was the problem?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It's embarassingly stupid, I'm afraid - was backing up the wrong
database :-)
Tracy McKibben wrote:
> tootsuite@.gmail.com wrote:
> Don't leave us hanging! What was the problem?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||<tootsuite@.gmail.com> wrote in message
news:1161888872.392346.209340@.e3g2000cwe.googlegroups.com...
> It's embarassingly stupid, I'm afraid - was backing up the wrong
> database :-)
>
LOL!
If it's any consolation, you're not the only person who has done stuff like
that. :-)

> Tracy McKibben wrote:
>

Friday, February 24, 2012

Different Display based on Text

I have an HTMP form and for some reason, when I use a regular TextBox to display a field, Via an ASP conneciton to the database, it cuts it off when it gets to a " (A quote)

Example:

Field: Title
Data: Where do "rabbits" come from?

If I try to pull that field into a regular html textbox it dispays,

Where do

Then if I change the textbox to a textarea it displays the entire field

Where do "rabbits" come from?

Is this a setting that causes this in SQL Server on the table.

I am new to SQL Server and am trying to learn these little differences.

Any help would be greatly appreciated.

Thanks,Sounds like an ASP problem. SQL is ignorant of how you are displaying the data.

Perhaps you need to double the quotes when using a textbox?

--> Where do ""rabbits"" come from?

Just guessing.|||Then the quotes get saved as double when you display the field in a different manner.