Downgrade Enterprise edition to Standar edition

Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.
You'll have to backup all of your databases, de-install EE, install Std and
then restore all DB's.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.
|||But definately what is offered by EE like log shipping & other features will
not be available once you switch to Std edition.
Thanks
Ajay Rengunthwar
MCDBA MCAD
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUGHh9RpFHA.3036@.TK2MSFTNGP14.phx.gbl...
> You'll have to backup all of your databases, de-install EE, install Std
and
> then restore all DB's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Frivas" <Frivas@.discussions.microsoft.com> wrote in message
> news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
> Hi all!
> I want to change from sql server enterprise edition to sql server standar
> edition due to licensing cost. Do anybody have do this?
> Any KB article saying hot to reach this?
> Thanks for your help.
>

Downgrade Enterprise edition to Standar edition

Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.You'll have to backup all of your databases, de-install EE, install Std and
then restore all DB's.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.|||But definately what is offered by EE like log shipping & other features will
not be available once you switch to Std edition.
Thanks
Ajay Rengunthwar
MCDBA MCAD
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUGHh9RpFHA.3036@.TK2MSFTNGP14.phx.gbl...
> You'll have to backup all of your databases, de-install EE, install Std
and
> then restore all DB's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Frivas" <Frivas@.discussions.microsoft.com> wrote in message
> news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
> Hi all!
> I want to change from sql server enterprise edition to sql server standar
> edition due to licensing cost. Do anybody have do this?
> Any KB article saying hot to reach this?
> Thanks for your help.
>

Doubts about SQL-DMO

Hello, All!
I've saw many information and commands about SQL-DMO, but I don't know what'
s
is this and how to use it yet. Could you please explain me how to use and
when is better to use this kind of command?
Thanks
Juliano Horta
Message posted via http://www.droptable.comIts a way to administer SQL Server programmatically.
HTH; Jens Suessmeyer.

Doubts about sp_spaceused

Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run sp_spaceuse
d
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1Run:
DBCC UPDATEUSAGE (0)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run
sp_spaceused
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1|||Did you run DBCC UPDATEUSAGE command before running sp_spaceused?
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
> Hello, All!
> I'm making a maintenance in my DataBases and I have doubts about
> somethings.
> Could you help me?
> One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
> executed Shrink DataBase and my DataBases fell down to 700MB.
> But, When I execute the Stored Procedure sp_spaceused, it comes for
> unallocated space -1050MB.
> What's mean?
> What I need to do to revert it? The other information when I run
> sp_spaceused
> is:
> DataBase
> BDSeg_Bosch
> DataBase size: 700MB
> Unallocated space: -1050MB
> reserved: 1691176 KB
> data: 225336 KB
> index_size: 1442216 KB
> unused: 23624 KB
> Thanks
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200603/1

Don't print anything on screen

Hello, All!
I have read in somewhere that I can disable the print information and error
message on the screen when I am running a script or transact-sql. Sorry, but
I reaaly don't remember if I read it in the Internet or in the SQL SErver
books on-line.
I don't remeber too, if i read it about osql command prompt ou about SQL
Query Analyzer.
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200601/1You can disable the display of the rowcount via SET NOCOUNT ON.
HTH, Jens Suessmeyer.|||QA: Only option would be to suppress *all* results. You find the option for
that in Tools, Options,
Results tab (Discard results).
OSQL: Use the -m switch. For instance -m25
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Juliano H via droptable.com" <u13014@.uwe> wrote in message news:5accb064068ae@.uwe...[vbcol
=seagreen]
> Hello, All!
> I have read in somewhere that I can disable the print information and erro
r
> message on the screen when I am running a script or transact-sql. Sorry, b
ut
> I reaaly don't remember if I read it in the Internet or in the SQL SErver
> books on-line.
> I don't remeber too, if i read it about osql command prompt ou about SQL
> Query Analyzer.
> Thanks
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200601/1[/vbcol]

Don't print anything on screen

Hello, All!
I have read in somewhere that I can disable the print information and error
message on the screen when I am running a script or transact-sql. Sorry, but
I reaaly don't remember if I read it in the Internet or in the SQL SErver
books on-line.
I don't remeber too, if i read it about osql command prompt ou about SQL
Query Analyzer.
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200601/1
You can disable the display of the rowcount via SET NOCOUNT ON.
HTH, Jens Suessmeyer.
|||QA: Only option would be to suppress *all* results. You find the option for that in Tools, Options,
Results tab (Discard results).
OSQL: Use the -m switch. For instance -m25
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Juliano H via droptable.com" <u13014@.uwe> wrote in message news:5accb064068ae@.uwe...
> Hello, All!
> I have read in somewhere that I can disable the print information and error
> message on the screen when I am running a script or transact-sql. Sorry, but
> I reaaly don't remember if I read it in the Internet or in the SQL SErver
> books on-line.
> I don't remeber too, if i read it about osql command prompt ou about SQL
> Query Analyzer.
> Thanks
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200601/1

Doing Summation on multiple criterias on the same column in a singlequery

Hi all
I need to perform a summation on a column of a table based on a
criteria given in another column in the same table. The catch is i
need to perform different sums according to the number of criterias in
the criteria column, in a single query. the structure of the table is
somethinmg like this (only relevant columns are shown)
TABLE1
Value - numeric(20,6)
Month - int
indicator - bit
Now i need to do something like:
SELECT Month, SUM(Value) FROM TABLE1
WHERE indicator = 1
GROUP BY Month
and also
SELECT Month, SUM(Value) FROM TABLE1
WHERE indicator = 0
GROUP BY Month
How can i do this in a single query, something like this:
SELECT Month, SUM(Value where indicator=1), SUM(Value where
indicator=0) and so on ......
Could any body please help me on this ?
Try:
SELECT
Month
, SUM(CASE WHEN indicator = 0 THEN Value ELSE 0 END) Value0
, SUM(CASE WHEN indicator = 1 THEN Value ELSE 0 END) Value1
FROM TABLE1
GROUP BY Month
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Darsin" <darsin@.gmail.com> wrote in message
news:8fc9e52e-1606-44d9-a722-4ae0f29542b6@.s13g2000prd.googlegroups.com...
Hi all
I need to perform a summation on a column of a table based on a
criteria given in another column in the same table. The catch is i
need to perform different sums according to the number of criterias in
the criteria column, in a single query. the structure of the table is
somethinmg like this (only relevant columns are shown)
TABLE1
Value - numeric(20,6)
Month - int
indicator - bit
Now i need to do something like:
SELECT Month, SUM(Value) FROM TABLE1
WHERE indicator = 1
GROUP BY Month
and also
SELECT Month, SUM(Value) FROM TABLE1
WHERE indicator = 0
GROUP BY Month
How can i do this in a single query, something like this:
SELECT Month, SUM(Value where indicator=1), SUM(Value where
indicator=0) and so on ......
Could any body please help me on this ?
|||Hi
SUM(CASE WHEN indicator =0 THEN value END ) as val1
SUM(CASE WHEN indicator =1 THEN value END ) as val1
FROM tbl
"Darsin" <darsin@.gmail.com> wrote in message
news:8fc9e52e-1606-44d9-a722-4ae0f29542b6@.s13g2000prd.googlegroups.com...
> Hi all
> I need to perform a summation on a column of a table based on a
> criteria given in another column in the same table. The catch is i
> need to perform different sums according to the number of criterias in
> the criteria column, in a single query. the structure of the table is
> somethinmg like this (only relevant columns are shown)
> TABLE1
> Value - numeric(20,6)
> Month - int
> indicator - bit
> Now i need to do something like:
> SELECT Month, SUM(Value) FROM TABLE1
> WHERE indicator = 1
> GROUP BY Month
> and also
> SELECT Month, SUM(Value) FROM TABLE1
> WHERE indicator = 0
> GROUP BY Month
>
> How can i do this in a single query, something like this:
> SELECT Month, SUM(Value where indicator=1), SUM(Value where
> indicator=0) and so on ......
> Could any body please help me on this ?
|||One way:
SELECT Month,
SUM(CASE WHEN indicator = 1 THEN Value ELSE 0 END) AS sum1,
SUM(CASE WHEN indicator = 0 THEN Value ELSE 0 END) AS sum0
FROM TABLE1
GROUP BY Month
HTH,
Plamen Ratchev
http://www.SQLStudio.com
|||> It is also a bad idea to use proprietary BIT data types to fake
> assembly language style programming. SQL is a predicate language;
> that is, we discover a fact with a predicate rather than set a flag.
What if the fact IS a flag, and is not based on other data in your database?
e.g. did the patient visit Congo anytime between 1978 and 1989? Instead of
a "flag" saying yes or no, would you rather store each patient's entire
travel itineraries for the period in question? What do you when that is not
available, but the patient does know that he/she was there during that time
period?
You can't answer 8 billion different design questions with your four
standards-based rules. Real world design and development dictates a little
more flexibility than that.
|||>> What if the fact IS a flag, and is not based on other data in your database? <<
It might or might not be based on other data; that is the problem. I
don't want to write triggers to constantly update the flags.
[vbcol=seagreen]
The alternative is a set of flags that cover all of the countries on
Earth, and all of the possible time periods Oh, I also hope that
you created exactly the right flags, since they carry so little
data.
Eventually, I will probably have to have his travel itineraries to
follow a disease pattern. I have a friend who is an epidemiologist at
the CDC and that is how they do it.
[vbcol=seagreen]
You put it the chart as free-form data and then you check his passport
records. Hey, this is the usual missing/fuzzy data problem. What did
you do when you never had a flag for that "bit" of data? What do you
do when the important year was 1990? More bit flags? Have you ever
considered what the triggers and constraints to keep the flags
current?
|||> You put it the chart as free-form data and then you check his passport
> records. Hey, this is the usual missing/fuzzy data problem. What did
> you do when you never had a flag for that "bit" of data? What do you
> do when the important year was 1990? More bit flags? Have you ever
> considered what the triggers and constraints to keep the flags
> current?
The fact remains, some things are just that, flags... no further information
necessary, no updating required.
|||>> "have you been in the United Stated during the last 90 days"? and two check boxes conveniently marked yes and no. How would you model that? <<
They don't care about your trips to AIDS infected Africa? Avian flu
in China? Mad Cow Disease in the UK? I think I would go with three
tables -- Donors for your general demographics, Donations for a
history of donations and a Quarantine list with countries and dates
that would exclude a donation at this time.
I would first check the date of the last donation to be sure that you
are not giving too much and too often. In the US you get recognition
for donating over a gallon, etc. We want a history in the DB.
Then I would ask "what countries have you visited since << insert
date>>?" One of the options could include the Netherlands, altho the
front end might present it as "None" or something similar to the
donor. When the situation changes, I change the Quarantine list.
|||On Mar 24, 6:32Xpm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Try:
> SELECT
> X X Month
> , XSUM(CASE WHEN indicator = 0 THEN Value ELSE 0 END) Value0
> , XSUM(CASE WHEN indicator = 1 THEN Value ELSE 0 END) Value1
> FROM TABLE1
> GROUP BY Month
> --
> X XTom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON X Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "Darsin" <dar...@.gmail.com> wrote in message
> news:8fc9e52e-1606-44d9-a722-4ae0f29542b6@.s13g2000prd.googlegroups.com...
> Hi all
> I need to perform a summation on a column of a table based on a
> criteria given in another column in the same table. The catch is i
> need to perform different sums according to the number of criterias in
> the criteria column, in a single query. the structure of the table is
> somethinmg like this (only relevant columns are shown)
> TABLE1
> Value - numeric(20,6)
> Month - int
> indicator - bit
> Now i need to do something like:
> SELECT Month, SUM(Value) FROM TABLE1
> WHERE indicator = 1
> GROUP BY Month
> and also
> SELECT Month, SUM(Value) FROM TABLE1
> WHERE indicator = 0
> GROUP BY Month
> How can i do this in a single query, something like this:
> SELECT Month, SUM(Value where indicator=1), SUM(Value where
> indicator=0) and so on ......
> Could any body please help me on this ?
Hi all,
First of all my apologies for using Month, Value, etc keywords in the
example, will remember to not do it again, and thank you for a prompt
reply.
Secondly, initially i used a temp table to fill the first case and
then updated the temp table with the second case.
now the total number of records are around 50,000 and above, so my
question is will there be a performance (query excute time)
improvement or degradation. In case any furthur details are required
than please do let me know.
Thanks
in case if it there
|||> They don't care about your trips to AIDS infected Africa? Avian flu
> in China? Mad Cow Disease in the UK?
No, Joe. Have you ever donated blood in the U.S.? I have donated just
under 3 gallons and I have never been asked about this stuff. There are a
few yes / no questions about certain countries and certain time periods.
There is also a yes / no question about whether I have ever exchanged sex
for money. On that there is not a request for a list of transactions and/or
acts/positions, either. Just a checkbox. I'm sure you would prefer all the
sordid details, but alas, donors are expected to take about 10 minutes to
fill out the questionnaire; it is not a take-home exam with essay questions
and bonus points.

> I would first check the date of the last donation to be sure that you
> are not giving too much and too often. In the US you get recognition
> for donating over a gallon, etc. We want a history in the DB.
But Joe, different states have different organizations that collect blood...
some multiple. So, I could have donated to some blood donor trailer in
Arkansas yesterday, and for some reason want to donate again today in
Boston. Since they can't check every single blood donor organization in the
world, they ask... "have you given blood in the past 90 days?" (They don't
bother asking "have you given blood to this organization in the past 90
days?" because that is something they can verify on their own.) What you
are expecting is like going to the equivalent of the DMV in Tehran or Beirut
or Cairo and expecting them to be able to print you up a new Rhode Island
driver's license.

> Then I would ask "what countries have you visited since << insert
> date>>?"
They do ask that... "what countries have you visited in the past 36 months?"
is the one in my state. But they also want to know about your presence in
certain countries in certain periods of time, e.g. Congo between 1978 and
1982, etc. Now do you really think they are going to leave an open-ended
essay question, require a certified copy of your travel itinerary, etc.? Of
course not. They are relying on you to be honest and check yes / no. They
are going to take your blood and test it anyway, but this kind of screening
is a very simple way to prevent that blood from being taken and having to be
tested.
Does the concept of only needing a yes / no answer really escape you this
much? You are a clever person, and I have to assume this is all for show.
A