collation conflict resolution

I have a number of databases with quite similar structure, but with
different COLLATION
settings. Unfortunately when the structure (including keys and constraints)
has been created
no one took care of COLLATION at all.
At the moment statements like:
--
SELECT
. . .
(case FieldA
when 1 then (select Source1 from Table1 WHERE ...)
when 2 then (select Source2 from Table2 WHERE ...)
end) as Result,
--
gives COLLATION CONFLICT because Table1 and Table2 have different collation
setting.
But for a half of number of tables it works fine.
What aa I asking about: How to change COLLATION SETTING "on fly" for
different tables.fields ?
May be someone knows any fancy tools or "script wizards" to do so?
Please don't waste this newsgroup space with offering me to insert "COLLATE
DATABASE_DEFAULT"
to each statement which causes such problem. Ok?
Thanks a lot!
GnumHi,
CREATE VIEW FROM Table2
ADD COLLATE AFTER EACH FIELDS.
> when 1 then (select Source1 from Table1 WHERE ...)
(select Source1 from View1 WHERE ...)
--
SHINICHI YONEDA MXL04371@.nifty.ne.jp
Microsoft Most Valuable Professional
MVP for SQL Server 2002-2004
"Gnum" <no-email@.mail.boo> wrote in message
news:OTaDHbgvDHA.1340@.TK2MSFTNGP09.phx.gbl...
> I have a number of databases with quite similar structure, but with
> different COLLATION
> settings. Unfortunately when the structure (including keys and
constraints)
> has been created
> no one took care of COLLATION at all.
> At the moment statements like:
> --
> SELECT
> . . .
> (case FieldA
> when 1 then (select Source1 from Table1 WHERE ...)
> when 2 then (select Source2 from Table2 WHERE ...)
> end) as Result,
> --
> gives COLLATION CONFLICT because Table1 and Table2 have different
collation
> setting.
> But for a half of number of tables it works fine.
> What aa I asking about: How to change COLLATION SETTING "on fly" for
> different tables.fields ?
> May be someone knows any fancy tools or "script wizards" to do so?
> Please don't waste this newsgroup space with offering me to insert
"COLLATE
> DATABASE_DEFAULT"
> to each statement which causes such problem. Ok?
>
> Thanks a lot!
> Gnum
>|||Thank you very much for so big
MISUNDERSTANDING!
Have you ever read the question up to the end?
I've written there "
> > Please don't waste this newsgroup space with offering me to insert
> "COLLATE
> > DATABASE_DEFAULT"
> > to each statement which causes such problem. Ok?"
I need a help, but not a collection of stupid wisdom-like erudition esseys!
Thanks!
"Shinichi Yoneda" <mxl04371@.nifty.ne.jp> wrote in message
news:OOcY6TlvDHA.2880@.tk2msftngp13.phx.gbl...
> Hi,
> CREATE VIEW FROM Table2
> ADD COLLATE AFTER EACH FIELDS.
> > when 1 then (select Source1 from Table1 WHERE ...)
> (select Source1 from View1 WHERE ...)
> --
> SHINICHI YONEDA MXL04371@.nifty.ne.jp
> Microsoft Most Valuable Professional
> MVP for SQL Server 2002-2004
> "Gnum" <no-email@.mail.boo> wrote in message
> news:OTaDHbgvDHA.1340@.TK2MSFTNGP09.phx.gbl...
> > I have a number of databases with quite similar structure, but with
> > different COLLATION
> > settings. Unfortunately when the structure (including keys and
> constraints)
> > has been created
> > no one took care of COLLATION at all.
> > At the moment statements like:
> > --
> > SELECT
> > . . .
> > (case FieldA
> > when 1 then (select Source1 from Table1 WHERE ...)
> > when 2 then (select Source2 from Table2 WHERE ...)
> > end) as Result,
> > --
> > gives COLLATION CONFLICT because Table1 and Table2 have different
> collation
> > setting.
> > But for a half of number of tables it works fine.
> >
> > What aa I asking about: How to change COLLATION SETTING "on fly" for
> > different tables.fields ?
> > May be someone knows any fancy tools or "script wizards" to do so?
> >
> > Please don't waste this newsgroup space with offering me to insert
> "COLLATE
> > DATABASE_DEFAULT"
> > to each statement which causes such problem. Ok?
> >
> >
> > Thanks a lot!
> >
> > Gnum
> >
> >
>

Collation Change

I need to change the collation of a database (Including all the tables,
columns e.t.c) on a SQL Server 2005 SP2. Is there an easy way to do this
other than dropping indexes, creating a script for everything and running it ?
Thanks.
DXC
It is not an easy task. In my epxerience you will be better of re-creating
a database from scratch and import all the data.
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:8BBFC84E-6048-4636-A903-8EE7E6EA6FE5@.microsoft.com...
>I need to change the collation of a database (Including all the tables,
> columns e.t.c) on a SQL Server 2005 SP2. Is there an easy way to do this
> other than dropping indexes, creating a script for everything and running
> it ?
>
> Thanks.
|||That's what I thought...........Thanks.................
"Uri Dimant" wrote:

> DXC
> It is not an easy task. In my epxerience you will be better of re-creating
> a database from scratch and import all the data.
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:8BBFC84E-6048-4636-A903-8EE7E6EA6FE5@.microsoft.com...
>
>
|||I had cause to do this a while back and came across this .Net
application that generates a script to change the collation of all
objects in a database.
http://www.codeproject.com/KB/database/ChangeCollation.aspx
Be warned, you should backup your database first, take all reasonable
precautions. The databse script can take some time to run on large
databases. I'm not sure that CodeProject waranty the code or the
method in any way.
David.
|||Thanks David............This one says "SQL Server 2000 Collation Changer".
I don't know if it would work on SQL Server 2005 without any issues but I'll
take a look at it.
"David Halligan" wrote:

> I had cause to do this a while back and came across this .Net
> application that generates a script to change the collation of all
> objects in a database.
> http://www.codeproject.com/KB/database/ChangeCollation.aspx
> Be warned, you should backup your database first, take all reasonable
> precautions. The databse script can take some time to run on large
> databases. I'm not sure that CodeProject waranty the code or the
> method in any way.
> David.
>

Collation Change

I need to change the collation of a database (Including all the tables,
columns e.t.c) on a SQL Server 2005 SP2. Is there an easy way to do this
other than dropping indexes, creating a script for everything and running it ?
Thanks.DXC
It is not an easy task. In my epxerience you will be better of re-creating
a database from scratch and import all the data.
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:8BBFC84E-6048-4636-A903-8EE7E6EA6FE5@.microsoft.com...
>I need to change the collation of a database (Including all the tables,
> columns e.t.c) on a SQL Server 2005 SP2. Is there an easy way to do this
> other than dropping indexes, creating a script for everything and running
> it ?
>
> Thanks.|||I had cause to do this a while back and came across this .Net
application that generates a script to change the collation of all
objects in a database.
http://www.codeproject.com/KB/database/ChangeCollation.aspx
Be warned, you should backup your database first, take all reasonable
precautions. The databse script can take some time to run on large
databases. I'm not sure that CodeProject waranty the code or the
method in any way.
David.|||That's what I thought...........Thanks.................
"Uri Dimant" wrote:
> DXC
> It is not an easy task. In my epxerience you will be better of re-creating
> a database from scratch and import all the data.
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:8BBFC84E-6048-4636-A903-8EE7E6EA6FE5@.microsoft.com...
> >I need to change the collation of a database (Including all the tables,
> > columns e.t.c) on a SQL Server 2005 SP2. Is there an easy way to do this
> > other than dropping indexes, creating a script for everything and running
> > it ?
> >
> >
> > Thanks.
>
>|||Thanks David............This one says "SQL Server 2000 Collation Changer".
I don't know if it would work on SQL Server 2005 without any issues but I'll
take a look at it.
"David Halligan" wrote:
> I had cause to do this a while back and came across this .Net
> application that generates a script to change the collation of all
> objects in a database.
> http://www.codeproject.com/KB/database/ChangeCollation.aspx
> Be warned, you should backup your database first, take all reasonable
> precautions. The databse script can take some time to run on large
> databases. I'm not sure that CodeProject waranty the code or the
> method in any way.
> David.
>

Collation Change

I need to change the collation of a database (Including all the tables,
columns e.t.c) on a SQL Server 2005 SP2. Is there an easy way to do this
other than dropping indexes, creating a script for everything and running it
?
Thanks.DXC
It is not an easy task. In my epxerience you will be better of re-creating
a database from scratch and import all the data.
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:8BBFC84E-6048-4636-A903-8EE7E6EA6FE5@.microsoft.com...
>I need to change the collation of a database (Including all the tables,
> columns e.t.c) on a SQL Server 2005 SP2. Is there an easy way to do this
> other than dropping indexes, creating a script for everything and running
> it ?
>
> Thanks.|||That's what I thought...........Thanks.................
"Uri Dimant" wrote:

> DXC
> It is not an easy task. In my epxerience you will be better of re-creatin
g
> a database from scratch and import all the data.
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:8BBFC84E-6048-4636-A903-8EE7E6EA6FE5@.microsoft.com...
>
>|||I had cause to do this a while back and came across this .Net
application that generates a script to change the collation of all
objects in a database.
http://www.codeproject.com/KB/datab...eCollation.aspx
Be warned, you should backup your database first, take all reasonable
precautions. The databse script can take some time to run on large
databases. I'm not sure that CodeProject waranty the code or the
method in any way.
David.|||Thanks David............This one says "SQL Server 2000 Collation Changer"
.
I don't know if it would work on SQL Server 2005 without any issues but I'll
take a look at it.
"David Halligan" wrote:

> I had cause to do this a while back and came across this .Net
> application that generates a script to change the collation of all
> objects in a database.
> http://www.codeproject.com/KB/datab...eCollation.aspx
> Be warned, you should backup your database first, take all reasonable
> precautions. The databse script can take some time to run on large
> databases. I'm not sure that CodeProject waranty the code or the
> method in any way.
> David.
>

Clustering of the Data

Hi Everybody !
I am working on Clustering of the data.I have database of the dictionary including Antonyms and Synonyms.
I have to detect the sense and throw a output for the relevant words [ you can say including the Antonyms].
please tell me how to cluster the data so that it can be more efficient and it can throw more relevant words.

For expamles : if i put the input " Hotel"
it can throw "public house, resort, roadhouse, rooming house, scratch crib, spa, tavern"

like more near to these words....

Please help me to find the good algorithm.

Regards,You must be using Wordnet for extracting the semantic relation among words. If yes, then, Wordnet, would directly give you the sense and related terms.
You may also use the "Cosine Similarity" Algorithm, for clustering.

Clustered SQL Servers and chkdsk?

Hi all,
We have 2 SQL Server 2000's in a cluster at work, we started running some
regular server maintenance a few ws back including the basics like defrag
etc...one of the things I was also keen to do was to run chkdsk /F after we
had done the defrags and reboot the servers, I assumed we'd be able to do
this on the passive server, then when it was back up, fail over the active
server and then run it on that one also. Of course, what I failed to
consider was the fact that the shared E drive is a resource which only
'exists' on the active server, so when I fail the active server over, the E
drive goes with it.
From memory the E drive is raid'ed and a colleague mentioned that because of
this there might not be any benefit running a chkdsk anyway, I was hoping to
confirm this, or find a way of chkdsk'ing the shared resource - the only
option I can see at present is to dismount the drive and run it on the
active server but this would then obviously involve some down time, plus
I've never dismounted a drive, and certainly not one being used excessively
like ours on the SQL Server, as a result I have no idea of the consequences.
Any advice would be appreciated - I was previously of the understanding that
running defrag on drives that have large quantities of I/O requests was a
good thing to help reduce the movement of the head in the disc, thus
inproving performance (if only slightly). I assumed chkdsk would be another
worthy program to run (as we do on the other servers, web and the like).
Regards
RobWhen you run chkdsk you're reordering the data on the physical disk. This
would help for most file types. However, I don't think you would gain much
if the drive is striped. On also, on db creation, the file is preallocated
(i.e. taken up whatever the specified size). If the disk is fragmented at
that time, the file is already fragmented. You might gain some perf if you
take the database offline and do chkdsk.
Yup, without a true shared clustered filesystem (i.e. with MSCS/Veritas/etc)
the shared disk is under control of the active node.
Below is a very good whitepaper on fragmentation and what you can do in
regards to sqlserver. I highly recommend a good read.
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
-oj
"Rob Meade" <robb.meade@.NO-SPAM.kingswoodweb.net> wrote in message
news:OzCId.16421$GG1.8815@.text.news.blueyonder.co.uk...
> Hi all,
> We have 2 SQL Server 2000's in a cluster at work, we started running some
> regular server maintenance a few ws back including the basics like
> defrag
> etc...one of the things I was also keen to do was to run chkdsk /F after
> we
> had done the defrags and reboot the servers, I assumed we'd be able to do
> this on the passive server, then when it was back up, fail over the active
> server and then run it on that one also. Of course, what I failed to
> consider was the fact that the shared E drive is a resource which only
> 'exists' on the active server, so when I fail the active server over, the
> E
> drive goes with it.
> From memory the E drive is raid'ed and a colleague mentioned that because
> of
> this there might not be any benefit running a chkdsk anyway, I was hoping
> to
> confirm this, or find a way of chkdsk'ing the shared resource - the only
> option I can see at present is to dismount the drive and run it on the
> active server but this would then obviously involve some down time, plus
> I've never dismounted a drive, and certainly not one being used
> excessively
> like ours on the SQL Server, as a result I have no idea of the
> consequences.
> Any advice would be appreciated - I was previously of the understanding
> that
> running defrag on drives that have large quantities of I/O requests was a
> good thing to help reduce the movement of the head in the disc, thus
> inproving performance (if only slightly). I assumed chkdsk would be
> another
> worthy program to run (as we do on the other servers, web and the like).
> Regards
> Rob
>|||"oj" wrote ...

> When you run chkdsk you're reordering the data on the physical disk. This
> would help for most file types. However, I don't think you would gain much
> if the drive is striped.
Hi Oj,
I believe our RAID'd discs are raid5 if that makes a difference? (ie, not
striped)

> Yup, without a true shared clustered filesystem (i.e. with
MSCS/Veritas/etc)
> the shared disk is under control of the active node.
ta for the confirmation.

> Below is a very good whitepaper on fragmentation and what you can do in
> regards to sqlserver. I highly recommend a good read.
>
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
Cheers, will take a read-ee now :o)
Regards
Rob