Showing posts with label dbms. Show all posts
Showing posts with label dbms. Show all posts

Friday, February 17, 2012

DBMS VS RDBMS

What makes the DBMS being differed from RDBMS.

Hello,

One referrs explicitly to a relational system (RDBMS), as opposed to perhaps OO etc.

Cheers,

Rob

DBMS for Server 2005?

Anyone know if there if there is a tool visual tool for MS SQL server 2005?
Something to manage data and tables within the database without having to
type a of bunch of commands?
Thanks
In article <46b2658b$0$4895$4c368faf@.roadrunner.com>,
allGeek@.hownerdy.com says...
> Anyone know if there if there is a tool visual tool for MS SQL server 2005?
> Something to manage data and tables within the database without having to
> type a of bunch of commands?
> Thanks
>
>
SSMS or an express version for Sql2005 -- check out BOL. Consolidates
QA and EM and ServerMgr into one tool that essentially operates as
VS2005 does.
Graham (Pete) Berry
PeteBerry@.Caltech.edu
|||"Pete Berry" <PeteBerry@.Caltech.edu> wrote in message
news:MPG.211c07e233d5732d9896a2@.msnews.microsoft.c om...
> In article <46b2658b$0$4895$4c368faf@.roadrunner.com>,
> allGeek@.hownerdy.com says...
> SSMS or an express version for Sql2005 -- check out BOL. Consolidates
> QA and EM and ServerMgr into one tool that essentially operates as
> VS2005 does.
Thanks for that reply.
I looked and see it was not installed on my server.
Looking for Disk 2 and having trouble findng it.
Is it on Disk 2?
Thanks

> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
|||> Looking for Disk 2 and having trouble findng it.
> Is it on Disk 2?
Run setup again and make sure you select items in Workstation Components...
Aaron Bertrand
SQL Server MVP
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ubn2Jxc1HHA.1184@.TK2MSFTNGP04.phx.gbl...
> Run setup again and make sure you select items in Workstation
> Components...
I am in the reinstall phase right now and I am getting this message:
================================================
The following components that you selected will not be changed:
Client Components
Warning: Setup found that the following components that already exist are at
a different service pack level than the components being installed.
Components: Microsoft SQL Server 2005 Tools Express Edition
After completing setup, you must download and apply the latest SQL Server
2005 service pack to all the components.
================================================
Looking in the directories and the start menu..I do not see where these
things are installed.
GB

> --
> Aaron Bertrand
> SQL Server MVP
>
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ubn2Jxc1HHA.1184@.TK2MSFTNGP04.phx.gbl...
> Run setup again and make sure you select items in Workstation
> Components...
> --
> Aaron Bertrand
> SQL Server MVP
>
After reading some more, I see tht Express edition is on it.
It had gotten installed when I did a "complete" install of VS 2005.
However shortly after realizing I did that, I removed it.
Seems the tools are still on there.
I ran the configuration to try to remove the Express Edition tools, but I
see nothing of SQL Express to remove.
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ubn2Jxc1HHA.1184@.TK2MSFTNGP04.phx.gbl...
> Run setup again and make sure you select items in Workstation
> Components...
>
After reading some more, I see tht Express edition is on it.
It had gotten installed when I did a "complete" install of VS 2005.
However shortly after realizing I did that, I removed it.
Seems the tools are still on there.
I ran the configuration to try to remove the Express Edition tools, but I
see nothing of SQL Express to remove.
|||On Aug 2, 4:15 pm, "GeekBoy" <allG...@.hownerdy.com> wrote:
> Anyone know if there if there is a tool visual tool for MS SQL server 2005?
> Something to manage data and tables within the database without having to
> type a of bunch of commands?
> Thanks
SQL Server 2005 Express didn't come with any visual tools. You need
to
download SQL Server Management Studio Express from
http://msdn.microsoft.com/vstudio/express/sql/download/
|||"zbenhalim" <zbenhalim@.yahoo.com> wrote in message
news:1186187280.448848.258420@.g4g2000hsf.googlegro ups.com...
> On Aug 2, 4:15 pm, "GeekBoy" <allG...@.hownerdy.com> wrote:
> SQL Server 2005 Express didn't come with any visual tools. You need
> to
> download SQL Server Management Studio Express from
> http://msdn.microsoft.com/vstudio/express/sql/download/
See my other message.
I don't need to get SQL Server Management Studio Express.
Thanks

>

DBMS For Datawarehousing

Hi, which DMBS Do u Prefer For a DW?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...house/200601/1
SQL Server, probably, since this is a SQL Server newsgroup.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Maryam Arshi via droptable.com" <u16747@.uwe> wrote in message
news:59d77feb82f57@.uwe...
> Hi, which DMBS Do u Prefer For a DW?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...house/200601/1
|||SQL 2005 is really better then 2000 for a datawarehouse solution.
the performance is really better both for ad-hoc queries and loading
process. (I talk about the database only)
"Maryam Arshi via droptable.com" <u16747@.uwe> wrote in message
news:59d77feb82f57@.uwe...
> Hi, which DMBS Do u Prefer For a DW?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...house/200601/1

DBMS For Datawarehousing

Hi, which DMBS Do u Prefer For a DW?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...ehouse/200601/1SQL Server, probably, since this is a SQL Server newsgroup.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Maryam Arshi via droptable.com" <u16747@.uwe> wrote in message
news:59d77feb82f57@.uwe...[vbcol=seagreen]
> Hi, which DMBS Do u Prefer For a DW?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...ehouse/200601/1[/vbco
l]|||SQL 2005 is really better then 2000 for a datawarehouse solution.
the performance is really better both for ad-hoc queries and loading
process. (I talk about the database only)
"Maryam Arshi via droptable.com" <u16747@.uwe> wrote in message
news:59d77feb82f57@.uwe...[vbcol=seagreen]
> Hi, which DMBS Do u Prefer For a DW?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...ehouse/200601/1[/vbco
l]