Viewing 15 posts - 2,086 through 2,100 (of 3,061 total)
vidya_pande (4/10/2010)
for example -employee and skill many to many relation-
employee
empId [pk]
empName
Skills
skillId [Pk]
SkillName
EmployeeSkills
EmpId[Pk]
SkillId[Pk]
Exactly!
April 10, 2010 at 1:23 pm
Why not natural keys?
RefAtbl <===>> RefBtbl
Columns in RefAtbl... ID; Key = ID
Columns in RefBtbl... ID,OtherNumber; key = (ID+OtherNumber)
April 10, 2010 at 1:19 pm
gratefuldba (4/10/2010)
Does anyone have an opinion as to the merits and disadvantages of using SQL Server maintenance plans to implement our SQL Server database / transaction log backup strategy ?
Easiest...
April 10, 2010 at 1:11 pm
last() returns the last row of a result set - doesn't it?
A brute force solution would be to select top 1 blah-blah-blah order by blah-blah DESC
April 10, 2010 at 1:00 pm
For SQL Server varchar() not larger than 4000 bytes Oracle's varchar2() would do the trick.
For SQL Server varchar() larger than 4000 bytes receiving Oracle column should be a CLOB.
Since CLOB...
April 10, 2010 at 12:55 pm
info-849042 (4/10/2010)
how do I implement a many-to-many relationship in SQL Server
This shold be done at modeling phase independent of the technology of choice therefore you do it as you do...
April 10, 2010 at 6:41 am
datepart() function would do it 😉
April 9, 2010 at 4:49 pm
You are looking for latence then forget the app layer... just ping it. 😉
April 9, 2010 at 4:34 pm
I would schedule a blackout window on SQL Server side so to accomodate Oracle side maintenance window.
April 9, 2010 at 12:05 pm
PaulB - Is there an easy way to describe or point me to something (a name, a website) that would talk about the infrastructure that would support this? Would...
April 9, 2010 at 11:57 am
1- Yes. Depends on infrastructure and design.
2- No. Yes.
3- Sure you can do it. Dozens of choices.
4- Depends on the features you want to have available.
April 8, 2010 at 3:38 pm
I agree with NJ-DBA that transactional replication may be the right solution for this scenario.
The Production-Reporting tandem of databases is a valid strategy - usually a first step in the...
April 8, 2010 at 1:57 pm
Once you got everything in place do the 1-2 punch test...
1- ping whatever dns or ip-address you provided for the host in tnsnames entry
2- after #1 works, tnsping the tnsnames...
April 8, 2010 at 12:47 pm
Just out of curiosity ... does the business requirements really ask to drop a column that is part of a PK? really? :blink:
On the same line of thinking... why if...
April 8, 2010 at 12:42 pm
would you mind in formatting your query properly? pretty please?
April 8, 2010 at 12:38 pm
Viewing 15 posts - 2,086 through 2,100 (of 3,061 total)