Showing posts with label duplicate. Show all posts
Showing posts with label duplicate. Show all posts

Wednesday, March 28, 2012

multiple instances in 1 cluster pair (please advise)

Dear all,
I tried to post this question yesterday but seems like didnt get thru,
so I will again. If duplicate, please ignore this.
Currently there I have a live production SQL server cluster (SQL2000) in
non-Case sensitive mode. The server is rather powerful with 8 CPU. Now
only running at 20% cap. Recently we bought a new software and required
the db to be in Case sensitive mode.
It was recommended to create a new instance for the new s/w. Can anyone
help to advise on the following
1) If I create 1 more new instance on the existing DB, how do I
configure it for failover? I cant find any guide to configure the new
instance for failover. Any link to recommend?
2) Any impact I need to note?
Thank you,
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You don't need a new instance - just a new database. SQL Server 2000 can
have multiple databases, each with its own collation.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Francis Ang" <angcheek@.starhub.net.sg> wrote in message
news:%23Q8AqPn3EHA.3380@.TK2MSFTNGP09.phx.gbl...
Dear all,
I tried to post this question yesterday but seems like didnt get thru,
so I will again. If duplicate, please ignore this.
Currently there I have a live production SQL server cluster (SQL2000) in
non-Case sensitive mode. The server is rather powerful with 8 CPU. Now
only running at 20% cap. Recently we bought a new software and required
the db to be in Case sensitive mode.
It was recommended to create a new instance for the new s/w. Can anyone
help to advise on the following
1) If I create 1 more new instance on the existing DB, how do I
configure it for failover? I cant find any guide to configure the new
instance for failover. Any link to recommend?
2) Any impact I need to note?
Thank you,
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi Tom,
Thank you for your reply. I have tried that, although it is working, the
software vendor does not support that configuration. They recommended
new instance. Not sure why either.
Regards,
Francis
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Sounds like the vendor doesn't have much experience with SQL Server 2000.
Well, if they insist, then you're forced to install the extra instance. As
long as you have enough memory and CPU power, then you'll be OK. It's just
that you have to manage two instances, instead of one.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Diamond Star" <Diamond@.Star.com> wrote in message
news:u6hW3Pr3EHA.3316@.tk2msftngp13.phx.gbl...
Hi Tom,
Thank you for your reply. I have tried that, although it is working, the
software vendor does not support that configuration. They recommended
new instance. Not sure why either.
Regards,
Francis
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||But Tom, the DBA dont know how to install a additional instance over the
existing clustered servers. Do you have any guide or link to recommend?
I would really appreciate your help.
Thank you,
Francis Ang
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||It's not that difficult. Just install from the CD as you did for the first
instance. However, the second instance will be a named instance. For
example, if the first instance was called MYSQLSERVER, then you can call the
second one MYSQLSERVER\INST2. The BOL have all the details.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Diamond Star" <Diamond@.Star.com> wrote in message
news:eezVUm33EHA.3336@.TK2MSFTNGP11.phx.gbl...
But Tom, the DBA dont know how to install a additional instance over the
existing clustered servers. Do you have any guide or link to recommend?
I would really appreciate your help.
Thank you,
Francis Ang
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi Tom,
THanks for the advise. I will inform the DBA of this. If you dont mind,
I have a last question. Do the DBA set up the Clustering services for
the new instance just like the first instance.
THank you for the help,
Francis
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Since Cluster Services are already set up, you won't need to set it up
again.
One more thing I should add is that the new SQL Server instance will need
its own disks, independent from the first SQL service. Here's what I mean.
Let's say you have 2 physical nodes - NODE1 and NODE2, each with a drive C:
(nonclustered). You have 2 SQL Server instances - SQL1 and SQL2. Both of
these will need a drive for data and another for logs. Thus, you could have
SQL1 with drive D: and E: and SQL2 with drive F: and G:.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Diamond Star" <Diamond@.Star.com> wrote in message
news:unPVf8B4EHA.2404@.TK2MSFTNGP14.phx.gbl...
Hi Tom,
THanks for the advise. I will inform the DBA of this. If you dont mind,
I have a last question. Do the DBA set up the Clustering services for
the new instance just like the first instance.
THank you for the help,
Francis
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Wednesday, March 21, 2012

multiple field statment

I have a table that has 9 fields.
in some cases a record may almost be a duplicate of another record except
for one of the fields.
so I was thinking I need to write a statment to where I have to say what
each field equals, but I haven't had any luck
here is what I tried.
Select * from MyTable where field1 = "this" and field2 = "a" and field3 =
"test"
How do I write that statement correctly?
Thanks
Replace " with '. SQL uses a single quote to delimit literal strings rather
than a double quote. If that doesn't solve your problem then please tell us
exactly the wording of any error message you are getting.
David Portas
SQL Server MVP
sql

multiple field statment

I have a table that has 9 fields.
in some cases a record may almost be a duplicate of another record except
for one of the fields.
so I was thinking I need to write a statment to where I have to say what
each field equals, but I haven't had any luck
here is what I tried.
Select * from MyTable where field1 = "this" and field2 = "a" and field3 = "test"
How do I write that statement correctly'
ThanksReplace " with '. SQL uses a single quote to delimit literal strings rather
than a double quote. If that doesn't solve your problem then please tell us
exactly the wording of any error message you are getting.
--
David Portas
SQL Server MVP
--

Multiple DISTINCTS?

Hello,
Is it possible to constrain a query so that I receive only the duplicate rows (all column data matches)? For example:
SELECT DISTINCT COL1,
DISTINCT COL2,DISTINCT COL3
FROM TABLE
I did a search on multiple DISTINCTS but came up with nothing. Thanks in advance.DISTINCT applys to the whole row of the result set, not individual columns of it. When you do aSELECT DISTINCT col1, col2, col3
FROM myTableyou will get one row for any given combination of col1, col2, and col3. You can use DISTINCT within aggragate functions to get aggrigates of the unique values, but when applied against a result set, DISTINCT applies to the whole set (row).

-PatP|||uh, huh?

SELECT DISTINCT Col1, Col2, Col3

Will give you 1 unique row..

You want to only see dups?

SELECT Col1, Col2, Col3
FROM myTable99
GROUP BY Col1, Col2, Col3
HAVING COUNT(*) > 1

Is that what your after?|||Originally posted by Brett Kaiser
uh, huh?

SELECT DISTINCT Col1, Col2, Col3

Will give you 1 unique row..

You want to only see dups?

SELECT Col1, Col2, Col3
FROM myTable99
GROUP BY Col1, Col2, Col3
HAVING COUNT(*) > 1

Is that what your after?

------------------

Thanks for your suggestions. I am looking for a resultset of:

COL1 COL2 COL3
---------
brown tall dog
brown tall dog
brown tall dog

Thanks again for your help.|||Did the code give you what you wanted...I'm not sure...|||Originally posted by Brett Kaiser
Did the code give you what you wanted...I'm not sure...

Not yet, but I could be doing something wrong.

I've tried the following:
SELECT DISTINCT COL1, COL2, COL3
FROM myTABLE

and:
SELECT COL1, COL2, COL3
FROM myTABLE
GROUP BY COL1, COL2, COL3

and:
SELECT DISTINCT COL1, COL2, COL3
FROM myTABLE
HAVING COUNT(*) > 1

and I've tried:
SELECT COL1, COL2, COL3
FROM myTABLE
GROUP BY COL1, COL2, COL3
HAVING COUNT(*) > 1|||Well that should work...

USE Northwind
GO

CREATE TABLE myTable99(Col1 varchar(25),Col2 varchar(25),Col3 varchar(25))
GO

INSERT INTO myTable99(Col1,Col2,Col3)
select 'Brown','Tall','Dog' UNION ALL
select 'Brown','Tall','Dog' UNION ALL
select 'Brown','Tall','Dog' UNION ALL
select 'Blonde','Small','Pussy cat' UNION ALL
select 'Red','Medium','Snapper Turtle'
GO

SELECT Col1, Col2, Col3
FROM myTable99
GROUP BY Col1, Col2, Col3
HAVING COUNT(*) > 1
GO

DROP TABLE myTable99
GO

Oh, are you looking for all three?|||SELECT * FROM myTable99 o WHERE EXISTS(
SELECT *
FROM myTable99 i
WHERE o.Col1 = i.Col1
AND o.Col2 = i.Col2
AND o.Col3 = i.Col3
GROUP BY Col1, Col2, Col3
HAVING COUNT(*) > 1)
GO

All three...|||Brett,
That should do it! Combined with the info in the links provided in this thread: http://www.dbforums.com/t991775.html

I should be able to put something together. I really do appreciate all your hard work.

Regards,
Americus Johnson

Thanks also to Pat!|||Hard Work...Lord no...

That's why I became a dba...

:D

PS Don't forget to take ALL of your animal freinds...ya might get lucky|||Originally posted by Brett Kaiser
Hard Work...Lord no...

That's why I became a dba...

:D

PS Don't forget to take ALL of your animal freinds...ya might get lucky

True dat.|||yup