Viewing 15 posts - 151 through 165 (of 3,061 total)
msanchez7 (1/5/2013)
Yeah this is my first time dealing with SQL, thank you for your support, it's good to know that there are people who help as much as they can.
Is...
January 22, 2013 at 7:02 pm
Anthony Stephens (12/16/2012)
January 22, 2013 at 6:48 pm
Raghu.K (12/28/2012)
Which one is better (Performance wise)
1.Join all 4 tables and write table1 where conditions globally...
January 22, 2013 at 6:35 pm
sej2008 (1/19/2013)
sps?
Similarly can userdefined sps can call udf in its logic?
can view call system sps or functions...
January 19, 2013 at 9:17 am
wshelton 51985 (1/14/2013)
January 18, 2013 at 1:50 pm
Thank you for the feedback Swarren - other people will certainly benefit from it.
January 18, 2013 at 1:41 pm
In my opinion option #1 would be more elegant.
No performance advantages in going with option #2.
January 18, 2013 at 1:39 pm
lonhanner (1/18/2013)
Please tell me if the table structure is a one-to-many.
Yes, it is a 1-n relationship.
January 18, 2013 at 11:58 am
Root cause of the issue is that the connection is timing out.
Check sqlnet_timeout settings.
January 18, 2013 at 11:10 am
sqlbi.vvamsi (11/30/2012)
Based on what I know, Materialized View Log is a master table that can capture deletes/inserts/updates just like CDC tables.
You are correct, Materialized Views are an Oracle concept.
Having said...
December 3, 2012 at 7:38 am
bugg (11/17/2012)
The standard way to add a new column to a table is more or less the following.alter table table_name add column column_name...
That is NOT "more or less" alter...
November 17, 2012 at 10:18 am
A DBA position is usually the last technical position of a much larger IT career.
Certifications are good in two senses, #1 You get to learn the general topics you are...
November 12, 2012 at 9:57 am
imani_technology (11/6/2012)
November 12, 2012 at 9:38 am
imani_technology (11/5/2012)
factEmployeeWorkHours
PK ID
LastName
FirstName
Hours
The fact table joins to a dimension table that looks like the following:
dimOrganization
PK ID
EmployeeLastName
EmployeeFirstName
Store
StoreManager
RegionalManager
VP
Region
State
But...
November 12, 2012 at 9:29 am
RK2012 (11/1/2012)
How to corelate between oracle dba concepts and sqlserver dba concepts
Since both Oracle and SQL Server are implementations of the same underlying theory their "concepts" are pretty much the...
November 12, 2012 at 8:49 am
Viewing 15 posts - 151 through 165 (of 3,061 total)