Viewing 15 posts - 46 through 60 (of 3,060 total)
nikunj_lodhi (7/3/2013)
@Paul: 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...
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...
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...
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?
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/
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...
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...
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...
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...
June 14, 2013 at 7:02 am
No SQL Server 4.2? 6.0? 6.5? 7? on the poll? that's discrimination! 😛
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...
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...
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...
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...
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...
June 12, 2013 at 7:19 am
Viewing 15 posts - 46 through 60 (of 3,060 total)