Viewing 15 posts - 931 through 945 (of 3,061 total)
Jeff Moden (7/2/2011)
PaulB-TheOneAndOnly (7/2/2011)
I respectfully disagree. I stand by my position which is the only one that allows for responsibilities assignment and accountability.
I wrote a rather long post... what is...
July 3, 2011 at 10:23 am
Chad Slagle (7/1/2011)
July 2, 2011 at 11:52 am
Jeff Moden (7/2/2011)
PaulB-TheOneAndOnly (6/29/2011)
Developer owns the code.Business owns the data.
DBA owns the database environment and is responsible for: Integrity, Availabiltiy, Recoverability and Performance.
Perhaps in your environment.
In our environment, all phases...
July 2, 2011 at 11:47 am
Bad_Karma (7/1/2011)
July 2, 2011 at 11:40 am
Bad_Karma (7/1/2011)
The one big piece I'm questioning is that the designer NEVER executes a cross database query as a rule.
Have you asked the designer why is that rule in place?
May...
July 1, 2011 at 3:27 pm
shanila_minnu (6/30/2011)
How to find out the number of instances installed in a sql server 2000
...or check the Registry looking for registerd instances like:
[HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL] "InstanceName"="MSSQL10_50"
Each installed instance has...
July 1, 2011 at 2:37 pm
venugopal.machina (7/1/2011)
what are sql server protocals
Those are the ISO layer 3 or layer 4 - depending on specific protocol - network/transport means used by SQL Server to interoperate or communicate...
July 1, 2011 at 2:28 pm
newbieuser (5/10/2011)
SELECT * from OPENQUERY(LS, 'SELECT * FROM U.ABO,
U.LED_ID,
U.PROJECT_NO,
T.WORDC,...
July 1, 2011 at 2:18 pm
Jayanth_Kurup (7/1/2011)
Migration of data to oracle via SSIS is probably the best approach but you can also setup replication to Oracle.
Not sure if I would tackle a replication schema for...
July 1, 2011 at 2:12 pm
Sachin4all (7/1/2011)
ya its a dimension tablebut for a single product there should be only one id.
no history at all...
Okay. If that's the case deleting duplicates is a well documented...
July 1, 2011 at 2:02 pm
GilaMonster (7/1/2011)
SQLRNNR (7/1/2011)
I'd also recommend checking out the MCM Videos.Those might be a little (ok a lot) advanced for someone doing a ITP bootcamp
well... what not kills you makes you...
July 1, 2011 at 1:56 pm
keymoo (6/27/2011)
I also have a table called InstrumentEvent...
July 1, 2011 at 1:48 pm
Chad Slagle (7/1/2011)
The data/column giving me trouble is stored as yyyy-mm-dd in SQL Server, and Oracle is storing it as mm-dd-yyyy.
Not reallly. Oracle stores DATE data type data in a...
July 1, 2011 at 1:38 pm
Jeff Moden (6/26/2011)
PaulB-TheOneAndOnly (6/23/2011)
There is an abundant amount of information on the posts of this thread but I'm affraid most people wouldn't read...
July 1, 2011 at 1:21 pm
email-511704 (7/1/2011)
July 1, 2011 at 1:14 pm
Viewing 15 posts - 931 through 945 (of 3,061 total)