MSSQL Mistake: newbie

Showing posts with label newbie. Show all posts

Friday, March 23, 2012

Multable database on one machine

Total newbie question i know.
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
LeeYes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great Plains
>> 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>> Yes, you can have multiple databases on the same machine, and on the same
>> instance of SQL Server. Your limitations are: (a) two databases can't
>> have the same name, or expect their data/log files to have the same path,
>> and (b) the available resources on the server. If it's a low-powered box
>> it may perform acceptably hosting one application's database
>> As for the right way to perform the consolidation, if you are comfortable
>> that it is the right move, there are several options. Andrew Kelly has
>> posted this list of KB articles that should help you out:
>> http://tinyurl.com/up5ok
>>
>> "Lee J" <faked@.fc.com> wrote in message
>> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great
>> Plains 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>>
>|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>> Great, Thank you, I am looking to be buying some new blade servers
>>
>> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>> Yes, you can have multiple databases on the same machine, and on the
>> same instance of SQL Server. Your limitations are: (a) two databases
>> can't have the same name, or expect their data/log files to have the
>> same path, and (b) the available resources on the server. If it's a
>> low-powered box it may perform acceptably hosting one application's
>> database
>> As for the right way to perform the consolidation, if you are
>> comfortable that it is the right move, there are several options.
>> Andrew Kelly has posted this list of KB articles that should help you
>> out:
>> http://tinyurl.com/up5ok
>>
>> "Lee J" <faked@.fc.com> wrote in message
>> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great
>> Plains 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>>
>>
>

Multable database on one machine

Monday, February 20, 2012

MS-SQL Search by keyword performance

Hello experts,
I'm a newbie here and do not know if this is the right place to ask this question, or if there are some one else already solving this from elsewhere. if so, please accept my appologies.
My problem is that, i do not know what is the right solution to dealing with the search module which will need to be implemented in my application.
e.g: i have a master table is Order with the following fields
(Order_id, Product_Id, Order_Number, Cus_name, Cus_address)
Product(Product_id, Category_Id, ProductName, Price)
Category(Category_id, Description)
My Search support for user to enter a string, once hit on search, system would need to returned all matched Order for the search string.
example: if i enter [Toy], then system will return all Order which:
- The Cus_name contains [toy] or Cus_address contains [toy] or productname contain [toy] or category description contains [toy]
actually, the real senarios might be more complex than this sample and the database is a huge db which might contains mililion of records. If i doing a standard SQL join to perform the SQL selection, i would afraid about the performance of the whole syste
m.
Is Full-text index search could be applied for this or is there any other solution?
Thanks for your helps!
Doan
Message posted via http://www.sqlmonster.com
This is exactly what full-text search is intended to do... Setting it up is
documented in books on line... after you have indexed all of the fields, you
can to a multi column search ie..
select * from Orders where contains(*,'Toy')
The * in the contains clause says to search ALL indexed text columns
have fun
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
"Doan Ly via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:cb1e2d67657544229ad2c2b16d7513ea@.SQLMonster.c om...
> Hello experts,
> I'm a newbie here and do not know if this is the right place to ask this
question, or if there are some one else already solving this from elsewhere.
if so, please accept my appologies.
> My problem is that, i do not know what is the right solution to dealing
with the search module which will need to be implemented in my application.
> e.g: i have a master table is Order with the following fields
> (Order_id, Product_Id, Order_Number, Cus_name, Cus_address)
> Product(Product_id, Category_Id, ProductName, Price)
> Category(Category_id, Description)
> My Search support for user to enter a string, once hit on search, system
would need to returned all matched Order for the search string.
> example: if i enter [Toy], then system will return all Order which:
> - The Cus_name contains [toy] or Cus_address contains [toy] or productname
contain [toy] or category description contains [toy]
> actually, the real senarios might be more complex than this sample and the
database is a huge db which might contains mililion of records. If i doing a
standard SQL join to perform the SQL selection, i would afraid about the
performance of the whole system.
> Is Full-text index search could be applied for this or is there any other
solution?
> Thanks for your helps!
> Doan
> --
> Message posted via http://www.sqlmonster.com
|||Thanks Wayne for your speedy suggest.
by the way:

>select * from Orders where contains(*,'Toy')
>The * in the contains clause says to search ALL indexed text columns
Could it also look for the matched full-text indexed fields in its child tables? (Product & Category), or need i consider some special skill here?
Thanks
Doan
Message posted via http://www.sqlmonster.com

MS-SQL Search by keyword performance

Hello experts,
I'm a newbie here and do not know if this is the right place to ask this que
stion, or if there are some one else already solving this from elsewhere. if
so, please accept my appologies.
My problem is that, i do not know what is the right solution to dealing with
the search module which will need to be implemented in my application.
e.g: i have a master table is Order with the following fields
(Order_id, Product_Id, Order_Number, Cus_name, Cus_address)
Product(Product_id, Category_Id, ProductName, Price)
Category(Category_id, Description)
My Search support for user to enter a string, once hit on search, system wou
ld need to returned all matched Order for the search string.
example: if i enter [Toy], then system will return all Order which:
- The Cus_name contains [toy] or Cus_address contains [toy] or produ
ctname contain [toy] or category description contains [toy]
actually, the real senarios might be more complex than this sample and the d
atabase is a huge db which might contains mililion of records. If i doing a
standard SQL join to perform the SQL selection, i would afraid about the per
formance of the whole syste
m.
Is Full-text index search could be applied for this or is there any other so
lution?
Thanks for your helps!
Doan
Message posted via http://www.droptable.comThis is exactly what full-text search is intended to do... Setting it up is
documented in books on line... after you have indexed all of the fields, you
can to a multi column search ie..
select * from Orders where contains(*,'Toy')
The * in the contains clause says to search ALL indexed text columns
have fun
--
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
"Doan Ly via droptable.com" <forum@.droptable.com> wrote in message
news:cb1e2d67657544229ad2c2b16d7513ea@.SQ
droptable.com...
> Hello experts,
> I'm a newbie here and do not know if this is the right place to ask this
question, or if there are some one else already solving this from elsewhere.
if so, please accept my appologies.
> My problem is that, i do not know what is the right solution to dealing
with the search module which will need to be implemented in my application.
> e.g: i have a master table is Order with the following fields
> (Order_id, Product_Id, Order_Number, Cus_name, Cus_address)
> Product(Product_id, Category_Id, ProductName, Price)
> Category(Category_id, Description)
> My Search support for user to enter a string, once hit on search, system
would need to returned all matched Order for the search string.
> example: if i enter [Toy], then system will return all Order which:
> - The Cus_name contains [toy] or Cus_address contains [toy] or productname

contain [toy] or category description contains [toy]
> actually, the real senarios might be more complex than this sample and the
database is a huge db which might contains mililion of records. If i doing a
standard SQL join to perform the SQL selection, i would afraid about the
performance of the whole system.
> Is Full-text index search could be applied for this or is there any other
solution?
> Thanks for your helps!
> Doan
> --
> Message posted via http://www.droptable.com|||Thanks Wayne for your speedy suggest.
by the way:

>select * from Orders where contains(*,'Toy')
>The * in the contains clause says to search ALL indexed text columns
Could it also look for the matched full-text indexed fields in its child tab
les? (Product & Category), or need i consider some special skill here?
Thanks
Doan
Message posted via http://www.droptable.com

MS-SQL Search by keyword performance

Hello experts,
I'm a newbie here and do not know if this is the right place to ask this question, or if there are some one else already solving this from elsewhere. if so, please accept my appologies.
My problem is that, i do not know what is the right solution to dealing with the search module which will need to be implemented in my application.
e.g: i have a master table is Order with the following fields
(Order_id, Product_Id, Order_Number, Cus_name, Cus_address)
Product(Product_id, Category_Id, ProductName, Price)
Category(Category_id, Description)
My Search support for user to enter a string, once hit on search, system would need to returned all matched Order for the search string.
example: if i enter [Toy], then system will return all Order which:
- The Cus_name contains [toy] or Cus_address contains [toy] or productname contain [toy] or category description contains [toy]
actually, the real senarios might be more complex than this sample and the database is a huge db which might contains mililion of records. If i doing a standard SQL join to perform the SQL selection, i would afraid about the performance of the whole system.
Is Full-text index search could be applied for this or is there any other solution?
Thanks for your helps!
Doan
--
Message posted via http://www.sqlmonster.comThis is exactly what full-text search is intended to do... Setting it up is
documented in books on line... after you have indexed all of the fields, you
can to a multi column search ie..
select * from Orders where contains(*,'Toy')
The * in the contains clause says to search ALL indexed text columns
have fun
--
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
"Doan Ly via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:cb1e2d67657544229ad2c2b16d7513ea@.SQLMonster.com...
> Hello experts,
> I'm a newbie here and do not know if this is the right place to ask this
question, or if there are some one else already solving this from elsewhere.
if so, please accept my appologies.
> My problem is that, i do not know what is the right solution to dealing
with the search module which will need to be implemented in my application.
> e.g: i have a master table is Order with the following fields
> (Order_id, Product_Id, Order_Number, Cus_name, Cus_address)
> Product(Product_id, Category_Id, ProductName, Price)
> Category(Category_id, Description)
> My Search support for user to enter a string, once hit on search, system
would need to returned all matched Order for the search string.
> example: if i enter [Toy], then system will return all Order which:
> - The Cus_name contains [toy] or Cus_address contains [toy] or productname
contain [toy] or category description contains [toy]
> actually, the real senarios might be more complex than this sample and the
database is a huge db which might contains mililion of records. If i doing a
standard SQL join to perform the SQL selection, i would afraid about the
performance of the whole system.
> Is Full-text index search could be applied for this or is there any other
solution?
> Thanks for your helps!
> Doan
> --
> Message posted via http://www.sqlmonster.com|||Thanks Wayne for your speedy suggest.
by the way:
>select * from Orders where contains(*,'Toy')
>The * in the contains clause says to search ALL indexed text columns
Could it also look for the matched full-text indexed fields in its child tables? (Product & Category), or need i consider some special skill here?
Thanks
Doan
--
Message posted via http://www.sqlmonster.com

Friday, March 23, 2012

Multable database on one machine

Multable database on one machine

Multable database on one machine

Monday, February 20, 2012

MS-SQL Search by keyword performance

MS-SQL Search by keyword performance

MS-SQL Search by keyword performance

MSSQL Mistake

Blog Archive

About Me