Viewing 15 posts - 46 through 60 (of 3,060 total)
nikunj_lodhi (7/3/2013)
@paul-2: I want to use the same instance number for ten different servers so dats y i was looking for it
Oracle instances are identified by the SID defined by...
_____________________________________
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.July 3, 2013 at 9:38 am
BlackGarlic (6/25/2013)
We are trying to expand existing datamart for patient visit monitoring, and I would like to get some suggestion or recommendation from DW experts here on SQL...
_____________________________________
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.July 3, 2013 at 9:30 am
nikunj_lodhi (7/2/2013)
I wanted to know that can we have a single instance on two different databases?
Since this was posted on the Oracle section of the forum, please allow me to...
_____________________________________
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.July 3, 2013 at 8:50 am
sdhines3 (6/21/2013)
case when First.Name is null then ???
Life is complicated enough, why try to force the use of "case" there?
_____________________________________
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 21, 2013 at 10:55 am
chapunic (6/20/2013)
Can i use ssrs to get sql metadata?
Yes. Please check this SSC paper http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/74303/
_____________________________________
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 20, 2013 at 12:39 pm
Shadab Shah (6/19/2013)
What are Windows System Commands in SQL Server? i got this jargoan from msdn website http://msdn.microsoft.com/en-us/library/ms174187.aspx.I tried googling it but to no avail. Please help.
http://www.sqlserver-training.com/sql-server-windows-powershell/-
Hope this helps...
_____________________________________
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 19, 2013 at 12:41 pm
SQL_Surfer (6/16/2013)
1)A table with 200 fields. OR
2)200 fields spanning across multiple tables? For e.g 10 tables with 20 fields each.
Which one is better in terms of performance and space...
_____________________________________
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 17, 2013 at 6:51 am
Hard to tell for sure since poster cleaned up the original post but, ORA-04091 "Mutating Table Error" happens when a trigger attempts to select from, update or delete on 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.June 14, 2013 at 12:05 pm
m.rajesh.uk (6/14/2013)
Even the support for Sql server 2000 is discontinued. So i just eliminated the previous versions.
Support discontinued doesn't mean it is not in use - you would...
_____________________________________
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, 2013 at 7:02 am
No SQL Server 4.2? 6.0? 6.5? 7? on the poll? that's discrimination! 😛
_____________________________________
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, 2013 at 6:35 am
niha.736 (6/12/2013)
If you can provide some more information on this, It will help me to understand better.
1. will degenerate dimension contain only one attribute...
_____________________________________
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, 2013 at 5:07 pm
I do agree with Alexander.
Performance statistics are as good as the execution plan they help to select.
In my experience, in most cases, the more accurate performance statistics are the better...
_____________________________________
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 12, 2013 at 11:08 am
:doze: Barry, moving the discusion to a personal level, making assumptions about what other people may know or not and putting on other people's mouth words they have never...
_____________________________________
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 12, 2013 at 8:14 am
niha.736 (6/12/2013)
Please help in understanding the degenerate dim.
We call degenerate dimension a dimension key (sitting on a fact table) that does not have an actual dimension table related. An...
_____________________________________
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 12, 2013 at 7:54 am
Karthiart (6/12/2013)
Please help me on this, what are the approaches/steps to create the partition.
Building up on previous post, there is a very nice paper published on SQLServerCentral too, please check...
_____________________________________
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 12, 2013 at 7:19 am
Viewing 15 posts - 46 through 60 (of 3,060 total)