download many rdl files from Reporting Server at once

GoodDay,
we have uploaded a large number of rdl files on the reporting server. now
when we want to download these files we have to download it one by one.
is there any efficient way to download a large number of files in one shot.
Downloading files one by one makes it too time consuming. So it wud be great
if u can help me out to download all the rdl files at once
I looked in the report manager but no such option is avaliable other than
saving a single file and editing it.
help wud be highy appreciated.
RajivPYou have to use the GetReportDefinition method of the RS Web Service to do
this. There is a sample of how to do this in the documentation. Search for
GetReportDefinition. There is no way I know of doing this from the interface.
Charles Kangai, MCT, MCDBA
"rajivp" wrote:
> GoodDay,
> we have uploaded a large number of rdl files on the reporting server. now
> when we want to download these files we have to download it one by one.
> is there any efficient way to download a large number of files in one shot.
> Downloading files one by one makes it too time consuming. So it wud be great
> if u can help me out to download all the rdl files at once
> I looked in the report manager but no such option is avaliable other than
> saving a single file and editing it.
> help wud be highy appreciated.
> RajivP

Doubling of Processors

I have been looking at a number of servers that have been installed in my
office lately. I know that these servers have 2 processors but when I look a
t
my SQL Server installations it shows that I have 4 processors on each of
these server. Is there something wrong with my installation or is this a
default behavior I don't understand.Hi,
Your server must be Hyper-Threading (HT) enabled.
See this link:-
QLonHTT.doc+hyper+threaded+sql+server&hl=en" target="_blank">http://64.233.167.104/search?q=cach...ql+server&hl=en
Thanks
Hari
SQL Server MVP
"GarrettD78" wrote:

> I have been looking at a number of servers that have been installed in my
> office lately. I know that these servers have 2 processors but when I look
at
> my SQL Server installations it shows that I have 4 processors on each of
> these server. Is there something wrong with my installation or is this a
> default behavior I don't understand.
>

Doubling of Processors

I have been looking at a number of servers that have been installed in my
office lately. I know that these servers have 2 processors but when I look at
my SQL Server installations it shows that I have 4 processors on each of
these server. Is there something wrong with my installation or is this a
default behavior I don't understand.Hi,
Your server must be Hyper-Threading (HT) enabled.
See this link:-
http://64.233.167.104/search?q=cache:LoRY2h6ZsfwJ:www.microsoft.com/sql/howtobuy/SQLonHTT.doc+hyper+threaded+sql+server&hl=en
Thanks
Hari
SQL Server MVP
"GarrettD78" wrote:
> I have been looking at a number of servers that have been installed in my
> office lately. I know that these servers have 2 processors but when I look at
> my SQL Server installations it shows that I have 4 processors on each of
> these server. Is there something wrong with my installation or is this a
> default behavior I don't understand.
>

Doubling of Processors

I have been looking at a number of servers that have been installed in my
office lately. I know that these servers have 2 processors but when I look at
my SQL Server installations it shows that I have 4 processors on each of
these server. Is there something wrong with my installation or is this a
default behavior I don't understand.
Hi,
Your server must be Hyper-Threading (HT) enabled.
See this link:-
http://64.233.167.104/search?q=cache...l+server&hl=en
Thanks
Hari
SQL Server MVP
"GarrettD78" wrote:

> I have been looking at a number of servers that have been installed in my
> office lately. I know that these servers have 2 processors but when I look at
> my SQL Server installations it shows that I have 4 processors on each of
> these server. Is there something wrong with my installation or is this a
> default behavior I don't understand.
>

Double Pivot

Hello everybody,
I used to have a cross-tab query which gives me the number of orders
and the total value per year for each customer in the northwind
database. The result looks like this:
Customer #Orders_1996 Value_1996 #Orders_1998 Value_1997
Now I try to rewrite it using the new PIVOT operator. While I succeed
in having the count per year or the sum, I can't figure out how to
combine both aggregates in one query. BOL online aren't much help and
so far in all the articles I haven't seen an example using more than
one.
Does anybody knows if this is possible ?
Thanks MarkusIt is not possible :(
Send an e-mail to sqlwish@.microsoft.com ...
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
<m.bohse@.quest-consultants.com> wrote in message
news:1131479880.917386.253790@.g49g2000cwa.googlegroups.com...
> Hello everybody,
> I used to have a cross-tab query which gives me the number of orders
> and the total value per year for each customer in the northwind
> database. The result looks like this:
> Customer #Orders_1996 Value_1996 #Orders_1998 Value_1997
> Now I try to rewrite it using the new PIVOT operator. While I succeed
> in having the count per year or the sum, I can't figure out how to
> combine both aggregates in one query. BOL online aren't much help and
> so far in all the articles I haven't seen an example using more than
> one.
> Does anybody knows if this is possible ?
> Thanks Markus
>|||m.bo...@.quest-consultants.com wrote:
> Hello everybody,
> I used to have a cross-tab query which gives me the number of orders
> and the total value per year for each customer in the northwind
> database. The result looks like this:
> Customer #Orders_1996 Value_1996 #Orders_1998 Value_1997
> Now I try to rewrite it using the new PIVOT operator. While I succeed
> in having the count per year or the sum, I can't figure out how to
> combine both aggregates in one query. BOL online aren't much help and
> so far in all the articles I haven't seen an example using more than
> one.
> Does anybody knows if this is possible ?
Join the 2 simpler pivot queries?|||Check out the RAC utility for all kinds of static/dynamic
pivoting made easy.
www.rac4sql.net
<m.bohse@.quest-consultants.com> wrote in message
news:1131479880.917386.253790@.g49g2000cwa.googlegroups.com...
> Hello everybody,
> I used to have a cross-tab query which gives me the number of orders
> and the total value per year for each customer in the northwind
> database. The result looks like this:
> Customer #Orders_1996 Value_1996 #Orders_1998 Value_1997
> Now I try to rewrite it using the new PIVOT operator. While I succeed
> in having the count per year or the sum, I can't figure out how to
> combine both aggregates in one query. BOL online aren't much help and
> so far in all the articles I haven't seen an example using more than
> one.
> Does anybody knows if this is possible ?
> Thanks Markus
>|||> Join the 2 simpler pivot queries?
Yes that's an option, but I'm afraid that my final query won't be any
shorter than the original one using CASE statements. And I don't think
it's such an unusual request to have two aggregates (or more) in a
cross-tab report.
>Check out the RAC utility for all kinds of static/dynamic pivoting made easy.[/colo
r]
I checked it out some years ago and wasn't too impressed with it back
then. Also I don't need these kind of things too often, I just created
this query as an example/exercise during classes. But maybe it's time
to have another look at RAC, since there should be a newer version by
now.
Thanks for the comments anyway.
Markus|||<m.bohse@.quest-consultants.com> wrote in message
news:1131528859.873667.16660@.g14g2000cwa.googlegroups.com...
> then. Also I don't need these kind of things too often, I just created
> this query as an example/exercise during classes. But maybe it's time
I have taken the PIVOT slides out of my T-SQL enhancements for SQL
Server 2005 talk. The three groups I showed it to all ended up asking, "can
it do (multiple aggregations, dynamic columns, etc)" -- all things that
would make perfect sense. And the answer in every case was, "no... I guess
it's not really that useful yet... but MS tells me that it WILL BE in a
future version!" So perhaps it will get a place in my T-SQL enhancements
for SQL Server 200x talk :)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--|||Adam Machanic wrote:
> I have taken the PIVOT slides out of my T-SQL enhancements for SQL
> Server 2005 talk. The three groups I showed it to all ended up asking, "c
an
> it do (multiple aggregations, dynamic columns, etc)" -- all things that
> would make perfect sense. And the answer in every case was, "no... I gues
s
> it's not really that useful yet... but MS tells me that it WILL BE in a
> future version!" So perhaps it will get a place in my T-SQL enhancements
> for SQL Server 200x talk :)
Here is a solution, which I shamelessly plug in from my book
(therefore, the lecturing tone:-)
SQL Server 2005 introduced pivot operator as syntax extension for
table expression in the from clause
select * from
(Sales pivot (sum(Amount) for Month in ('Jan', 'Feb',
'Mar'))
As soon as a new feature is introduced people start wondering if it can
accommodate more complex cases. For example, can we do two aggregations
at once? Given the Sales relation, can we output the sales total
amounts together with sales counts like this
Product JanCnt FebCnt MarCnt JanSum FebSum MarSum
Shorts 1 1 1 20 30 50
Jeans 1 1 1 25 32 37
T-shirt 1 1 10 15
We had to change column names in order to accommodate extra columns
and, if nothing else, the changed column names should hint the
solution. The other idea, which should be immediately obvious from the
way the table columns are arranged in the display, is that the result
is a join between the two primitive pivot queries
Product JanCnt FebCnt MarCnt
Shorts 1 1 1
Jeans 1 1 1
T-shirt 1 1
and
Product JanSum FebSum MarSum
Shorts 20 30 50
Jeans 25 32 37
T-shirt 10 15
Well, what about those fancy column names? There is nothing like JanCnt
in the original data. Indeed, there isn't, but transforming the month
column data into the new column with Cnt postfix is just a string
concatenation. Therefore, the answer to the problem is
select scount.*, ssum.* from (
select * from (
(select product, month || 'Cnt', amount from Sales)
pivot (count(*) for Month in ('JanCnt', 'FebCnt',
'MarCnt')
) scount, (
select * from (
(select product, month || 'Sum', amount from Sales)
pivot (sum(Amount) for Month in ('JanSum', 'FebSum',
'MarSum')
) ssum
where scount.product = ssum.product|||"Vadim Tropashko" <vadimtro_invalid@.yahoo.com> wrote in message
news:1131593567.019132.117700@.g14g2000cwa.googlegroups.com...
> Here is a solution, which I shamelessly plug in from my book
Are you the same Vadim Tropashko who works for Oracle Corp?
If so, why are you writing a SQL Server book? :)

> select scount.*, ssum.* from (
> select * from (
> (select product, month || 'Cnt', amount from Sales)
> pivot (count(*) for Month in ('JanCnt', 'FebCnt',
> 'MarCnt')
> ) scount, (
> select * from (
> (select product, month || 'Sum', amount from Sales)
> pivot (sum(Amount) for Month in ('JanSum', 'FebSum',
> 'MarSum')
> ) ssum
> where scount.product = ssum.product
That's grossly inefficient compared with using SUM(CASE) and COUNT(CASE)
and grouping on the product.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--|||Adam Machanic wrote:
> "Vadim Tropashko" <vadimtro_invalid@.yahoo.com> wrote in message
> news:1131593567.019132.117700@.g14g2000cwa.googlegroups.com...
> Are you the same Vadim Tropashko who works for Oracle Corp?
> If so, why are you writing a SQL Server book? :)
SQL book, not Server:-)

> That's grossly inefficient compared with using SUM(CASE) and COUNT(CAS
E)
> and grouping on the product.
This is true. Although, I fail to see the point of langauge extensions
that can't work seamlessly with the existing features without being
forced to complicate syntax every time a new, slight variation of the
problem arrives. How about pivoting on composite columns, say Month x
Day. Does it require new extension...)

Domain Rename - effect on SQL

Hi everyone,
I'm planning an Active Directory Domain Rename shortly - however we have a
number of SQL Servers (2000) on the domain running integrated security.
If I rename the domain, will it cause a problem with Intrgrated security or
not? (the domain is technically the same, but a different name - e.g. users
SID's should be the same I think...!)
Cheers,
SteveHi Steve
I believe that you are correct, as the SIDS are not changing you should be
OK, but just in case you may want to run the script on
http://support.microsoft.com/kb/246133/
John
"SteveHoot" wrote:
> Hi everyone,
> I'm planning an Active Directory Domain Rename shortly - however we have a
> number of SQL Servers (2000) on the domain running integrated security.
> If I rename the domain, will it cause a problem with Intrgrated security or
> not? (the domain is technically the same, but a different name - e.g. users
> SID's should be the same I think...!)
> Cheers,
>
> Steve|||Thanks for that John - we're a development company, so if things do go
wrong then I'm for the chop. Guess the best thing to do is fire up a test
forest, domain and SQL server and give the rename a go there...!
Anyone got experience in this please let me know!
Thanks again for the help John - appreciated.
Steve.
=?Utf-8?B?Sm9obiBCZWxs?= <jbellnewsposts@.hotmail.com> wrote in
news:7B62A81D-748F-438F-B00C-B715F0D43F9D@.microsoft.com:
> Hi Steve
> I believe that you are correct, as the SIDS are not changing you
> should be OK, but just in case you may want to run the script on
> http://support.microsoft.com/kb/246133/
> John
> "SteveHoot" wrote:
>> Hi everyone,
>> I'm planning an Active Directory Domain Rename shortly - however we
>> have a number of SQL Servers (2000) on the domain running integrated
>> security.
>> If I rename the domain, will it cause a problem with Intrgrated
>> security or not? (the domain is technically the same, but a different
>> name - e.g. users SID's should be the same I think...!)
>> Cheers,
>>
>> Steve|||Hi Steve
I have done migrations but not a rename, if you rename the actual
machine then you will need to drop the server as in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
Plan your migration and make sure that you have contingencies for
failure at each step, backup the databases, script the jobs, users
etc..
Having a test domain is a very good idea.
John
Steve Hewitt wrote:
> Thanks for that John - we're a development company, so if things do go
> wrong then I'm for the chop. Guess the best thing to do is fire up a test
> forest, domain and SQL server and give the rename a go there...!
> Anyone got experience in this please let me know!
> Thanks again for the help John - appreciated.
>
> Steve.
>
> =?Utf-8?B?Sm9obiBCZWxs?= <jbellnewsposts@.hotmail.com> wrote in
> news:7B62A81D-748F-438F-B00C-B715F0D43F9D@.microsoft.com:
> > Hi Steve
> >
> > I believe that you are correct, as the SIDS are not changing you
> > should be OK, but just in case you may want to run the script on
> > http://support.microsoft.com/kb/246133/
> >
> > John
> >
> > "SteveHoot" wrote:
> >
> >> Hi everyone,
> >>
> >> I'm planning an Active Directory Domain Rename shortly - however we
> >> have a number of SQL Servers (2000) on the domain running integrated
> >> security.
> >>
> >> If I rename the domain, will it cause a problem with Intrgrated
> >> security or not? (the domain is technically the same, but a different
> >> name - e.g. users SID's should be the same I think...!)
> >>
> >> Cheers,
> >>
> >>
> >> Steve

doing a calculation from subtotals textboxes

Hi guys,
I'm very new to reporting services. I have a question.
I have to do a calculation based on the subtotals number. For example:
Column 1 = I have numbers and then I have a Subtotal 1, which is the
sum of these numbers
Column 2 = I have numbers and then I have a SubTotal 2, which is the
sum of these numbers
Column 3 = Column 1 / Column 2, but the SubTotal should not take the
sum of column 3. Instead, it should do SubTotal 1 / Subtotal 2.
Please let me know how to do that...I'm new to reporting services and
writing expressions.
THANKS!If I am understanding you correctly, On the subtotal line Column 3 should
simply be...
=sum(Column1.Value)/sum(Column2.Value)
"RSNewbie" wrote:
> Hi guys,
> I'm very new to reporting services. I have a question.
> I have to do a calculation based on the subtotals number. For example:
> Column 1 = I have numbers and then I have a Subtotal 1, which is the
> sum of these numbers
> Column 2 = I have numbers and then I have a SubTotal 2, which is the
> sum of these numbers
> Column 3 = Column 1 / Column 2, but the SubTotal should not take the
> sum of column 3. Instead, it should do SubTotal 1 / Subtotal 2.
> Please let me know how to do that...I'm new to reporting services and
> writing expressions.
> THANKS!
>

DOH! Uninstall of 2005 gone horribly wrong

I am an old hand at RDBMS but have been using SQL Server for only 1 year. I have a local install of 2005 Developer Edition, and also access a number of 2000 and 2005 instances on remote and network servers. OK, so on 3/16 (after installing the 3/15 Windows Security Updates), I began getting this error when invoking any 2005 DB under Object Explorer in Management Studio "SQLWB - SQL Server Management Studio has encountered a problem and needs to close. We are sorry for the inconvenience." Very helpful. So I ran a debug and got some unhandled exception errors:

'SqlWb.exe': Loaded 'C:\WINDOWS\system32\wbem\wbemsvc.dll', No symbols loaded.
'SqlWb.exe': Loaded 'C:\WINDOWS\system32\wbem\fastprox.dll', No symbols loaded.
'SqlWb.exe': Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\diasymreader.dll', No symbols loaded.
'SqlWb.exe': Loaded 'C:\WINDOWS\system32\apphelp.dll', No symbols loaded.
The thread 'Win32 Thread' (0x21c) has exited with code 0 (0x0).
The thread 'Win32 Thread' (0xa98) has exited with code 0 (0x0).
Unhandled exception at 0x79ea69f3 in SqlWb.exe: 0xC0000006: In page error.
First-chance exception at 0x79ea69f3 in SqlWb.exe: 0xC0000005: Access violation reading location 0x088b200c.
Unhandled exception at 0x79ea69f3 in SqlWb.exe: 0xC0000005: Access violation reading location 0x088b200c.
First-chance exception at 0x79ea69f3 in SqlWb.exe: 0xC0000005: Access violation reading location 0x088b200c.

After some poking around, my DBA told me that we had upgraded the servers for our team to SP1, and I should install that, because the file being read did not 'match up' with the commands. But when I did so I got the warning:

- Edition Change Check (Warning)

Messages

Edition Change Check

To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.

I researched this information, but it didn't really apply to my situation. So I selected 'CONTINUE' and everything went downhill from there. The install downloaded the SP1 setup support files (which by the way "cannot be removed") and then aborted. I poked around some more and decided it would be easiest to Uninstall and Reinstall the Dev Edition from the DVD and then apply the SP. The uninstall went fine until it got to the tools (which apparently were my real problem to start with). When I attempt to uninstall the tools, I get the following message:

"Error reading from file C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.SqlEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SqlEnum.dll

Verify that this file exists and that you can access it"

This message is presented with Retry and Cancel options. The file does NOT exist, so Retry is not useful and cancel rolls back the entire uninstall.

Error signature:

EventType : sql90setup P1 : installfinalize P2 : 0x643 P3 : unknown
P4 : 0x519 P5 : unknown P6 : unknown
P7 : sqlrun_tools.msi@.9.00.1399.06

In this part SP1/half uninstalled 2005 environment I am stuck like chuck. I have searched for this dll online and on other folders of my hard drive to no avail. I have also dug through these forums until my eyes are crossed.

Can anyone help?!?

One more search location turned up the answer here: http://support.microsoft.com/default.aspx/kb/909953

Turns out the tools are considered components. You can remove services and instances from the REMOVE dialog, but you have to CHANGE the client components (under workstation components) and de-select Management Tools.

I cannot believe how long it took me to find this; I finally found it today in the setup help information on the install DVD while preparing for the install. I'll leave this here for others who check the boards before the knowledge base.

THANKS to anyone who put thought into this today.

|||

Thanks for following up your own post. It prevents others from wasting their time trying to help you after you have solved the problem, and it helps others when you share your solution.

Does the RS standard edition / Enterprise edition has the same version number as the devel

Does the RS standard edition or Enterprise edition has the same version
number as developer edition? The latest version number from the developer
edition is 8.00.878.00. I want to know if other RS editions has the same
version number. This information is important to me because I want to make
sure our version checking program will work for all editions.
Thanks,
LianghongYes, the version number is the same for all editions of RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Guo, Lianghong" <lhguo@.fs.com> wrote in message
news:OJ8QXI8gEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Does the RS standard edition or Enterprise edition has the same version
> number as developer edition? The latest version number from the developer
> edition is 8.00.878.00. I want to know if other RS editions has the same
> version number. This information is important to me because I want to make
> sure our version checking program will work for all editions.
> Thanks,
> Lianghong
>

Does the number of CPU's returned

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, 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
> >
> >
> >