3 part question on Failover

1. If I have 2, seperate production SQL 2000 Servers, can I have 1 failover
server, that supports both production servers?
Example. sqlserver01 and sqlserver02 have differenct production databases.
sqlserver03 acts as a failover to either of the
servers
sqlserver02 fails, sqlserver03 picks up the traffic.
Or, does it have to be a 1 to 1 correlation, where I need 4 sqlservers to
support failover?
2. Do I have to have a license for the failover server?
3. Can I use a failover server to support other requests?
Example: sqlserver03 is failover for a production server. Can I run
reporting services against sqlserver03, so I don't put the additional load
on the production sqlserver? (Not to mention, it would always be up to date
with the latest data.)
Thanks.What technique did you plan to use for failover? Cluster, log shipping or replication? See
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx for elaboration.
Or in SQL Server 2005, you also have the option of Database mirroring.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message news:OOztrj$pFHA.1156@.TK2MSFTNGP12.phx.gbl...
> 1. If I have 2, seperate production SQL 2000 Servers, can I have 1 failover server, that supports
> both production servers?
> Example. sqlserver01 and sqlserver02 have differenct production databases.
> sqlserver03 acts as a failover to either of the servers
> sqlserver02 fails, sqlserver03 picks up the traffic.
> Or, does it have to be a 1 to 1 correlation, where I need 4 sqlservers to support failover?
> 2. Do I have to have a license for the failover server?
> 3. Can I use a failover server to support other requests?
> Example: sqlserver03 is failover for a production server. Can I run reporting services against
> sqlserver03, so I don't put the additional load on the production sqlserver? (Not to mention, it
> would always be up to date with the latest data.)
> Thanks.
>|||Good question, the intention is to go to SQL Server 2005 in the beginning to
mid 2006. So, the immediate needs will be Cluster, shipping or replication.
I don't believe I want clustering, and am not 100% clear between log
shipping and replication. I assume I want the log shipping, to have a
failover server, pickup the load, in the event of the primary server
failing. So, it needs to be real-time. (which I know 2005 will support
easily)
So, we'll say log shipping.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23ia7Zp$pFHA.3732@.TK2MSFTNGP09.phx.gbl...
> What technique did you plan to use for failover? Cluster, log shipping or
> replication? See
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
> for elaboration.
> Or in SQL Server 2005, you also have the option of Database mirroring.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message
> news:OOztrj$pFHA.1156@.TK2MSFTNGP12.phx.gbl...
>> 1. If I have 2, seperate production SQL 2000 Servers, can I have 1
>> failover server, that supports both production servers?
>> Example. sqlserver01 and sqlserver02 have differenct production
>> databases.
>> sqlserver03 acts as a failover to either of the
>> servers
>> sqlserver02 fails, sqlserver03 picks up the traffic.
>> Or, does it have to be a 1 to 1 correlation, where I need 4 sqlservers to
>> support failover?
>> 2. Do I have to have a license for the failover server?
>> 3. Can I use a failover server to support other requests?
>> Example: sqlserver03 is failover for a production server. Can I run
>> reporting services against sqlserver03, so I don't put the additional
>> load on the production sqlserver? (Not to mention, it would always be up
>> to date with the latest data.)
>> Thanks.
>|||Only cluster is real-time of the current options.
Log shipping will have a lag as much as the frequency you have between your log backup and restores.
And you need to kick out all the users for each restore. In short, don't use log shipping of you
want to do reporting of the standby database. Or use two databases, one for standby and one for
reporting. I strongly encourage you to read the HA paper I posted, as there are so many things to
consider...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message news:eMH5bu$pFHA.3104@.TK2MSFTNGP12.phx.gbl...
> Good question, the intention is to go to SQL Server 2005 in the beginning to mid 2006. So, the
> immediate needs will be Cluster, shipping or replication. I don't believe I want clustering, and
> am not 100% clear between log shipping and replication. I assume I want the log shipping, to have
> a failover server, pickup the load, in the event of the primary server failing. So, it needs to
> be real-time. (which I know 2005 will support easily)
> So, we'll say log shipping.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23ia7Zp$pFHA.3732@.TK2MSFTNGP09.phx.gbl...
>> What technique did you plan to use for failover? Cluster, log shipping or replication? See
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx for elaboration.
>> Or in SQL Server 2005, you also have the option of Database mirroring.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message news:OOztrj$pFHA.1156@.TK2MSFTNGP12.phx.gbl...
>> 1. If I have 2, seperate production SQL 2000 Servers, can I have 1 failover server, that
>> supports both production servers?
>> Example. sqlserver01 and sqlserver02 have differenct production databases.
>> sqlserver03 acts as a failover to either of the servers
>> sqlserver02 fails, sqlserver03 picks up the traffic.
>> Or, does it have to be a 1 to 1 correlation, where I need 4 sqlservers to support failover?
>> 2. Do I have to have a license for the failover server?
>> 3. Can I use a failover server to support other requests?
>> Example: sqlserver03 is failover for a production server. Can I run reporting services against
>> sqlserver03, so I don't put the additional load on the production sqlserver? (Not to mention,
>> it would always be up to date with the latest data.)
>> Thanks.
>>
>|||I'll read, thanks, but do you have a suggestion as to what I should
consider, based on my questions?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O2VHty$pFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Only cluster is real-time of the current options.
> Log shipping will have a lag as much as the frequency you have between
> your log backup and restores. And you need to kick out all the users for
> each restore. In short, don't use log shipping of you want to do reporting
> of the standby database. Or use two databases, one for standby and one for
> reporting. I strongly encourage you to read the HA paper I posted, as
> there are so many things to consider...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message
> news:eMH5bu$pFHA.3104@.TK2MSFTNGP12.phx.gbl...
>> Good question, the intention is to go to SQL Server 2005 in the beginning
>> to mid 2006. So, the immediate needs will be Cluster, shipping or
>> replication. I don't believe I want clustering, and am not 100% clear
>> between log shipping and replication. I assume I want the log shipping,
>> to have a failover server, pickup the load, in the event of the primary
>> server failing. So, it needs to be real-time. (which I know 2005 will
>> support easily)
>> So, we'll say log shipping.
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23ia7Zp$pFHA.3732@.TK2MSFTNGP09.phx.gbl...
>> What technique did you plan to use for failover? Cluster, log shipping
>> or replication? See
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
>> for elaboration.
>> Or in SQL Server 2005, you also have the option of Database mirroring.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message
>> news:OOztrj$pFHA.1156@.TK2MSFTNGP12.phx.gbl...
>> 1. If I have 2, seperate production SQL 2000 Servers, can I have 1
>> failover server, that supports both production servers?
>> Example. sqlserver01 and sqlserver02 have differenct production
>> databases.
>> sqlserver03 acts as a failover to either of the
>> servers
>> sqlserver02 fails, sqlserver03 picks up the traffic.
>> Or, does it have to be a 1 to 1 correlation, where I need 4 sqlservers
>> to support failover?
>> 2. Do I have to have a license for the failover server?
>> 3. Can I use a failover server to support other requests?
>> Example: sqlserver03 is failover for a production server. Can I run
>> reporting services against sqlserver03, so I don't put the additional
>> load on the production sqlserver? (Not to mention, it would always be
>> up to date with the latest data.)
>> Thanks.
>>
>>
>|||We don't have enough information. All methods has downsides, and I don't know how you prioritize
between the downsides of each method. Or the upsides either, of course. If you read the paper, you
can post back with additional information making the question a bit more ... qualified. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message news:Oqph34$pFHA.3572@.TK2MSFTNGP09.phx.gbl...
> I'll read, thanks, but do you have a suggestion as to what I should consider, based on my
> questions?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:O2VHty$pFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> Only cluster is real-time of the current options.
>> Log shipping will have a lag as much as the frequency you have between your log backup and
>> restores. And you need to kick out all the users for each restore. In short, don't use log
>> shipping of you want to do reporting of the standby database. Or use two databases, one for
>> standby and one for reporting. I strongly encourage you to read the HA paper I posted, as there
>> are so many things to consider...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message news:eMH5bu$pFHA.3104@.TK2MSFTNGP12.phx.gbl...
>> Good question, the intention is to go to SQL Server 2005 in the beginning to mid 2006. So, the
>> immediate needs will be Cluster, shipping or replication. I don't believe I want clustering, and
>> am not 100% clear between log shipping and replication. I assume I want the log shipping, to
>> have a failover server, pickup the load, in the event of the primary server failing. So, it
>> needs to be real-time. (which I know 2005 will support easily)
>> So, we'll say log shipping.
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
>> news:%23ia7Zp$pFHA.3732@.TK2MSFTNGP09.phx.gbl...
>> What technique did you plan to use for failover? Cluster, log shipping or replication? See
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx for elaboration.
>> Or in SQL Server 2005, you also have the option of Database mirroring.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message
>> news:OOztrj$pFHA.1156@.TK2MSFTNGP12.phx.gbl...
>> 1. If I have 2, seperate production SQL 2000 Servers, can I have 1 failover server, that
>> supports both production servers?
>> Example. sqlserver01 and sqlserver02 have differenct production databases.
>> sqlserver03 acts as a failover to either of the servers
>> sqlserver02 fails, sqlserver03 picks up the traffic.
>> Or, does it have to be a 1 to 1 correlation, where I need 4 sqlservers to support failover?
>> 2. Do I have to have a license for the failover server?
>> 3. Can I use a failover server to support other requests?
>> Example: sqlserver03 is failover for a production server. Can I run reporting services
>> against sqlserver03, so I don't put the additional load on the production sqlserver? (Not to
>> mention, it would always be up to date with the latest data.)
>> Thanks.
>>
>>
>|||"Kevin Antel" wrote:
> 1. If I have 2, seperate production SQL 2000 Servers, can I have 1 failover
> server, that supports both production servers?
> Example. sqlserver01 and sqlserver02 have differenct production databases.
> sqlserver03 acts as a failover to either of the
> servers
> sqlserver02 fails, sqlserver03 picks up the traffic.
> Or, does it have to be a 1 to 1 correlation, where I need 4 sqlservers to
> support failover?
> 2. Do I have to have a license for the failover server?
> 3. Can I use a failover server to support other requests?
> Example: sqlserver03 is failover for a production server. Can I run
> reporting services against sqlserver03, so I don't put the additional load
> on the production sqlserver? (Not to mention, it would always be up to date
> with the latest data.)
> Thanks.
>
>|||Sorry the blank reply...didn't realize they had profile verification and
reply on the same form.
I have a very similar scenario as Kevin, but only need that part 2 of his
question answered. Does the failover server require a seperate license?
Printable or downloadable doucumention would be greatly appreciated.
If I find the answer through any other means, I will post it here.
"Brian Norris" wrote:
>
> "Kevin Antel" wrote:
> > 1. If I have 2, seperate production SQL 2000 Servers, can I have 1 failover
> > server, that supports both production servers?
> >
> > Example. sqlserver01 and sqlserver02 have differenct production databases.
> > sqlserver03 acts as a failover to either of the
> > servers
> >
> > sqlserver02 fails, sqlserver03 picks up the traffic.
> >
> > Or, does it have to be a 1 to 1 correlation, where I need 4 sqlservers to
> > support failover?
> >
> > 2. Do I have to have a license for the failover server?
> >
> > 3. Can I use a failover server to support other requests?
> >
> > Example: sqlserver03 is failover for a production server. Can I run
> > reporting services against sqlserver03, so I don't put the additional load
> > on the production sqlserver? (Not to mention, it would always be up to date
> > with the latest data.)
> >
> > Thanks.
> >
> >
> >

2nd Newbie question with Element-centric Mapping and Relational Tables

Actually, have another problem, it's appearing it's concatinating the items together. Here is the actual example. I think this is all being generated from VS.NET, so I'm not sure what some of the name spaces and attributes are for. Is there any way to make them not concatinate like the first example? Thanks a million.

DECLARE @.idoc int

DECLARE @.doc varchar(5000)

SET @.doc ='

<RS_DN_Objective xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<mDocType>2</mDocType>

<SectionID>O0</SectionID>

<IsLoaded>true</IsLoaded>

<sTreat>

<mArr>

<anyType xsi:type="xsdtring">Modality - IFC E-Stim</anyType>

<anyType xsi:type="xsdtring">Hamstring Curl Resisted (Sitting)</anyType>

<anyType xsi:type="xsdtring">Hip Abduction Adduction with Extended Knee (Sup</anyType>

<anyType xsi:type="xsdtring">Hip Abduction Adduction with Knee Flexion (Supine)</anyType>

</mArr>

</sTreat>

</RS_DN_Objective>

'

EXEC sp_xml_preparedocument @.idoc OUTPUT, @.doc

SELECT *

FROM OPENXML (@.idoc, 'RS_DN_Objective/sTreat/mArr',2)

WITH (anyType VARCHAR(100) '.')

EXEC sp_xml_removedocument @.idoc

My Results Are:

'

'anyType

'Modality - IFC E-Stim Hamstring Curl Resisted (Sitting) Hip Abduction Adduction with Extended Kn

'

Are you using SQL 2000 or SQL 2005?|||

Try changing your SELECT statement to something like:

Code Snippet

SELECT anyType

FROM OPENXML (@.idoc, 'RS_DN_Objective/sTreat/mArr/anyType',2)

WITH (anyType VARCHAR(100) '.')

/*

anyType

Modality - IFC E-Stim

Hamstring Curl Resisted (Sitting)

Hip Abduction Adduction with Extended Knee (Sup

Hip Abduction Adduction with Knee Flexion (Supine)

*/

|||Sweet, this is a totally cool feature, this worked perfect on 2005. Thanks again for your help, I don't think I'd have gotten it.|||

Another alternative is something like:

Code Snippet

declare @.doc xml

SET @.doc ='

<RS_DN_Objective xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<mDocType>2</mDocType>

<SectionID>O0</SectionID>

<IsLoaded>true</IsLoaded>

<sTreat>

<mArr>

<anyType xsi:type="xsdtring">Modality - IFC E-Stim</anyType>

<anyType xsi:type="xsdtring">Hamstring Curl Resisted (Sitting)</anyType>

<anyType xsi:type="xsdtring">Hip Abduction Adduction with Extended Knee (Sup</anyType>

<anyType xsi:type="xsdtring">Hip Abduction Adduction with Knee Flexion (Supine)</anyType>

</mArr>

</sTreat>

</RS_DN_Objective>

'

select t.value('.', 'varchar(100)') as anyType

from @.doc.nodes('RS_DN_Objective/sTreat/mArr/anyType') as x(t)

/*

anyType

Modality - IFC E-Stim

Hamstring Curl Resisted (Sitting)

Hip Abduction Adduction with Extended Knee (Sup

Hip Abduction Adduction with Knee Flexion (Supine)

*/

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-Tom
hi Tom,
Tom Celica wrote:
> In the MSDE Edition of Sql Server 2000 there is a limit of 25
> connections. What is the definition of a "connection"? For
> example, if I create a connection pool of 5 connections in an
> application, does that count as 5 against the 25?
there's not such a limit of "25 connection"... this magic number is just a
guess about the probably supported load of an MSDE instance.. and it fo
course is influenced by your architectural design, both within the db and
the app...
please have a look at
http://msdn.microsoft.com/library/?u...asp?frame=true
for all available info about the built in Workload Governor..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-Tom
I didn't know there was a hard limit but the soft limit was actually 5.
Over 5 concurrent connections and it would start to throttle back your
performance. I don't know for sure but the license probably states a limit
of 5 concurrent connections. It was not intended to be used for that many
connections. That is what the standard edition is for. A connection is
anytime someone is connected to the server. If the pool has 5 open
connections then it is 5 connections.
Andrew J. Kelly SQL MVP
"Tom Celica" <tom@.dontreply.com> wrote in message
news:V1%Ae.1617$_%4.505@.newssvr14.news.prodigy.com ...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>
|||AFAIK there is no such limit. What makes you say that the limit is 25?
MSDE is optimized for 5 connections or less so if you want 25
connections you should probably be considering Standard or Workgroup
edition.
David Portas
SQL Server MVP

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-TomIndependently answered to many of the independently posted questions.
Please refrain from posting the same question independently to multiple
newsgroups.
"Tom Celica" <tom@.dontreply.com> wrote in message
news:s3%Ae.1619$_%4.824@.newssvr14.news.prodigy.com...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-TomI didn't know there was a hard limit but the soft limit was actually 5.
Over 5 concurrent connections and it would start to throttle back your
performance. I don't know for sure but the license probably states a limit
of 5 concurrent connections. It was not intended to be used for that many
connections. That is what the standard edition is for. A connection is
anytime someone is connected to the server. If the pool has 5 open
connections then it is 5 connections.
Andrew J. Kelly SQL MVP
"Tom Celica" <tom@.dontreply.com> wrote in message
news:V1%Ae.1617$_%4.505@.newssvr14.news.prodigy.com...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>|||AFAIK there is no such limit. What makes you say that the limit is 25?
MSDE is optimized for 5 connections or less so if you want 25
connections you should probably be considering Standard or Workgroup
edition.
David Portas
SQL Server MVP
--

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-Tom
Independently answered to many of the independently posted questions.
Please refrain from posting the same question independently to multiple
newsgroups.
"Tom Celica" <tom@.dontreply.com> wrote in message
news:s3%Ae.1619$_%4.824@.newssvr14.news.prodigy.com ...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-TomIndependently answered to many of the independently posted questions.
Please refrain from posting the same question independently to multiple
newsgroups.
"Tom Celica" <tom@.dontreply.com> wrote in message
news:s3%Ae.1619$_%4.824@.newssvr14.news.prodigy.com...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>

2005 Table Partitioning

Hi - can anyone tell me how I can query which filegroup a particular
partition number belongs to'
For example I have a date range partition function & the query:
SELECT PartitionNo = $partition.DateRangePFN ('20070401')
Tells me this date would be placed in partition number 2 which should be in
a Filegroup called "April" but I just wanted to check that partition 2 is
actually mapped to filegroup April & I can't see how to do it!!
Thanks!!
MikeOn Jun 8, 3:56 pm, "Michael Knee" <mike...@.hotmail.com> wrote:
> Hi - can anyone tell me how I can query which filegroup a particular
> partition number belongs to'
> For example I have a date range partition function & the query:
> SELECT PartitionNo = $partition.DateRangePFN ('20070401')
> Tells me this date would be placed in partition number 2 which should be in
> a Filegroup called "April" but I just wanted to check that partition 2 is
> actually mapped to filegroup April & I can't see how to do it!!
> Thanks!!
> Mike
select
prv.boundary_id,
prv.value,
fg.name
from
sys.partition_range_values prv
inner join
sys.partition_functions pf on prv.function_id = pf.function_id
inner join
sys.destination_data_spaces dds on dds.destination_id =prv.boundary_id
inner join
sys.filegroups fg on fg.data_space_id = dds.data_space_id
where
pf.name = 'PF_DateRange'
and
prv.boundary_id = $partition.PF_DateRange('20050814')
See http://weblogs.sqlteam.com/dmauri/archive/2005/08/20/7593.aspx|||Exactly what I was after & excellent blog link as well - Thank You!
Mike
"M A Srinivas" <masri999@.gmail.com> wrote in message
news:1181303483.375856.68170@.r19g2000prf.googlegroups.com...
> On Jun 8, 3:56 pm, "Michael Knee" <mike...@.hotmail.com> wrote:
>> Hi - can anyone tell me how I can query which filegroup a particular
>> partition number belongs to'
>> For example I have a date range partition function & the query:
>> SELECT PartitionNo = $partition.DateRangePFN ('20070401')
>> Tells me this date would be placed in partition number 2 which should be
>> in
>> a Filegroup called "April" but I just wanted to check that partition 2 is
>> actually mapped to filegroup April & I can't see how to do it!!
>> Thanks!!
>> Mike
> select
> prv.boundary_id,
> prv.value,
> fg.name
> from
> sys.partition_range_values prv
> inner join
> sys.partition_functions pf on prv.function_id = pf.function_id
> inner join
> sys.destination_data_spaces dds on dds.destination_id => prv.boundary_id
> inner join
> sys.filegroups fg on fg.data_space_id = dds.data_space_id
> where
> pf.name = 'PF_DateRange'
> and
> prv.boundary_id = $partition.PF_DateRange('20050814')
>
> See http://weblogs.sqlteam.com/dmauri/archive/2005/08/20/7593.aspx
>

2005 Table Partitioning

Hi - can anyone tell me how I can query which filegroup a particular
partition number belongs to'
For example I have a date range partition function & the query:
SELECT PartitionNo = $partition.DateRangePFN ('20070401')
Tells me this date would be placed in partition number 2 which should be in
a Filegroup called "April" but I just wanted to check that partition 2 is
actually mapped to filegroup April & I can't see how to do it!!
Thanks!!
MikeOn Jun 8, 3:56 pm, "Michael Knee" <mike...@.hotmail.com> wrote:
> Hi - can anyone tell me how I can query which filegroup a particular
> partition number belongs to'
> For example I have a date range partition function & the query:
> SELECT PartitionNo = $partition.DateRangePFN ('20070401')
> Tells me this date would be placed in partition number 2 which should be i
n
> a Filegroup called "April" but I just wanted to check that partition 2 is
> actually mapped to filegroup April & I can't see how to do it!!
> Thanks!!
> Mike
select
prv.boundary_id,
prv.value,
fg.name
from
sys.partition_range_values prv
inner join
sys.partition_functions pf on prv.function_id = pf.function_id
inner join
sys.destination_data_spaces dds on dds.destination_id =
prv.boundary_id
inner join
sys.filegroups fg on fg.data_space_id = dds.data_space_id
where
pf.name = 'PF_DateRange'
and
prv.boundary_id = $partition.PF_DateRange('20050814')
See http://weblogs.sqlteam.com/dmauri/a...08/20/7593.aspx|||Exactly what I was after & excellent blog link as well - Thank You!
Mike
"M A Srinivas" <masri999@.gmail.com> wrote in message
news:1181303483.375856.68170@.r19g2000prf.googlegroups.com...
> On Jun 8, 3:56 pm, "Michael Knee" <mike...@.hotmail.com> wrote:
> select
> prv.boundary_id,
> prv.value,
> fg.name
> from
> sys.partition_range_values prv
> inner join
> sys.partition_functions pf on prv.function_id = pf.function_id
> inner join
> sys.destination_data_spaces dds on dds.destination_id =
> prv.boundary_id
> inner join
> sys.filegroups fg on fg.data_space_id = dds.data_space_id
> where
> pf.name = 'PF_DateRange'
> and
> prv.boundary_id = $partition.PF_DateRange('20050814')
>
> See http://weblogs.sqlteam.com/dmauri/a...08/20/7593.aspx
>

2005 FT Indexing: what about additional languages?

I see sqlserver2005 has no many languages which were announced.
For example I need arabic as the language for indexing and search. I dont
see it in the language list.No wordbreaker.
Any ideas?
Oleg,
Yes... While Arabic is not in the list of officially supported languages,
you can download the Microsoft Arabic Word-Breaker (Arabic Search Engine) -
Beta from: http://www.microsoft.com/middleeast/.../beta/search/. While
I've not yet tested this with SQL Server 2005, it should work for you!
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Oleg Cherkasenko" <oleg@.opel.com.ua> wrote in message
news:#H0PbO9eFHA.2128@.TK2MSFTNGP15.phx.gbl...
> I see sqlserver2005 has no many languages which were announced.
> For example I need arabic as the language for indexing and search. I dont
> see it in the language list.No wordbreaker.
> Any ideas?
>
>
>
|||I would try the Turkish word breaker.
You might also want to look at this:
http://download.microsoft.com/downlo...0-%20Final.doc
I am not sure if you will be able to use this in SQL 2005.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Oleg Cherkasenko" <oleg@.opel.com.ua> wrote in message
news:%23H0PbO9eFHA.2128@.TK2MSFTNGP15.phx.gbl...
> I see sqlserver2005 has no many languages which were announced.
> For example I need arabic as the language for indexing and search. I dont
> see it in the language list.No wordbreaker.
> Any ideas?
>
>
>

2005 BoL

Hi

Why is it when I search BoL or click on links on the index I keep getting SQL Server Mobile help pages rather than (for example) the Transact SQL help pages that I want. I can usually find a link at the bottom of the page but is there any way to filter this stuff out in the first place?

Ta!where are you searching? google? msdn? or BOL on your own computer?|||BoL on my pc|||For example - ALTER TABLE in the index - I get a link that, when clicked, takes me to ALTER TABLE (SQL Server Mobile). Down the bottom there is a link to ALTER TABLE (Transact SQL). I want that one first :)|||Ok - filter by database engine rather than SQL Server 2005 and I don't appear to get the mobile stuff. Not sure what else I might lose too though...|||maybe this will help:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=647689&SiteID=1|||Jezemine - thank you. Another concise and accurate post :)

Out of curiosity, did you know about that already or (to my shame) did you just google because I did not find that one... :o

Anyway - will try in work tomoz.|||i had a vague recollection of seeing the post, but I didn't have the link memorized. ;)

so I resorted to google.

fyi, here's the search I did: http://www.google.com/search?q=remove+mobile+from+bol|||fyi, here's the search I did: http://www.google.com/search?q=remove+mobile+from+bolOh....





Dear :o

N00bie Poots|||see what you get for http://www.google.com/search?q=turn+off+activex and http://www.google.com/search?q=turn+off+javascript

;)|||Forgive my ignorance - what is the relationship?|||nothing, it's just that i happened to somehow end up as #1 or #2 on the search results for both those queries, when you'd think a microsoft page might come up ahead of me

or maybe not

sorry for the dissonance|||Lol - I read the culminated-in-the-SQL-Consultant-moniker article some time ago.
Are you just showing off?

Anyway - ActiveX settings checked and they are OFF OFF OFF :D

BTW - familiar with cognitive dissonance - curiously never come across it before without the cognitive bit.|||Are you just showing off?ah caint hep it!!