Sunday, February 26, 2012
Don't Auto Run with default parameters
are set?
We would like to give the users some defaults so they don't have to type as
much when they run a report.Unfortunately there is not. There have been many request for this feature.
If you can wait for Yukon then you could use the viewer control which you
could give this behavior.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alec Hardy" <AlecHardy@.discussions.microsoft.com> wrote in message
news:B3C08BBF-2D07-4941-A986-BA89E122E346@.microsoft.com...
> Is there a way to not have a report run when all of the default parameters
> are set?
> We would like to give the users some defaults so they don't have to type
> as
> much when they run a report.
Friday, February 24, 2012
domain password policy on 2005
It looks like by default (once you check the enforce policy box during new
login creation) it uses password policy of local machine, not the domain
policy. My server is in the domain and its running Windows 2003 sp1 and has
sql 2005 sp1 installed and not sure how to enforce the domain policy rather
than local machine policy.
Thanks in advance.the feature is not available at this time.
--
-oj
"james" <kush@.brandes.com> wrote in message
news:%235TtLS4mGHA.4208@.TK2MSFTNGP04.phx.gbl...
> Hi! How do we enforce Sql authenticated logins, the domain password
> policy?
> It looks like by default (once you check the enforce policy box during new
> login creation) it uses password policy of local machine, not the domain
> policy. My server is in the domain and its running Windows 2003 sp1 and
> has sql 2005 sp1 installed and not sure how to enforce the domain policy
> rather than local machine policy.
> Thanks in advance.
>
domain password policy on 2005
It looks like by default (once you check the enforce policy box during new
login creation) it uses password policy of local machine, not the domain
policy. My server is in the domain and its running Windows 2003 sp1 and has
sql 2005 sp1 installed and not sure how to enforce the domain policy rather
than local machine policy.
Thanks in advance.the feature is not available at this time.
-oj
"james" <kush@.brandes.com> wrote in message
news:%235TtLS4mGHA.4208@.TK2MSFTNGP04.phx.gbl...
> Hi! How do we enforce Sql authenticated logins, the domain password
> policy?
> It looks like by default (once you check the enforce policy box during new
> login creation) it uses password policy of local machine, not the domain
> policy. My server is in the domain and its running Windows 2003 sp1 and
> has sql 2005 sp1 installed and not sure how to enforce the domain policy
> rather than local machine policy.
> Thanks in advance.
>
Domain groups disabled by default. how to enable them by default?
Hello,
I notticed that to add a domain global group to a role, you first have to enable this type of object.
Also, I did convert a few cubes from 2000. I have a lot of domain groups associated with a lot of roles, the problem here is that the membership shows a UID instead of the group name because the group object is disabled.
1) How could I have the domain group object enabled by default in a new cube
2) How could I have te domain group object enabled in all existing roles so the system would be able to resolve them?
3) Where would be the place to find documentation and examples for the replacement of the old DSO that I was using to script my 2000 cubes.
Thanks,
Philippe
I beleive you a bit mistaken with what is going on.
The membership pane in Roles editor is invoking OS dialog when you try to add a user to a role. That is the same dialog you will see when you for instance try to change folder permissions in your hard drive.
What you can do is to open your database in SQL Management studio, click on the role you interested and then click on the Script. You will see XMLA script that you can use to change memebership in the role. You can manually change it to update group names. Analysis Server is agnostic to the name of the member. It will try to resolve it using windows API. Make sure you use domainname\username or domainname\groupname for members names in a role.
In Analysis Serivces 2005 you will use AMO object model to mange objects. But if you need a simple scripting solution, you might be fine with just using XMLA scripts.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
Sunday, February 19, 2012
Doing the lookup on the server while inserting
CREATE TABLE tbl_ft_testsegments (
SegmentID int(10) AUTO_INCREMENT NOT NULL,
TestID smallint(6) NOT NULL DEFAULT '0',
CarrierFreq smallint(6) NOT NULL DEFAULT '0',
BeatFreq smallint(6) NOT NULL DEFAULT '0',
BeatFreqDelta smallint(6) NOT NULL DEFAULT '0',
Duration tinyint(4) NOT NULL DEFAULT '0',
AmplitudeRampID tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY(SegmentID)
)
CREATE TABLE tbl_ft_amplituderamps (
AmplitudeRampID tinyint(4) AUTO_INCREMENT NOT NULL,
Name char(12) NOT NULL,
PRIMARY KEY(AmplitudeRampID)
)
tbl_ft_amplituderamps is constant and will not change.
On the client, I load a text file that has string values that match what is
in amplituderamps, or atleast they are supposed to!
I store this data in a business object that has the string representation of
an "amplitude ramp"
When I insert them, I am currently getting the AmplitudeRampID from
tbl_ft_amplituderamps where <text file value> = tbl_ft_amplituderamps.Name
THis isn't *too* bad cause I have a local copy of the whole table in memory.
I am considering instead of doing the insert with string instead of the ID
and doing the lookup on teh server side.
Something like:
@.myString varchar(20)
INSERT INTO tbl_ft_testsegments (AmplitudeRampID)
SELECT tbl_ft_amplituderamps.AmplitudeRampID
FROM tbl_ft_amplituderamps WHERE tbl_ft_amplituderamps.Name = myString
Being far from a professional, I'm wondering if this is the *preferred*
method? Is it better to do a little lookup on the client or should I do
this on the server?
Any suggestions would be much appreciated. I have MANY cases where I need
to do this and I would like to get teh best method sorted out before I add
the sprocs for all of the different tables.
Thanks for reading!
Steve"sklett" <sklett@.mddirect.com> wrote in message
news:uddCEzXZGHA.1204@.TK2MSFTNGP04.phx.gbl...
>I have these 2 tables:
> CREATE TABLE tbl_ft_testsegments (
> SegmentID int(10) AUTO_INCREMENT NOT NULL,
> TestID smallint(6) NOT NULL DEFAULT '0',
> CarrierFreq smallint(6) NOT NULL DEFAULT '0',
> BeatFreq smallint(6) NOT NULL DEFAULT '0',
> BeatFreqDelta smallint(6) NOT NULL DEFAULT '0',
> Duration tinyint(4) NOT NULL DEFAULT '0',
> AmplitudeRampID tinyint(4) NOT NULL DEFAULT '0',
> PRIMARY KEY(SegmentID)
> )
> CREATE TABLE tbl_ft_amplituderamps (
> AmplitudeRampID tinyint(4) AUTO_INCREMENT NOT NULL,
> Name char(12) NOT NULL,
> PRIMARY KEY(AmplitudeRampID)
> )
>
> tbl_ft_amplituderamps is constant and will not change.
> On the client, I load a text file that has string values that match what
> is in amplituderamps, or atleast they are supposed to!
> I store this data in a business object that has the string representation
> of an "amplitude ramp"
> When I insert them, I am currently getting the AmplitudeRampID from
> tbl_ft_amplituderamps where <text file value> =
> tbl_ft_amplituderamps.Name
> THis isn't *too* bad cause I have a local copy of the whole table in
> memory. I am considering instead of doing the insert with string instead
> of the ID and doing the lookup on teh server side.
> Something like:
> @.myString varchar(20)
> INSERT INTO tbl_ft_testsegments (AmplitudeRampID)
> SELECT tbl_ft_amplituderamps.AmplitudeRampID
> FROM tbl_ft_amplituderamps WHERE tbl_ft_amplituderamps.Name = myString
>
> Being far from a professional, I'm wondering if this is the *preferred*
> method? Is it better to do a little lookup on the client or should I do
> this on the server?
> Any suggestions would be much appreciated. I have MANY cases where I need
> to do this and I would like to get teh best method sorted out before I add
> the sprocs for all of the different tables.
> Thanks for reading!
> Steve
>
One approach that works well with large data sets is to insert the entire
file into a temporary "staging" table in the database, then do the whole
thing with a join:
INSERT INTO tbl_ft_testsegments (AmplitudeRampID)
SELECT DISTINCT A.AmplitudeRampID
FROM tbl_ft_amplituderamps AS A
JOIN staging AS S
ON A.Name = S.String ;
For loading the file itself you have a number of options. DTS (SQL Server
2000) or Integration Services (2005) or BCP for example.
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
--|||Hi,
> Being far from a professional, I'm wondering if this is the *preferred*
> method? Is it better to do a little lookup on the client or should I do
> this on the server?
Yes. Centralise as much of your logic on the server as possible. Keep
your client-side software as light-weight as you can - ideally, limit it to
presentation only. The processing work belongs on the server(s). Golden
rule, end of story :)
Robert.
"sklett" <sklett@.mddirect.com> wrote in message
news:uddCEzXZGHA.1204@.TK2MSFTNGP04.phx.gbl...
>I have these 2 tables:
> CREATE TABLE tbl_ft_testsegments (
> SegmentID int(10) AUTO_INCREMENT NOT NULL,
> TestID smallint(6) NOT NULL DEFAULT '0',
> CarrierFreq smallint(6) NOT NULL DEFAULT '0',
> BeatFreq smallint(6) NOT NULL DEFAULT '0',
> BeatFreqDelta smallint(6) NOT NULL DEFAULT '0',
> Duration tinyint(4) NOT NULL DEFAULT '0',
> AmplitudeRampID tinyint(4) NOT NULL DEFAULT '0',
> PRIMARY KEY(SegmentID)
> )
> CREATE TABLE tbl_ft_amplituderamps (
> AmplitudeRampID tinyint(4) AUTO_INCREMENT NOT NULL,
> Name char(12) NOT NULL,
> PRIMARY KEY(AmplitudeRampID)
> )
>
> tbl_ft_amplituderamps is constant and will not change.
> On the client, I load a text file that has string values that match what
> is in amplituderamps, or atleast they are supposed to!
> I store this data in a business object that has the string representation
> of an "amplitude ramp"
> When I insert them, I am currently getting the AmplitudeRampID from
> tbl_ft_amplituderamps where <text file value> =
> tbl_ft_amplituderamps.Name
> THis isn't *too* bad cause I have a local copy of the whole table in
> memory. I am considering instead of doing the insert with string instead
> of the ID and doing the lookup on teh server side.
> Something like:
> @.myString varchar(20)
> INSERT INTO tbl_ft_testsegments (AmplitudeRampID)
> SELECT tbl_ft_amplituderamps.AmplitudeRampID
> FROM tbl_ft_amplituderamps WHERE tbl_ft_amplituderamps.Name = myString
>
> Being far from a professional, I'm wondering if this is the *preferred*
> method? Is it better to do a little lookup on the client or should I do
> this on the server?
> Any suggestions would be much appreciated. I have MANY cases where I need
> to do this and I would like to get teh best method sorted out before I add
> the sprocs for all of the different tables.
> Thanks for reading!
> Steve
>
Tuesday, February 14, 2012
Does the number of CPU's returned
http://support.microsoft.com/default.aspx?scid=kb;en-us;328551
and I need to know how many physical CPUs on each server.
thanks people.
--
-- cranfield, DBAI beleive that hyper threaded installs DO show the hyper CPUs , so you will
see double the CPUs.... You also may wish to reduce the number of CPUs that
sql can use and/or reduce the MAXDOP setting.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Cranfield" <alan_cranfield@.msn.co.za> wrote in message
news:3C283647-380D-4A91-A3BB-5B4956044691@.microsoft.com...
> We need to configure our tempdb files according to
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328551
> and I need to know how many physical CPUs on each server.
> thanks people.
> --
> -- cranfield, DBA|||thanks, Wayne
We've been hitting the errors as described in the below KB and I need to
rollout these tempdb changes to 150 SQL Servers. Problem is not all of them
are the same and hence the need for me to write a script that will make the
following changes to TEMPDB and batch it out to all the servers:
1) Turn off auto grow. Pre-allocate space for tempdb files.
2) Make as many tempdb files as there are CPU's (accounting for any affinity
mask settings)
3) Make these file sizes of equal amounts
So I need to know the number of physical CPUs.
Do you know if KB328551 refers to physical or logical CPUs?
thanks again
-- cranfield, DBA
"Wayne Snyder" wrote:
> I beleive that hyper threaded installs DO show the hyper CPUs , so you will
> see double the CPUs.... You also may wish to reduce the number of CPUs that
> sql can use and/or reduce the MAXDOP setting.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Cranfield" <alan_cranfield@.msn.co.za> wrote in message
> news:3C283647-380D-4A91-A3BB-5B4956044691@.microsoft.com...
> > We need to configure our tempdb files according to
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;328551
> >
> > and I need to know how many physical CPUs on each server.
> >
> > thanks people.
> > --
> > -- cranfield, DBA
>
>|||xp_msver will tell you the number of logical processors.
MAXDOP should never be set higher than the number of actual physical
processors.
However, the issues being addressed in this KB don't apply simply to
parallel queries, the issue could easily (and more lilkley in fact...)
happen in a high volume OLTP situation where no queries may be parallel.
So, I woudl recommend configuring the number of tempdb files based on the
total number of logical processors currently in use by SQL Server.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Cranfield" <alan_cranfield@.msn.co.za> wrote in message
news:EF3824CD-EF37-4DDA-BCE4-48D9630C3C95@.microsoft.com...
> thanks, Wayne
> We've been hitting the errors as described in the below KB and I need to
> rollout these tempdb changes to 150 SQL Servers. Problem is not all of
them
> are the same and hence the need for me to write a script that will make
the
> following changes to TEMPDB and batch it out to all the servers:
> 1) Turn off auto grow. Pre-allocate space for tempdb files.
> 2) Make as many tempdb files as there are CPU's (accounting for any
affinity
> mask settings)
> 3) Make these file sizes of equal amounts
> So I need to know the number of physical CPUs.
> Do you know if KB328551 refers to physical or logical CPUs?
> thanks again
>
> --
> -- cranfield, DBA
>
> "Wayne Snyder" wrote:
> > I beleive that hyper threaded installs DO show the hyper CPUs , so you
will
> > see double the CPUs.... You also may wish to reduce the number of CPUs
that
> > sql can use and/or reduce the MAXDOP setting.
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Cranfield" <alan_cranfield@.msn.co.za> wrote in message
> > news:3C283647-380D-4A91-A3BB-5B4956044691@.microsoft.com...
> > > We need to configure our tempdb files according to
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;328551
> > >
> > > and I need to know how many physical CPUs on each server.
> > >
> > > thanks people.
> > > --
> > > -- cranfield, DBA
> >
> >
> >