Question to Microsoft: Is this group moderated?

If it is, then what is the criteria for determining whether a post stays or
goes?
I ask because I posted a question on Thursday March 30 and I don't see it in
the list. I thought it was appropriate for this group.
--
Henry Stock, Network Administrator
onProject.com
3 Wing Drive
Cedar Knolls, NJ 07927-1006Henry wrote on Mon, 3 Apr 2006 10:56:12 -0400:

> If it is, then what is the criteria for determining whether a post stays
> or goes?
> I ask because I posted a question on Thursday March 30 and I don't see it
> in the list. I thought it was appropriate for this group.
It's not moderated. What was the subject of the post? A quick search in
Outlook Express pulls up one posted by you with the subject "How do I get
just one set?" and a reply from Joe Celko, is that the one? How are you
accessing the group? I use NNTP access direct to msnews.microsoft.com - if
you are relying on a feed via another usenet provider it's possible their
server is dropping posts (either randomly or intentionally).
Dan|||Henry Stock wrote:
> If it is, then what is the criteria for determining whether a post stays o
r
> goes?
> I ask because I posted a question on Thursday March 30 and I don't see it
in
> the list. I thought it was appropriate for this group.
> --
> Henry Stock, Network Administrator
> onProject.com
> 3 Wing Drive
> Cedar Knolls, NJ 07927-1006
Not moderated and not owned by MS either. This is a public newsgroup.
Is this the question you mean?
http://groups.google.com/group/micr...1eab69c9feb8505
You have an answer. I don't know if it helps. If you need more or if
you don't see your post in the archive (http://groups.google.com) then
post again.
It helps if you can include enough code to reproduce your problem. For
that type of question that means CREATE TABLE, some INSERTs for some
sample data and then show what end result you expect from that sample.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||No, it is not moderated in that way.
For a more reliable experience, be sure to post using msnews.microsoft.com,
and not your local news server's feed or the web interface to the forums.
If you post and read using msnews.microsoft.com, you don't have to worry
about your own news server's ability to keep up with the real server (since
they basically borrow the content) and you don't have to worry about
Microsoft's ability to keep the NNTP forum and the web interface in sync
(which has a track record that's spotty at best).
A
"Henry Stock" <hstock@.onproject.com> wrote in message
news:uN4eB7yVGHA.4956@.TK2MSFTNGP09.phx.gbl...
> If it is, then what is the criteria for determining whether a post stays
> or
> goes?
> I ask because I posted a question on Thursday March 30 and I don't see it
> in
> the list. I thought it was appropriate for this group.
> --
> Henry Stock, Network Administrator
> onProject.com
> 3 Wing Drive
> Cedar Knolls, NJ 07927-1006
>

question regarding CASE and GROUP BY

I have the below query and I am not sure if this will return an accurate aggregate, I know I cannot just group by my alias GLG_DELEGATE_ID, is this the way to handle aggregates when you have a CASE in the SELECT statement?

SELECT CASE
WHEN C.GLG_DELEGATE_ID IS null THEN C.GLG_ID
ELSE C.GLG_DELEGATE_ID
END AS GLG_DELEGATE_ID
,COUNT(P.CONSULTATION_ID) ACTIVITY_AMOUNT
FROM
dbo.CONSULTATION C
GROUP BY
C.GLG_DELEGATE_ID
, C.GLG_IDNo, just repeat your CASE code in the WHERE clause:

SELECT CASE WHEN C.GLG_DELEGATE_ID IS null THEN C.GLG_ID
ELSE C.GLG_DELEGATE_ID
END AS GLG_DELEGATE_ID
,COUNT(P.CONSULTATION_ID) ACTIVITY_AMOUNT
FROM dbo.CONSULTATION C
GROUP BY CASE WHEN C.GLG_DELEGATE_ID IS null THEN C.GLG_ID
ELSE C.GLG_DELEGATE_ID END
,C.GLG_ID

Question on SQL Cluster Resource Groups

I have a sql cluster with my virtual server name, IP address, etc. in one
group. In the other group I have my sql instance, san attached disk
resources, sql agent etc. In this second group I also have a ftp server that
utilizes the vbscript for fail over and uses a san disk resource.
The problem I have is if the second group fails over say, due to a sql
server error which has happened, then my ftp site dies as users put to the
ftp site via the name / ip of the virtual server but then the virtual server
cannot see the disk resources that are part of the second group.
Is there any issues with putting the virtual server name & ip address in the
same group with sql, sql agent, disk resources, etc.? In essence, putting
everything in one group.
Thanks in advance,
John
You have a couple of options, and I'm sure different people may have
different opinions w.r.t. their pros and cons.
Option 1:
Move the resources from group 1 into the second group, and edit the
dependencies property of your virtual server to include the disk resources
you mentioned. In order to protect the HA of your SQL Server instance, you
may want to edit the advanced property tab of the resources--moved over from
group 1--so that their faulire doesn't affect the group.
Option 2:
Keep the groups as they are. Create a file share resource(s) in group 2, and
use the file share via the virtual server. I don't know the nature of your
particular virtual server, so I'm not sure this works for you.
Personally, I prefer to keep the SQL Server group clean, and will try very
hard to question any attempt to include additional resources in that group.
However, in your situation you already have a bunch of non-SQL Server native
resources in the SQL group so adding a few more may not do a great deal more
potential harm (of course that all depends on the details of the virtual
server in question.)
Linchi
"John - PDX" <JohnPDX@.discussions.microsoft.com> wrote in message
news:D5396113-A4A6-4EA3-973F-B4CBF2021CDB@.microsoft.com...
>I have a sql cluster with my virtual server name, IP address, etc. in one
> group. In the other group I have my sql instance, san attached disk
> resources, sql agent etc. In this second group I also have a ftp server
> that
> utilizes the vbscript for fail over and uses a san disk resource.
> The problem I have is if the second group fails over say, due to a sql
> server error which has happened, then my ftp site dies as users put to the
> ftp site via the name / ip of the virtual server but then the virtual
> server
> cannot see the disk resources that are part of the second group.
> Is there any issues with putting the virtual server name & ip address in
> the
> same group with sql, sql agent, disk resources, etc.? In essence, putting
> everything in one group.
> --
> Thanks in advance,
> John
|||I think your biggest problem is one of definition. By definition, each
Cluster Resource Group IS A SEPARATE VIRTUAL SERVER.
Each group has its own Disk, IP, Network Name, and application resources.
If the FTP server is dependent on the SQL Server instance, then define the
FTP site resources within the SQL Server Cluster Resource Group; otherwise,
create a separate Cluster Resource Group for IIS.
Every Cluster has at least 1 resource group BEFORE there exists any failover
applications, the Cluster Group itself, which must stay independent and
uncontaminated by other resources.
Cluster Resource Group:
Quorum Disk, Cluster IP, Cluster Network Name.
Microsoft Distributed Transaction Coordinator (MS DTC) Resource Group:
MSDTC dedicated Disk, MSDTC IP, MSDTC Network Name.
SQL Server Resource Group:
SQL Server dedicated Disk, SQL Server IP, SQL Server Network Name, SQL
Server Instance, SQL Agent.
Internet Information Server (IIS) Resource Group:
IIS dedicated Disk, IIS IP, IIS Network Name, FTP Site.
Although possible to include the IIS resources within the SQL Server
Resource Group, you would be better off creating a separate group dedicated
to IIS resources. End users would connect to SQL Server through the SQL
Server Cluster Resource Group Network Name and SQL Server Instance name
defined within that group. End users would connect to the FTP site through
the IIS Cluster Resource Group Network Name and FTP site name defined within
that group.
Whenever a Cluster Resource Group fails over, the Disk, IP, Network Name,
and dependent application resources defined within that group fail over
together. Even if the SQL Server resource group failed over, the FTP site
would still be available on the original host through the IIS Cluster
Resource Group Network Name. They are independent.
You use the physical node names to define cluster resources and to manage
non-clustered components on each node, like the OS and swap spaces, Network
Backup software, etc. You use the Cluster Resource Group Network Name to
manage the cluster as a whole. You use the MS DTC Network Name to manage MS
DTC, the SQL Server Network Name to manage SQL Server, and, finally, the IIS
Network Name to manager IIS. All independently but from within the same
cluster.
To go one step farther, you should really install separate hardware and
cluster IIS using Microsoft Network Load Balancing high availability
clustering, not Sever Cluster failover clustering.
Hope this helps.
Sincerely,
Anthony Thomas

"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:OqN4Qps0FHA.2932@.TK2MSFTNGP10.phx.gbl...
> You have a couple of options, and I'm sure different people may have
> different opinions w.r.t. their pros and cons.
> Option 1:
> Move the resources from group 1 into the second group, and edit the
> dependencies property of your virtual server to include the disk resources
> you mentioned. In order to protect the HA of your SQL Server instance, you
> may want to edit the advanced property tab of the resources--moved over
from
> group 1--so that their faulire doesn't affect the group.
> Option 2:
> Keep the groups as they are. Create a file share resource(s) in group 2,
and
> use the file share via the virtual server. I don't know the nature of your
> particular virtual server, so I'm not sure this works for you.
> Personally, I prefer to keep the SQL Server group clean, and will try very
> hard to question any attempt to include additional resources in that
group.
> However, in your situation you already have a bunch of non-SQL Server
native
> resources in the SQL group so adding a few more may not do a great deal
more[vbcol=seagreen]
> potential harm (of course that all depends on the details of the virtual
> server in question.)
> Linchi
> "John - PDX" <JohnPDX@.discussions.microsoft.com> wrote in message
> news:D5396113-A4A6-4EA3-973F-B4CBF2021CDB@.microsoft.com...
the[vbcol=seagreen]
putting
>

question on crystal reports

Hi,
there is a requirement of making Login name field just 4 characters. This is Group name type field which shows login names. We have to decrease the length of login names to save space. How shd I proceed?
ThanksSorry, not clear on the question, are you trying to reduce the length in the report, or in the database ?

Question on attribute keys of measure group

Hi, dear friends,

I encountered a problem processing my cube with the error message telling: processing measure_group_name (which only has a count as its only measure)failed as attribute keys can not be found? Why is that? I have no idea why is that? Does it mean I have to include all the keys of the fact table where the measure group from in the measure groups as measures? Otherwise the system failed to identify the distinct count of the system? Or whatever measures the measure group contains, it alwys have to include all the keys including the dimension keys of dimensions which the measure group is related to?

Thanks in advance for your help and advices and I am always looking forward to hearing from you shortly from you.

With best regards,

Yours sincerely,

This message means that a column used to join the measure group to a dimension contains a value not found in the dimension. This is usually caused by a referential integrity error - the FK does not existing in the PK of the lookup table. However, it can also be caused by the presence of a null in the FK as by default this null will be converted to zero or blank which probably does not exist as a key in the dimension. You can handle the situation of nulls in FK columns within the fact table by setting the NullProcessing option in the advanced tab of the measure group relationship dialog from the Dimension Usage tab of the cube editor.|||

Hi, Matt,

Thanks a lot. Yes, the problem is the matching of the PK and the FK between the tables.

However, the data source view logical key and the relationships between tables are really annoying then, as it is not able to check the integrity of the tables?

With best regards,

Yours sincerely,

|||

So it sounds like you would like to have an option on the Data Source View to validate logical keys and relationships. I'd recommend you file a feature request on http://connect.microsoft.com/SQLServer/Feedback. Such feature requests will be automatically added to our issue tracking system for consideration in future releases and those that originate from a customer such as yourself get extra consideration since we know it's a real world scenario. If you can describe the scenario it will also help as it will allow us to better identify which requests will help the most people and how to implement them so that they actually provide the help intended.

Thanks, Matt

|||

Hi, Matt,

Thanks a lot and this sounds really a good idea of it.

With best regards,

Yours sincerely,