Is there a good free database manager for SQL Server Express?

I saw this product called Toad and it looked like it was free but I was
unable to install it because it complained about expiring and stuff.
Thanks for your help.
Hi,
sure look here:
http://www.microsoft.com/downloads/d...6-1d4c98d40f6e
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de

Is there a free Graphical User Interface for MSDE?

I asked a similar question moments ago. I wanted to clarify because I didn't use the correct terms..
I have a purchased product that contains a MSDE database. I was hopin
to access the database with a MSDE front-end, however I don't have
separate licensed copy of SQL Server. Is there a way I can obtain a fre
copy of the user interface for a MSDE DB?
Thank you
AFGTry this:
http://www.whitebearconsulting.com/Utilities.htm
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"AFG" <anonymous@.discussions.microsoft.com> wrote in message
news:198C89E8-A24F-4935-A347-6D2AA5C2786E@.microsoft.com...
> I asked a similar question moments ago. I wanted to clarify because I
didn't use the correct terms...
> I have a purchased product that contains a MSDE database. I was hoping
> to access the database with a MSDE front-end, however I don't have a
> separate licensed copy of SQL Server. Is there a way I can obtain a free
> copy of the user interface for a MSDE DB?
> Thank you,
> AFG|||No, you can't get SQL Server client tools for free. Several alternatives,
however: http://www.aspfaq.com/2442
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"AFG" <anonymous@.discussions.microsoft.com> wrote in message
news:198C89E8-A24F-4935-A347-6D2AA5C2786E@.microsoft.com...
>I asked a similar question moments ago. I wanted to clarify because I
>didn't use the correct terms...
> I have a purchased product that contains a MSDE database. I was hoping
> to access the database with a MSDE front-end, however I don't have a
> separate licensed copy of SQL Server. Is there a way I can obtain a free
> copy of the user interface for a MSDE DB?
> Thank you,
> AFG

Is there a free Graphical User Interface for MSDE?

I asked a similar question moments ago. I wanted to clarify because I didn't use the correct terms...
I have a purchased product that contains a MSDE database. I was hoping
to access the database with a MSDE front-end, however I don't have a
separate licensed copy of SQL Server. Is there a way I can obtain a free
copy of the user interface for a MSDE DB?
Thank you,
AFG
Try this:
http://www.whitebearconsulting.com/Utilities.htm
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"AFG" <anonymous@.discussions.microsoft.com> wrote in message
news:198C89E8-A24F-4935-A347-6D2AA5C2786E@.microsoft.com...
> I asked a similar question moments ago. I wanted to clarify because I
didn't use the correct terms...
> I have a purchased product that contains a MSDE database. I was hoping
> to access the database with a MSDE front-end, however I don't have a
> separate licensed copy of SQL Server. Is there a way I can obtain a free
> copy of the user interface for a MSDE DB?
> Thank you,
> AFG
|||No, you can't get SQL Server client tools for free. Several alternatives,
however: http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"AFG" <anonymous@.discussions.microsoft.com> wrote in message
news:198C89E8-A24F-4935-A347-6D2AA5C2786E@.microsoft.com...
>I asked a similar question moments ago. I wanted to clarify because I
>didn't use the correct terms...
> I have a purchased product that contains a MSDE database. I was hoping
> to access the database with a MSDE front-end, however I don't have a
> separate licensed copy of SQL Server. Is there a way I can obtain a free
> copy of the user interface for a MSDE DB?
> Thank you,
> AFG

Is there a free Graphical User Interface for MSDE?

I asked a similar question moments ago. I wanted to clarify because I didn't
use the correct terms...
I have a purchased product that contains a MSDE database. I was hoping
to access the database with a MSDE front-end, however I don't have a
separate licensed copy of SQL Server. Is there a way I can obtain a free
copy of the user interface for a MSDE DB?
Thank you,
AFGTry this:
http://www.whitebearconsulting.com/Utilities.htm
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"AFG" <anonymous@.discussions.microsoft.com> wrote in message
news:198C89E8-A24F-4935-A347-6D2AA5C2786E@.microsoft.com...
> I asked a similar question moments ago. I wanted to clarify because I
didn't use the correct terms...
> I have a purchased product that contains a MSDE database. I was hoping
> to access the database with a MSDE front-end, however I don't have a
> separate licensed copy of SQL Server. Is there a way I can obtain a free
> copy of the user interface for a MSDE DB?
> Thank you,
> AFG|||No, you can't get SQL Server client tools for free. Several alternatives,
however: http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"AFG" <anonymous@.discussions.microsoft.com> wrote in message
news:198C89E8-A24F-4935-A347-6D2AA5C2786E@.microsoft.com...
>I asked a similar question moments ago. I wanted to clarify because I
>didn't use the correct terms...
> I have a purchased product that contains a MSDE database. I was hoping
> to access the database with a MSDE front-end, however I don't have a
> separate licensed copy of SQL Server. Is there a way I can obtain a free
> copy of the user interface for a MSDE DB?
> Thank you,
> AFG

Is the single-processor SQL different than the dual-processor SQL?

Is the single-processor SQL actually a different product from the
dual-processor SQL? Or is it strictly just a licensing difference?
Thanks> Is the single-processor SQL actually a different product from the
> dual-processor SQL? Or is it strictly just a licensing difference?
It is just the licensing. Depending on the edition of SQL Server it can
support from 2 up to 8 prcessors. Check the editions at
http://www.microsoft.com/sql/techin...sKChooseEd.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

Is SSIS (SQL Server Integration Services) a new product or just the upgrade version of DTS?

Hi, all,

I am having a question about SSIS. Is it a totally new product in SQL Server 2005 or it is a upgrade version of previous version DTS? Thanks a lot for any guidance for that.

With best regards,

Yours sincerely,

It is the successor to (or replacement for) DTS, but it is not an upgrade. There is no code from DTS that made it into SSIS. Therefore yes, it is a totally new product.

-Jamie

|||

Hi, Jamie, thanks a lot for your kind guidance.

With best regards,

Yours sincerely,

Is SSAS a new version product or it is a upgrade version of SQL Server analysis services 2000?

Hi, all here,

I am having a question about SQL Server 2005 Analysis Services. Is it a new version product or it is a upgrade version of SQL Server 2000 analysis services?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

It is a new OLAP and data mining engine.

There are some upgrading issues especially regarding dimensions. In AS 2005 everything was about hierarchies but in AS 2005 a dimension consists of attribute hierarchies(flat hierarchies) and user hierarchies(the old AS2000 version of dimensions)

A virtual cube is the same as a cube in AS2005. Measure groups is the same(almost) as the AS2000 physical cubes.

Some changes in MDX have also appeared.

Have a look at www.microsoft.com/sql for more information.

Regards

Thomas Ivarsson

|||

Hi, Thomas, thanks a lot for your kind guidance.

With best regards,

Yours sincerely,

Is SSAS a new version product or it is a upgrade version of SQL Server analysis services 200

Hi, all here,

I am having a question about SQL Server 2005 Analysis Services. Is it a new version product or it is a upgrade version of SQL Server 2000 analysis services?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

It is a new OLAP and data mining engine.

There are some upgrading issues especially regarding dimensions. In AS 2005 everything was about hierarchies but in AS 2005 a dimension consists of attribute hierarchies(flat hierarchies) and user hierarchies(the old AS2000 version of dimensions)

A virtual cube is the same as a cube in AS2005. Measure groups is the same(almost) as the AS2000 physical cubes.

Some changes in MDX have also appeared.

Have a look at www.microsoft.com/sql for more information.

Regards

Thomas Ivarsson

|||

Hi, Thomas, thanks a lot for your kind guidance.

With best regards,

Yours sincerely,

Is QUICKSHIFT Real?

QuickShift is advertising a software product to radically improve SQL
performance. They claim to be Microsoft certed. Does anyone know if this
product is real? If it is it would lead one to ask why Microsoft has not
done something similiar to what they do to improve performance.
Thanks
SB
It is real; as to whether it works as advertised? I don't know... The
product uses dynamic compression to do its job. If your processors are
underutilized but you have other kinds of bottlenecks (e.g. IO, RAM), I
think it could work well... But companies have been trying compression for a
long time, with little success. Remember Stacker?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"SB99379" <SB99379@.discussions.microsoft.com> wrote in message
news:FBE6476E-13D7-42D0-9AFB-28AFCB76F0FF@.microsoft.com...
> QuickShift is advertising a software product to radically improve SQL
> performance. They claim to be Microsoft certed. Does anyone know if this
> product is real? If it is it would lead one to ask why Microsoft has not
> done something similiar to what they do to improve performance.
> Thanks
> SB

Is QUICKSHIFT Real?

QuickShift is advertising a software product to radically improve SQL
performance. They claim to be Microsoft certed. Does anyone know if this
product is real? If it is it would lead one to ask why Microsoft has not
done something similiar to what they do to improve performance.
Thanks
SBIt is real; as to whether it works as advertised? I don't know... The
product uses dynamic compression to do its job. If your processors are
underutilized but you have other kinds of bottlenecks (e.g. IO, RAM), I
think it could work well... But companies have been trying compression for a
long time, with little success. Remember Stacker?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"SB99379" <SB99379@.discussions.microsoft.com> wrote in message
news:FBE6476E-13D7-42D0-9AFB-28AFCB76F0FF@.microsoft.com...
> QuickShift is advertising a software product to radically improve SQL
> performance. They claim to be Microsoft certed. Does anyone know if this
> product is real? If it is it would lead one to ask why Microsoft has not
> done something similiar to what they do to improve performance.
> Thanks
> SB

Is QUICKSHIFT Real?

QuickShift is advertising a software product to radically improve SQL
performance. They claim to be Microsoft certed. Does anyone know if this
product is real? If it is it would lead one to ask why Microsoft has not
done something similiar to what they do to improve performance.
Thanks
SBIt is real; as to whether it works as advertised? I don't know... The
product uses dynamic compression to do its job. If your processors are
underutilized but you have other kinds of bottlenecks (e.g. IO, RAM), I
think it could work well... But companies have been trying compression for a
long time, with little success. Remember Stacker?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"SB99379" <SB99379@.discussions.microsoft.com> wrote in message
news:FBE6476E-13D7-42D0-9AFB-28AFCB76F0FF@.microsoft.com...
> QuickShift is advertising a software product to radically improve SQL
> performance. They claim to be Microsoft certed. Does anyone know if this
> product is real? If it is it would lead one to ask why Microsoft has not
> done something similiar to what they do to improve performance.
> Thanks
> SB

is null or nvl()

im trying to select * information about a product where its name is populated and i dont know if is not null or nvl() is better?
any suggestionsIS NOT NULL is better, because it's standard, and thus also portable|||Alternatively, you could use the COALESCE() function. This is also SQL. NLV is only a proprietary extension of MS SQL Server.|||NLV is only a proprietary extension of MS SQL Server.
I know absolutelly nothing about MS SQL Server, but I know that Oracle offers the NVL function.|||I know absolutelly nothing about MS SQL Server, but I know that Oracle offers the NVL function.

Same thing. COALESCE is what the SQL standard defines. NVL is a proprietary extension that provides the same functionality as COALESCE. If you want to stick to portable SQL, COALESCE would be your best choice.|||Oh, I'm not saying a word about the COALESCE; I was just complaining about the proprietary term.

Webopedia (http://www.webopedia.com/TERM/p/proprietary.html):Privately owned and controlled. In the computer industry, proprietary is the opposite of open. A proprietary design or technique is one that is owned by a company. It also implies that the company has not divulged specifications that would allow other companies to duplicate the product.

eLook (http://www.elook.org/dictionary/proprietary.html):
protected by trademark or patent or copyright; made or produced or distributed by one having exclusive rights

All I wanted to say was that - if I correctly understood what proprietary means - NVL is not proprietary of Microsoft. If I'm wrong about it, I apologize.|||NVL is not proprietary of Microsoft. If I'm wrong about it, I apologize.no need

NVL doesn't even exist in SQL Server|||Now I know the reason for your response. :) For me, "proprietary" means that it is not standardized.|||I'd call it charm of English as a foreign language. Perhaps it is time to take a dictionary and see what it says about something being proprietary.|||Hi,
in Viper 2 - next version of DB2 now in beta release at the moment, NLV function will be supported in DB2 too. COALESCE is a standard, but NLV uses Oracle one of the biggest RDMBS (if not the first) of market share and IBM wants to get Oracle users to DB2. To make application migration easer this is obvious step. In terms of commodization.
Hope this helps,
Grofaty