Viewing 15 posts - 2,581 through 2,595 (of 3,060 total)
In the Oracle world roles are usually granted once to an specific user so that user account will inherit all privileges associated with the role each time it logs in...
_____________________________________
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 8, 2009 at 8:07 am
It all depends.
If SQL Server 2000 is not needed and there is no database to be upgraded to 2005 just uninstall SS2K and install SS2K5
If SQL Server is still needed...
_____________________________________
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 8, 2009 at 8:00 am
raj more (5/7/2009)
I was wondering if it was the Express edition - since it only allows a limited number of active connections.
Not sure how reaching the max number of allowed...
_____________________________________
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 7, 2009 at 2:01 pm
For the specific query in the described scenario only two of the tables enter into play: DimDate and FactTransactions; as I can see it there is a 1-to-n relationship in...
_____________________________________
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 7, 2009 at 1:20 pm
Igor Makedon (5/7/2009)It looks like Pablo(3:20 PM) was mistaken with his "1." statement.
My fault, I'm sorry.
I was relying on my experience on previous SS versions; looks like SS2K5 has...
_____________________________________
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 7, 2009 at 12:43 pm
CREATE ROLE NEWROLE NOT IDENTIFIED
;
GRANT NEWROLE TO USERACCOUNT
;
ALTER USER USERACCOUNT DEFAULT ROLE NEWROLE,
...
_____________________________________
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 7, 2009 at 9:16 am
Igor Makedon (5/7/2009)
My question is: "Is it possible and if yes, what needs to be done to hide this score of embarrassing database names from users (many of them) who...
_____________________________________
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 7, 2009 at 8:20 am
The more compression you use the more you penalize the backup process in terms of processing -the more compression the more complex the algorithm.
Restore would benefit of reading a small...
_____________________________________
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 7, 2009 at 6:52 am
rajdvs28 (5/4/2009)It would be a better idea to partition the database table to accommodate future growth in terms of columns. That means column partitioning so that the data rows are...
_____________________________________
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 7, 2009 at 6:47 am
I'll pick Space utilization and Performance; in the last case a chart showing how performance relates to SLA wouldn't hurt and, if good would make you famous among management. Well,...
_____________________________________
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 7, 2009 at 6:42 am
Lets pretend I didn't read the part about affected databases not being part of that server.
Is the offending Maintenance Plan set up to backup "All Databases"?
if this is the case...
_____________________________________
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, 2009 at 3:11 pm
I'm probably missing something in your scenario.
Because of SQL Server security architecture all users have to have a LOGIN entry at the server level then you map that LOGIN entry...
_____________________________________
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, 2009 at 3:05 pm
Krishna Potlakayala (5/6/2009)[DR is the basic building block of a any online business.
I agree but I would add that doesn't matter if the affected systems are supporting an online business...
_____________________________________
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, 2009 at 12:42 pm
mmhhh... you can't touch the code and SQL Server does not supports function based indexes; that moves your issue from the "problem" to the "feature" category -most probably you can...
_____________________________________
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, 2009 at 12:35 pm
usman.tanveer (5/6/2009)I found it through Activity Monitor.
Good!... now show us the locks.
_____________________________________
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, 2009 at 12:31 pm
Viewing 15 posts - 2,581 through 2,595 (of 3,060 total)