Viewing 15 posts - 1,141 through 1,155 (of 3,060 total)
Jamesyoung79 (3/8/2011)
_____________________________________
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.March 8, 2011 at 7:26 am
SQL ORACLE (3/7/2011)
Do you have ideas how to de-partition a table?
On the top of my head...
1- Get partitioned table down to just one partition by merging partitions
2- Once you have...
_____________________________________
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.March 7, 2011 at 4:04 pm
vikingmanm (3/5/2011)
When trying to total a column of numbers, does the data type have to be numeric. Right now it is data type money because they...
_____________________________________
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.March 7, 2011 at 2:59 pm
UMG Developer (3/7/2011)
_____________________________________
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.March 7, 2011 at 2:53 pm
AndrewJacksonZA (3/4/2011)
How do you guys deal with optimising performance when "SELECT * FROM" is involved?
A "select *" is rarely a good idea but I understand you do not have access...
_____________________________________
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.March 4, 2011 at 8:19 am
...also, you may want to somehow "hide" personal and confidential information you do not want to be available to testers and developers like SSN, CC#, salaries, phone numbers, addresses, etc.
Please...
_____________________________________
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.March 1, 2011 at 2:16 pm
marklegosz (2/28/2011)
_____________________________________
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.February 28, 2011 at 4:24 pm
Sridhar-137443 (2/28/2011)
we have a table named "Employees". It has fields company, empno, active and some additional fields like (lastname, firstname, middle name, address etc). I created an index on company,...
_____________________________________
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.February 28, 2011 at 7:53 am
pietlinden (2/27/2011)
Where do I purchase this "Brain Assisted Pen"? Does it have to be assisted by my brain? (What good is that?!)
Go to office depot, office max or...
_____________________________________
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.February 27, 2011 at 1:01 pm
GilaMonster (2/26/2011)
PaulB-TheOneAndOnly (2/26/2011)
if SS2K5 then take a look at "alter database for attach_rebuild_log"if SS2K then take a look at "dbcc rebuild_log"
attach_rebuild_log only works if the DB was cleanly shut down....
_____________________________________
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.February 26, 2011 at 5:49 pm
if SS2K5 then take a look at "alter database for attach_rebuild_log"
if SS2K then take a look at "dbcc rebuild_log"
_____________________________________
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.February 26, 2011 at 2:42 pm
SQL_Student (2/26/2011)
Any suggestions on a recommended open source software that is fast, simple, and thorough in helping me design a ERD for my database? Thank you
Brain Assisted Pen and Notepad...
_____________________________________
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.February 26, 2011 at 2:28 pm
eseosaoregie (2/22/2011)
_____________________________________
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.February 25, 2011 at 2:31 pm
I think you have to read again the specs... specially the part that clearly reads "You are to undertake this assignment individually, although you may discuss ideas with your fellow...
_____________________________________
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.February 25, 2011 at 2:16 pm
Steve.hitch (2/25/2011)
_____________________________________
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.February 25, 2011 at 1:28 pm
Viewing 15 posts - 1,141 through 1,155 (of 3,060 total)