Ok.. I've been looking around and I just don't see how to do it. I used to
have an eval copy of Reporting services on my local machine. The eval copy
ran out so I got the enterprise copy on CD. when I try to install this on my
machine I get an error saying that it won't let me install reporting services
on a machine that is not a server. Which is fine.. But how the heck do I re
install report Designer so I can make some reports?
Thanks for the infoI think you are seeing some warnings. Ignore them and you should eventually
end up where you can select what components to install.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerrad Anderson" <Jerrad Anderson@.discussions.microsoft.com> wrote in
message news:6F8F92BA-6246-4406-9C57-66E18BBA88C4@.microsoft.com...
> Ok.. I've been looking around and I just don't see how to do it. I used to
> have an eval copy of Reporting services on my local machine. The eval copy
> ran out so I got the enterprise copy on CD. when I try to install this on
> my
> machine I get an error saying that it won't let me install reporting
> services
> on a machine that is not a server. Which is fine.. But how the heck do I
> re
> install report Designer so I can make some reports?
> Thanks for the info|||Thanks.. works now :)
"Bruce Johnson [MSFT]" wrote:
> I think you are seeing some warnings. Ignore them and you should eventually
> end up where you can select what components to install.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jerrad Anderson" <Jerrad Anderson@.discussions.microsoft.com> wrote in
> message news:6F8F92BA-6246-4406-9C57-66E18BBA88C4@.microsoft.com...
> > Ok.. I've been looking around and I just don't see how to do it. I used to
> > have an eval copy of Reporting services on my local machine. The eval copy
> > ran out so I got the enterprise copy on CD. when I try to install this on
> > my
> > machine I get an error saying that it won't let me install reporting
> > services
> > on a machine that is not a server. Which is fine.. But how the heck do I
> > re
> > install report Designer so I can make some reports?
> >
> > Thanks for the info
>
>
Showing posts with label copy. Show all posts
Showing posts with label copy. Show all posts
Wednesday, March 28, 2012
Monday, March 12, 2012
INSIDER - KNOWLEDGE NEUTRALIZING!
INSIDER - KNOWLEDGE NEUTRALIZING!!
(First Copy this Text in your editor)
Translated Text (sorry if the Text is not in good grammer).
I have earned over 40,000 Euros after participate in this program.
Before short, I have myself in the following mails - list registered.
Later I got an E-MAIL, that said me, how and where I get IMMEDIATELY a money
in opening - gift of more than 20 Euros. In addition I earn WITHOUT EDITIONS
at a system with more than 4 steps. It is obvious that such information is
not told simply cost-free at all world. The mails - list with which I had
registered me, informed me per E-MAIL about this new business.
Now I have you only one of the many money - salaries named, become you over
that informed after registration.
The advantage in THIS mail - list - registration is:
- For the registrations in the E-mail-list I get money
- After the registration receive I knowledge over money and would earn in
addition, more than I in the mail - list - registrations would receive.
I was read had to beginning also sceptical, but as I the letter, knew I that
I get also something good for my money, and have invests above all, MORE
than I.
ONLY if I get something, the other can earn also, is that the logical
answer.
Can if you earn in an investment of 12 Euros / 12 U.S. dollars or 12 British
pounds (sterlings) of thousand and also hundred cable envoy, you not would
transmit yourself information that bring you yet more money?
Therefore it is entirely clear that the applicant sends also the information
REALLY at the registered, unlike in so-called " mail - lists ", where one
waits long on that (usually in vain).
Swell through the further money - is certain, that THIS program functions,
or would become you you in comparison with 100,000 with only 12 Euros /
satisfied give 12 U.S. dollars or 12 British pounds (sterlings)?
I got, above all, more in my investment of 12 Euros already in short time
than that hundredfold thanks to which mail - information.
If you decide to register you in the mail - list, would follow the
directions:
You become now part at the mail order business:
Would follow the directions:
1 stepped:
If you are yet no Paypal-user, a user COST-FREE - account (Premium - basis -
account) opens now in Paypal. Paypal is with more than 96 million users and
with representation in more than 56 countries of one of the most certain
money - transfers - business worldwide.
click up: https://www.paypal.com
(should that be left not active, would copy it please into your browser)
Stepped 2:
Would register you in the " mail - list".
Send 12 Euro / 12 US - Dollar or 12 British Pounds (sterling) at the FIRST
mail-address per mail
- For use-purpose you write: " Service "
- For E-mail-reference you write: " Mail - list "
How you can send money, you find on the web page of Paypal simply declared.
The present list:
(#1) bestwaybook@.yahoo.de
(#2) luxusbook@.yahoo.de
(#3) ecashmail@.yahoo.de
Through the fast payment per enamel and the reception, it lasts only few
Would meet until you get the information per E-MAIL.
As soon as your registration arrived in the receiver, you get further
information / insider - knowledge. Would keep in mind always, ONLY if you
also salary, earn other with.
COMMENT:
Would follow steps 3 FIRST THEN AFTER you received the information /
insiders - knowledge.
Only if you have the information / insiders - knowledge, you can transmit
this also.
Here it does not concern simply only mail - earn collections, but rather
around CORRECT money.
Stepped 3:
Now that would paint see #1 of the list that you above and back the other
names after.
The address at the position #2 you write on position #1
The address at the position #3 you write on position #2
After that you write YOUR address on position #3.
Was ready on an exciting and interesting type, to earn money.Your sister will earn12 Euros from me the next time I'm at Oktoberfest.
;-)
"INSIDER - KNOWLEDGE!!" <new-power@.invest.net> wrote in message
news:e0iIG50UGHA.1688@.TK2MSFTNGP11.phx.gbl...
> INSIDER - KNOWLEDGE NEUTRALIZING!!
> (First Copy this Text in your editor)
> Translated Text (sorry if the Text is not in good grammer).
>
> I have earned over 40,000 Euros after participate in this program.
> Before short, I have myself in the following mails - list registered.
> Later I got an E-MAIL, that said me, how and where I get IMMEDIATELY a
> money in opening - gift of more than 20 Euros. In addition I earn WITHOUT
> EDITIONS at a system with more than 4 steps. It is obvious that such
> information is not told simply cost-free at all world. The mails - list
> with which I had registered me, informed me per E-MAIL about this new
> business.
> Now I have you only one of the many money - salaries named, become you
> over that informed after registration.
> The advantage in THIS mail - list - registration is:
> - For the registrations in the E-mail-list I get money
> - After the registration receive I knowledge over money and would earn in
> addition, more than I in the mail - list - registrations would receive.
> I was read had to beginning also sceptical, but as I the letter, knew I
> that I get also something good for my money, and have invests above all,
> MORE than I.
> ONLY if I get something, the other can earn also, is that the logical
> answer.
> Can if you earn in an investment of 12 Euros / 12 U.S. dollars or 12
> British pounds (sterlings) of thousand and also hundred cable envoy, you
> not would transmit yourself information that bring you yet more money?
> Therefore it is entirely clear that the applicant sends also the
> information REALLY at the registered, unlike in so-called " mail - lists
> ", where one waits long on that (usually in vain).
> Swell through the further money - is certain, that THIS program functions,
> or would become you you in comparison with 100,000 with only 12 Euros /
> satisfied give 12 U.S. dollars or 12 British pounds (sterlings)?
> I got, above all, more in my investment of 12 Euros already in short time
> than that hundredfold thanks to which mail - information.
> If you decide to register you in the mail - list, would follow the
> directions:
> You become now part at the mail order business:
> Would follow the directions:
> 1 stepped:
> If you are yet no Paypal-user, a user COST-FREE - account (Premium -
> basis - account) opens now in Paypal. Paypal is with more than 96 million
> users and with representation in more than 56 countries of one of the most
> certain money - transfers - business worldwide.
> click up: https://www.paypal.com
> (should that be left not active, would copy it please into your browser)
> Stepped 2:
> Would register you in the " mail - list".
> Send 12 Euro / 12 US - Dollar or 12 British Pounds (sterling) at the FIRST
> mail-address per mail
> - For use-purpose you write: " Service "
> - For E-mail-reference you write: " Mail - list "
> How you can send money, you find on the web page of Paypal simply
> declared.
> The present list:
> (#1) bestwaybook@.yahoo.de
> (#2) luxusbook@.yahoo.de
> (#3) ecashmail@.yahoo.de
> Through the fast payment per enamel and the reception, it lasts only few
> Would meet until you get the information per E-MAIL.
> As soon as your registration arrived in the receiver, you get further
> information / insider - knowledge. Would keep in mind always, ONLY if you
> also salary, earn other with.
> COMMENT:
> Would follow steps 3 FIRST THEN AFTER you received the information /
> insiders - knowledge.
> Only if you have the information / insiders - knowledge, you can transmit
> this also.
> Here it does not concern simply only mail - earn collections, but rather
> around CORRECT money.
> Stepped 3:
> Now that would paint see #1 of the list that you above and back the other
> names after.
> The address at the position #2 you write on position #1
> The address at the position #3 you write on position #2
> After that you write YOUR address on position #3.
> Was ready on an exciting and interesting type, to earn money.
>
>
(First Copy this Text in your editor)
Translated Text (sorry if the Text is not in good grammer).
I have earned over 40,000 Euros after participate in this program.
Before short, I have myself in the following mails - list registered.
Later I got an E-MAIL, that said me, how and where I get IMMEDIATELY a money
in opening - gift of more than 20 Euros. In addition I earn WITHOUT EDITIONS
at a system with more than 4 steps. It is obvious that such information is
not told simply cost-free at all world. The mails - list with which I had
registered me, informed me per E-MAIL about this new business.
Now I have you only one of the many money - salaries named, become you over
that informed after registration.
The advantage in THIS mail - list - registration is:
- For the registrations in the E-mail-list I get money
- After the registration receive I knowledge over money and would earn in
addition, more than I in the mail - list - registrations would receive.
I was read had to beginning also sceptical, but as I the letter, knew I that
I get also something good for my money, and have invests above all, MORE
than I.
ONLY if I get something, the other can earn also, is that the logical
answer.
Can if you earn in an investment of 12 Euros / 12 U.S. dollars or 12 British
pounds (sterlings) of thousand and also hundred cable envoy, you not would
transmit yourself information that bring you yet more money?
Therefore it is entirely clear that the applicant sends also the information
REALLY at the registered, unlike in so-called " mail - lists ", where one
waits long on that (usually in vain).
Swell through the further money - is certain, that THIS program functions,
or would become you you in comparison with 100,000 with only 12 Euros /
satisfied give 12 U.S. dollars or 12 British pounds (sterlings)?
I got, above all, more in my investment of 12 Euros already in short time
than that hundredfold thanks to which mail - information.
If you decide to register you in the mail - list, would follow the
directions:
You become now part at the mail order business:
Would follow the directions:
1 stepped:
If you are yet no Paypal-user, a user COST-FREE - account (Premium - basis -
account) opens now in Paypal. Paypal is with more than 96 million users and
with representation in more than 56 countries of one of the most certain
money - transfers - business worldwide.
click up: https://www.paypal.com
(should that be left not active, would copy it please into your browser)
Stepped 2:
Would register you in the " mail - list".
Send 12 Euro / 12 US - Dollar or 12 British Pounds (sterling) at the FIRST
mail-address per mail
- For use-purpose you write: " Service "
- For E-mail-reference you write: " Mail - list "
How you can send money, you find on the web page of Paypal simply declared.
The present list:
(#1) bestwaybook@.yahoo.de
(#2) luxusbook@.yahoo.de
(#3) ecashmail@.yahoo.de
Through the fast payment per enamel and the reception, it lasts only few
Would meet until you get the information per E-MAIL.
As soon as your registration arrived in the receiver, you get further
information / insider - knowledge. Would keep in mind always, ONLY if you
also salary, earn other with.
COMMENT:
Would follow steps 3 FIRST THEN AFTER you received the information /
insiders - knowledge.
Only if you have the information / insiders - knowledge, you can transmit
this also.
Here it does not concern simply only mail - earn collections, but rather
around CORRECT money.
Stepped 3:
Now that would paint see #1 of the list that you above and back the other
names after.
The address at the position #2 you write on position #1
The address at the position #3 you write on position #2
After that you write YOUR address on position #3.
Was ready on an exciting and interesting type, to earn money.Your sister will earn12 Euros from me the next time I'm at Oktoberfest.
;-)
"INSIDER - KNOWLEDGE!!" <new-power@.invest.net> wrote in message
news:e0iIG50UGHA.1688@.TK2MSFTNGP11.phx.gbl...
> INSIDER - KNOWLEDGE NEUTRALIZING!!
> (First Copy this Text in your editor)
> Translated Text (sorry if the Text is not in good grammer).
>
> I have earned over 40,000 Euros after participate in this program.
> Before short, I have myself in the following mails - list registered.
> Later I got an E-MAIL, that said me, how and where I get IMMEDIATELY a
> money in opening - gift of more than 20 Euros. In addition I earn WITHOUT
> EDITIONS at a system with more than 4 steps. It is obvious that such
> information is not told simply cost-free at all world. The mails - list
> with which I had registered me, informed me per E-MAIL about this new
> business.
> Now I have you only one of the many money - salaries named, become you
> over that informed after registration.
> The advantage in THIS mail - list - registration is:
> - For the registrations in the E-mail-list I get money
> - After the registration receive I knowledge over money and would earn in
> addition, more than I in the mail - list - registrations would receive.
> I was read had to beginning also sceptical, but as I the letter, knew I
> that I get also something good for my money, and have invests above all,
> MORE than I.
> ONLY if I get something, the other can earn also, is that the logical
> answer.
> Can if you earn in an investment of 12 Euros / 12 U.S. dollars or 12
> British pounds (sterlings) of thousand and also hundred cable envoy, you
> not would transmit yourself information that bring you yet more money?
> Therefore it is entirely clear that the applicant sends also the
> information REALLY at the registered, unlike in so-called " mail - lists
> ", where one waits long on that (usually in vain).
> Swell through the further money - is certain, that THIS program functions,
> or would become you you in comparison with 100,000 with only 12 Euros /
> satisfied give 12 U.S. dollars or 12 British pounds (sterlings)?
> I got, above all, more in my investment of 12 Euros already in short time
> than that hundredfold thanks to which mail - information.
> If you decide to register you in the mail - list, would follow the
> directions:
> You become now part at the mail order business:
> Would follow the directions:
> 1 stepped:
> If you are yet no Paypal-user, a user COST-FREE - account (Premium -
> basis - account) opens now in Paypal. Paypal is with more than 96 million
> users and with representation in more than 56 countries of one of the most
> certain money - transfers - business worldwide.
> click up: https://www.paypal.com
> (should that be left not active, would copy it please into your browser)
> Stepped 2:
> Would register you in the " mail - list".
> Send 12 Euro / 12 US - Dollar or 12 British Pounds (sterling) at the FIRST
> mail-address per mail
> - For use-purpose you write: " Service "
> - For E-mail-reference you write: " Mail - list "
> How you can send money, you find on the web page of Paypal simply
> declared.
> The present list:
> (#1) bestwaybook@.yahoo.de
> (#2) luxusbook@.yahoo.de
> (#3) ecashmail@.yahoo.de
> Through the fast payment per enamel and the reception, it lasts only few
> Would meet until you get the information per E-MAIL.
> As soon as your registration arrived in the receiver, you get further
> information / insider - knowledge. Would keep in mind always, ONLY if you
> also salary, earn other with.
> COMMENT:
> Would follow steps 3 FIRST THEN AFTER you received the information /
> insiders - knowledge.
> Only if you have the information / insiders - knowledge, you can transmit
> this also.
> Here it does not concern simply only mail - earn collections, but rather
> around CORRECT money.
> Stepped 3:
> Now that would paint see #1 of the list that you above and back the other
> names after.
> The address at the position #2 you write on position #1
> The address at the position #3 you write on position #2
> After that you write YOUR address on position #3.
> Was ready on an exciting and interesting type, to earn money.
>
>
Friday, March 9, 2012
Inside SQL Server
A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
circumstances, I never got around to reading it.
About a week ago, I finaly had time to start reading. I must say I
really enjoy getting to know all the mechanics and inner workings of
SQL Server and some of the backgrounds provided might help me create
more efficient databases.
On the other hand, I am well aware that my professional focus now has
to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
find myself wondering how much of what I read still applies to SQL
Server 2000. Have there been major reworkings of the inner mechanics
of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
read somewhere) "the same as 7.0 but with XML support thrown in"?
Basically, what I want to know is how I can make the best use of my
limited time and money:
a) Continue reading, but order "Inside SQL Server 2000" as well; check
out the differences between the books when the latter arrives.
b) Order "Inside SQL Server 2000" first. Stop reading for now and read
only the 2000 edition.
c) Don't bother with "Inside SQL Server 2000" until I need information
on specific aspects of SQL Server 2000 (like XML?). Spend the money
saved to treat my children to an extra ice cream.
Any insights on this would be greatly appreciated!
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)Hugo
Creat books
a) Continue reading, but order "Inside SQL Server 2000" as well; check
out the differences between the books when the latter arrives
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
> A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
> Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
> circumstances, I never got around to reading it.
> About a week ago, I finaly had time to start reading. I must say I
> really enjoy getting to know all the mechanics and inner workings of
> SQL Server and some of the backgrounds provided might help me create
> more efficient databases.
> On the other hand, I am well aware that my professional focus now has
> to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
> find myself wondering how much of what I read still applies to SQL
> Server 2000. Have there been major reworkings of the inner mechanics
> of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
> read somewhere) "the same as 7.0 but with XML support thrown in"?
> Basically, what I want to know is how I can make the best use of my
> limited time and money:
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives.
> b) Order "Inside SQL Server 2000" first. Stop reading for now and read
> only the 2000 edition.
> c) Don't bother with "Inside SQL Server 2000" until I need information
> on specific aspects of SQL Server 2000 (like XML?). Spend the money
> saved to treat my children to an extra ice cream.
> Any insights on this would be greatly appreciated!
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||Hugo,
Difficult... I'd say it partly depends on how much you understand and
remember right now. You could continue reading, check differences and use
the second pass as repetition. However, it might not be easy to spot the
differences when you get the 2000 edition, which would suggest stop reading
and wait for a while.
I think the Inside book is great if you are the intended audience, so I
definitely recommend that you go for the 2000 edition. I would probably go
for option B, stop reading and continue when you get the 2000 edition.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
> A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
> Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
> circumstances, I never got around to reading it.
> About a week ago, I finaly had time to start reading. I must say I
> really enjoy getting to know all the mechanics and inner workings of
> SQL Server and some of the backgrounds provided might help me create
> more efficient databases.
> On the other hand, I am well aware that my professional focus now has
> to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
> find myself wondering how much of what I read still applies to SQL
> Server 2000. Have there been major reworkings of the inner mechanics
> of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
> read somewhere) "the same as 7.0 but with XML support thrown in"?
> Basically, what I want to know is how I can make the best use of my
> limited time and money:
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives.
> b) Order "Inside SQL Server 2000" first. Stop reading for now and read
> only the 2000 edition.
> c) Don't bother with "Inside SQL Server 2000" until I need information
> on specific aspects of SQL Server 2000 (like XML?). Spend the money
> saved to treat my children to an extra ice cream.
> Any insights on this would be greatly appreciated!
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||Tibor
I hold in respect for you, your experience but permit me to be not agree
with you.
There a lots of things which don't change since we read 'inside 7.0'
At this time we can say , hey wait for SQL Server 2005 because inside 2000
might or might not be relevant.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ORhWeV0CEHA.2052@.TK2MSFTNGP11.phx.gbl...
> Hugo,
> Difficult... I'd say it partly depends on how much you understand and
> remember right now. You could continue reading, check differences and use
> the second pass as repetition. However, it might not be easy to spot the
> differences when you get the 2000 edition, which would suggest stop
reading
> and wait for a while.
> I think the Inside book is great if you are the intended audience, so I
> definitely recommend that you go for the 2000 edition. I would probably go
> for option B, stop reading and continue when you get the 2000 edition.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
> news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
>|||Disagreeing is OK, Uri :-)
Yes, it is a close call, I agree.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O0gDSl0CEHA.308@.TK2MSFTNGP11.phx.gbl...
> Tibor
> I hold in respect for you, your experience but permit me to be not agree
> with you.
> There a lots of things which don't change since we read 'inside 7.0'
> At this time we can say , hey wait for SQL Server 2005 because inside 2000
> might or might not be relevant.
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ORhWeV0CEHA.2052@.TK2MSFTNGP11.phx.gbl...
use
> reading
go
>|||Uri Dimant wrote:
> Hugo
> Creat books
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives
I must agree with this. As others have noted that are not that many
differences and I also know that for myself it took me a few reads
before I even fully understood why certain things were important. (Why
did I have to know what a page and extant were?) So I would definably
read the 7 book first, then once you finish that, start reading the 2000
book, then hopefully when you are done with that you can read the 2005
book. Another added benefit of reading 7 before 2000 is that it saves
your 2000 copy from getting worn down so quickly. I'm to the point where
I need to get another copy, except I've been a little leery because I'm
so excited to get a hold of 2005 (Yukon).
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/|||Hi Hugo
The actual differences between the products are minimal in terms of what is
covered in the 2000 version. There was a slight change to the way rows on a
page are organized and what it means for the rows to be 'in order'. I also
greatly expanded the details of internal index storage and gave indexes
their own chapter. There were also a few small optimizer changes.
But most of the work of the 2000 version was the new features:
LOTS of details on Recovery Models (new feature)
More details on the internals of backup and restore
User Defined Functions, creation and optimization (this is a brand new
feature)
Lots of details on new database options and ALTER DATABASE
Lots of details about creation and use of Indexed Views for performance
enhancement
Details on 'instead of' triggers
etc.
So if you want details of these NEW features, you need the new version of
the book.
(But, XML is NOT included because in SQL Server 2000, XML is not "Inside"
SQL Server. It is only a thin wrapper around it. )
But, I would think that ice cream for your kids was more important.
However, if you buy the book, the royalties might be enough for me to buy an
extra ice cream for MY kids.
:-)
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
> A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
> Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
> circumstances, I never got around to reading it.
> About a week ago, I finaly had time to start reading. I must say I
> really enjoy getting to know all the mechanics and inner workings of
> SQL Server and some of the backgrounds provided might help me create
> more efficient databases.
> On the other hand, I am well aware that my professional focus now has
> to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
> find myself wondering how much of what I read still applies to SQL
> Server 2000. Have there been major reworkings of the inner mechanics
> of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
> read somewhere) "the same as 7.0 but with XML support thrown in"?
> Basically, what I want to know is how I can make the best use of my
> limited time and money:
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives.
> b) Order "Inside SQL Server 2000" first. Stop reading for now and read
> only the 2000 edition.
> c) Don't bother with "Inside SQL Server 2000" until I need information
> on specific aspects of SQL Server 2000 (like XML?). Spend the money
> saved to treat my children to an extra ice cream.
> Any insights on this would be greatly appreciated!
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||On Tue, 16 Mar 2004 08:28:24 -0800, Kalen Delaney wrote:
>But, I would think that ice cream for your kids was more important.
>However, if you buy the book, the royalties might be enough for me to buy a
n
>extra ice cream for MY kids.
LOL!!
I'll see if my next assignment will earn me enough to buy the book AND
some ice cream. That would make all kids happy.
Thanks, Kalen, for your detailed explanation of the differences. I
didn't even realize how many of the features I use heavily are new.
I'm glad to know that my current reading is not a waste of time, but
you certainly made me eager to start reading about the 2000-specific
deatils as well.
Thanks as well for writing a great book!
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
circumstances, I never got around to reading it.
About a week ago, I finaly had time to start reading. I must say I
really enjoy getting to know all the mechanics and inner workings of
SQL Server and some of the backgrounds provided might help me create
more efficient databases.
On the other hand, I am well aware that my professional focus now has
to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
find myself wondering how much of what I read still applies to SQL
Server 2000. Have there been major reworkings of the inner mechanics
of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
read somewhere) "the same as 7.0 but with XML support thrown in"?
Basically, what I want to know is how I can make the best use of my
limited time and money:
a) Continue reading, but order "Inside SQL Server 2000" as well; check
out the differences between the books when the latter arrives.
b) Order "Inside SQL Server 2000" first. Stop reading for now and read
only the 2000 edition.
c) Don't bother with "Inside SQL Server 2000" until I need information
on specific aspects of SQL Server 2000 (like XML?). Spend the money
saved to treat my children to an extra ice cream.
Any insights on this would be greatly appreciated!
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)Hugo
Creat books
a) Continue reading, but order "Inside SQL Server 2000" as well; check
out the differences between the books when the latter arrives
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
> A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
> Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
> circumstances, I never got around to reading it.
> About a week ago, I finaly had time to start reading. I must say I
> really enjoy getting to know all the mechanics and inner workings of
> SQL Server and some of the backgrounds provided might help me create
> more efficient databases.
> On the other hand, I am well aware that my professional focus now has
> to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
> find myself wondering how much of what I read still applies to SQL
> Server 2000. Have there been major reworkings of the inner mechanics
> of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
> read somewhere) "the same as 7.0 but with XML support thrown in"?
> Basically, what I want to know is how I can make the best use of my
> limited time and money:
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives.
> b) Order "Inside SQL Server 2000" first. Stop reading for now and read
> only the 2000 edition.
> c) Don't bother with "Inside SQL Server 2000" until I need information
> on specific aspects of SQL Server 2000 (like XML?). Spend the money
> saved to treat my children to an extra ice cream.
> Any insights on this would be greatly appreciated!
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||Hugo,
Difficult... I'd say it partly depends on how much you understand and
remember right now. You could continue reading, check differences and use
the second pass as repetition. However, it might not be easy to spot the
differences when you get the 2000 edition, which would suggest stop reading
and wait for a while.
I think the Inside book is great if you are the intended audience, so I
definitely recommend that you go for the 2000 edition. I would probably go
for option B, stop reading and continue when you get the 2000 edition.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
> A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
> Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
> circumstances, I never got around to reading it.
> About a week ago, I finaly had time to start reading. I must say I
> really enjoy getting to know all the mechanics and inner workings of
> SQL Server and some of the backgrounds provided might help me create
> more efficient databases.
> On the other hand, I am well aware that my professional focus now has
> to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
> find myself wondering how much of what I read still applies to SQL
> Server 2000. Have there been major reworkings of the inner mechanics
> of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
> read somewhere) "the same as 7.0 but with XML support thrown in"?
> Basically, what I want to know is how I can make the best use of my
> limited time and money:
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives.
> b) Order "Inside SQL Server 2000" first. Stop reading for now and read
> only the 2000 edition.
> c) Don't bother with "Inside SQL Server 2000" until I need information
> on specific aspects of SQL Server 2000 (like XML?). Spend the money
> saved to treat my children to an extra ice cream.
> Any insights on this would be greatly appreciated!
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||Tibor
I hold in respect for you, your experience but permit me to be not agree
with you.
There a lots of things which don't change since we read 'inside 7.0'
At this time we can say , hey wait for SQL Server 2005 because inside 2000
might or might not be relevant.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ORhWeV0CEHA.2052@.TK2MSFTNGP11.phx.gbl...
> Hugo,
> Difficult... I'd say it partly depends on how much you understand and
> remember right now. You could continue reading, check differences and use
> the second pass as repetition. However, it might not be easy to spot the
> differences when you get the 2000 edition, which would suggest stop
reading
> and wait for a while.
> I think the Inside book is great if you are the intended audience, so I
> definitely recommend that you go for the 2000 edition. I would probably go
> for option B, stop reading and continue when you get the 2000 edition.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
> news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
>|||Disagreeing is OK, Uri :-)
Yes, it is a close call, I agree.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O0gDSl0CEHA.308@.TK2MSFTNGP11.phx.gbl...
> Tibor
> I hold in respect for you, your experience but permit me to be not agree
> with you.
> There a lots of things which don't change since we read 'inside 7.0'
> At this time we can say , hey wait for SQL Server 2005 because inside 2000
> might or might not be relevant.
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ORhWeV0CEHA.2052@.TK2MSFTNGP11.phx.gbl...
use
> reading
go
>|||Uri Dimant wrote:
> Hugo
> Creat books
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives
I must agree with this. As others have noted that are not that many
differences and I also know that for myself it took me a few reads
before I even fully understood why certain things were important. (Why
did I have to know what a page and extant were?) So I would definably
read the 7 book first, then once you finish that, start reading the 2000
book, then hopefully when you are done with that you can read the 2005
book. Another added benefit of reading 7 before 2000 is that it saves
your 2000 copy from getting worn down so quickly. I'm to the point where
I need to get another copy, except I've been a little leery because I'm
so excited to get a hold of 2005 (Yukon).
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/|||Hi Hugo
The actual differences between the products are minimal in terms of what is
covered in the 2000 version. There was a slight change to the way rows on a
page are organized and what it means for the rows to be 'in order'. I also
greatly expanded the details of internal index storage and gave indexes
their own chapter. There were also a few small optimizer changes.
But most of the work of the 2000 version was the new features:
LOTS of details on Recovery Models (new feature)
More details on the internals of backup and restore
User Defined Functions, creation and optimization (this is a brand new
feature)
Lots of details on new database options and ALTER DATABASE
Lots of details about creation and use of Indexed Views for performance
enhancement
Details on 'instead of' triggers
etc.
So if you want details of these NEW features, you need the new version of
the book.
(But, XML is NOT included because in SQL Server 2000, XML is not "Inside"
SQL Server. It is only a thin wrapper around it. )
But, I would think that ice cream for your kids was more important.
However, if you buy the book, the royalties might be enough for me to buy an
extra ice cream for MY kids.
:-)
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
> A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
> Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
> circumstances, I never got around to reading it.
> About a week ago, I finaly had time to start reading. I must say I
> really enjoy getting to know all the mechanics and inner workings of
> SQL Server and some of the backgrounds provided might help me create
> more efficient databases.
> On the other hand, I am well aware that my professional focus now has
> to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
> find myself wondering how much of what I read still applies to SQL
> Server 2000. Have there been major reworkings of the inner mechanics
> of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
> read somewhere) "the same as 7.0 but with XML support thrown in"?
> Basically, what I want to know is how I can make the best use of my
> limited time and money:
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives.
> b) Order "Inside SQL Server 2000" first. Stop reading for now and read
> only the 2000 edition.
> c) Don't bother with "Inside SQL Server 2000" until I need information
> on specific aspects of SQL Server 2000 (like XML?). Spend the money
> saved to treat my children to an extra ice cream.
> Any insights on this would be greatly appreciated!
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||On Tue, 16 Mar 2004 08:28:24 -0800, Kalen Delaney wrote:
>But, I would think that ice cream for your kids was more important.
>However, if you buy the book, the royalties might be enough for me to buy a
n
>extra ice cream for MY kids.
LOL!!
I'll see if my next assignment will earn me enough to buy the book AND
some ice cream. That would make all kids happy.
Thanks, Kalen, for your detailed explanation of the differences. I
didn't even realize how many of the features I use heavily are new.
I'm glad to know that my current reading is not a waste of time, but
you certainly made me eager to start reading about the 2000-specific
deatils as well.
Thanks as well for writing a great book!
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Sunday, February 19, 2012
Inserting Nulls with DTS
I am using a DTS package to copy data from a flat file to a table. I need for fields that are empty to be changed to nulls in the output. I wrote a VB Script to do this, but now it takes about 10 times longer that when I used the Copy transformation. Is there a faster way to do this?
I haven't tried the Trim transformation yet. (I'm waiting for my load to finish.) Will that place nulls in the output if a field is empty?Originally posted by jsneeringer
I am using a DTS package to copy data from a flat file to a table. I need for fields that are empty to be changed to nulls in the output. I wrote a VB Script to do this, but now it takes about 10 times longer that when I used the Copy transformation. Is there a faster way to do this?
I haven't tried the Trim transformation yet. (I'm waiting for my load to finish.) Will that place nulls in the output if a field is empty?
Hi,
1-in your SQL Server Table ( Destination DB) set a default value for the field(s), so when you attemp to insert Null value in that Field, the specified default vale will be insert. ( the way of inserting is not important . It can be DTS!!)
2- you can also write a Instead Of Trigger on your Table For Insert, so process the field value, if it's Null , write empty.
Hope that help you
I haven't tried the Trim transformation yet. (I'm waiting for my load to finish.) Will that place nulls in the output if a field is empty?Originally posted by jsneeringer
I am using a DTS package to copy data from a flat file to a table. I need for fields that are empty to be changed to nulls in the output. I wrote a VB Script to do this, but now it takes about 10 times longer that when I used the Copy transformation. Is there a faster way to do this?
I haven't tried the Trim transformation yet. (I'm waiting for my load to finish.) Will that place nulls in the output if a field is empty?
Hi,
1-in your SQL Server Table ( Destination DB) set a default value for the field(s), so when you attemp to insert Null value in that Field, the specified default vale will be insert. ( the way of inserting is not important . It can be DTS!!)
2- you can also write a Instead Of Trigger on your Table For Insert, so process the field value, if it's Null , write empty.
Hope that help you
Subscribe to:
Posts (Atom)