Viewing 15 posts - 1,846 through 1,860 (of 3,060 total)
diva.mayas (6/16/2010)...now i want to move the
FILENAME = 'C:\METADATA\SEC02.NDF' from deault primary file to the
FILEGROUP EMPLOYEE_dETAILS
Can't be moved.
_____________________________________
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.June 16, 2010 at 9:18 am
It all depends on the type of storage subsystem as well as on how the target database uses allocated space e.g. select/insert/update/delete.
On the other hand let me point to two...
_____________________________________
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.June 16, 2010 at 9:04 am
I think you may have more critical issues to look at.
Example:
IncidentTable one-to-many PersonTable
Question:
How do you link these two tables? which column/s hold the relationship?
_____________________________________
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.June 16, 2010 at 8:51 am
Kurt W. Zimmerman (6/16/2010)
I am presently designing a new system and was thinking of pulling out "core" information into a separate database
Chances are there is no need to enforce such...
_____________________________________
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.June 16, 2010 at 8:43 am
Agreed. Research "self-referencing tables"
_____________________________________
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.June 16, 2010 at 8:34 am
Please run and post...
exec sp_helplinkedsrvlogin;
go
_____________________________________
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.June 16, 2010 at 8:26 am
Dynamic SQL allows you to write queries that have the ability to write queries for you.
Having a query that generates queries for you usually saves lots of time during development...
_____________________________________
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.June 14, 2010 at 11:43 am
In regards to gathering stats, fresh stats can be collected using sp_createstats, check here... http://kb.dbatoolz.com/tp/3374.how_to_resize_and_multiplex_redo_group_members.html
Then I'll enable automatic statistics update.
In regards to SS2K5 vs SS2K8 exec plans, the idea is...
_____________________________________
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.June 14, 2010 at 11:29 am
I'll start by gathering fresh performance statistics on SS2K8.
By any chance... do you have either exec plans from SS2K5 or the old SS2K5 still available?
_____________________________________
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.June 14, 2010 at 11:11 am
steveb. (6/3/2010)
I would use tinyint as it is smaller and will ensure your tables never get larger than 255 rows.
Steve is spot-on on this one but this may cause...
_____________________________________
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.June 14, 2010 at 10:43 am
dprudhvi.raju (6/14/2010)
Thanks for all the reply's. I will try to implement.. I will get back if its still a problem... Thank you all
Glad to help.
When working in mixed environment always...
_____________________________________
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.June 14, 2010 at 9:57 am
dprudhvi.raju (6/13/2010)
SELECT * FROM...
_____________________________________
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.June 14, 2010 at 8:13 am
rongaliparvathi (4/26/2010)
I don't know any basics about computer.
That doesn't help - If you are serious about this endeavour you have to get some foundation; if you are a sciences guy...
_____________________________________
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.June 14, 2010 at 8:08 am
balaji.ganga (6/14/2010)
I have created a table name ##a
Please note this is a Global Temporary Table meaning it will be automatically dropped after:
a) the session that created the table disconnects; and
b)...
_____________________________________
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.June 14, 2010 at 7:58 am
Jeff Moden (6/11/2010)Excellent point, Paul. I never understood why Oracle chose to separate "SQL" from "PL/SQL".
That's a very good question which puzzled me for a long time.
Even when I...
_____________________________________
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.June 13, 2010 at 6:24 pm
Viewing 15 posts - 1,846 through 1,860 (of 3,060 total)