Viewing 15 posts - 1,996 through 2,010 (of 3,060 total)
praviii... (5/6/2010)
hi could any one suggest me the edition that should be installed for working on sql server 2008 at work.
How about the business requirements?
What kind of operation are going...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 6, 2010 at 1:45 pm
mashtal_et_1982 (5/6/2010)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 6, 2010 at 1:26 pm
sturner (5/6/2010)
Put them all into one XML column. ;^)
You made my day! 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 6, 2010 at 1:23 pm
About two years after starting working with Oracle is when you will start to realize how different are SQL Server and Oracle implementations of the same basic principles.
Question is, do...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 6, 2010 at 1:18 pm
trivedi.nikesh (5/5/2010)
But I am looking for, list of those background activities, which are perform for SQL Server when is starts from scratch or restarts.
:blink: This is the "Working with Oracle"...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 6, 2010 at 1:12 pm
hedera (5/2/2010)
Thanks to the kind people who tried to give me advice.
Glad to help - Thank you for the feedback 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 6, 2010 at 1:08 pm
The good news is that a 600 Gig database is not such a large database - there should be no problems to properly maintain it; providing it is done the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 6, 2010 at 1:00 pm
senapathi_siva (3/23/2009)
But when I am running the specified query, I am getting the following error. 'ORA-00933: SQL command not properly ended.'
This is invalid syntax on the Oracle world - not...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 6, 2010 at 12:48 pm
The Oracle term "materialized view" represents nothing but a table that is updated or refresh in an automatized way.
There is a plain Oracle "table" for each "materialized view"
Questions is...
- How...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 30, 2010 at 12:51 pm
99posts (4/30/2010)
select distinct chips, salt --, datefrom SNACKS
where SNACKS .salt= 'No'
AND chips NOT IN(select distinct chips from SNACKS where salt= 'No')
order by chips asc
If what you want...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 30, 2010 at 12:39 pm
Welcome to the wonderful world of troubleshooting.
"ceased working" is too broad of an expression...
... I'll find out if the host is alive
... I'll find out if the offending instance...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 30, 2010 at 9:34 am
kjplreddy 85311 (4/30/2010)
were can i run thread on sql server?wat is the use of threads?
1- You don't - SQL Server does.
2- Divide app logic into multiple, concurrent execution paths.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 30, 2010 at 9:22 am
mohan.pariveda (4/30/2010)
As per the client requirement, he want all the alerts & Databases( SQL & ORACLe) need to monitored...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 30, 2010 at 9:00 am
GregoryF (4/30/2010)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 30, 2010 at 8:55 am
anna_lyn00 (4/30/2010)
The other reason people use scaleout is to service a web front-end.
Being this a SQL Server forum not a web services one this has to be spam, isn't it?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 30, 2010 at 7:09 am
Viewing 15 posts - 1,996 through 2,010 (of 3,060 total)