Search results for query: *

Hello, I have been tasked with "migrating" data from one Oracle DB to another Oracle DB of same schema. This DB is used as a multi-tenant seperated by a logical column (e.g. Organisation ID). I am now being asked to move data from this DB into another DB in a different location - as such I...

Hello, I was recently asked this question, and just wanted to pose this to the forum to see what people think is the best solution - post your answers and we can judge on performance, elegance and coding skill. Thanks PS - when complete I will post my answer (which isnt the most elegant)...

Hello Does anyone know how to capture meaningful information when I am getting conflicts during merge replication. I am assuming its a foreign key constraint or similiar but if i could locate the actual reason this would make things so much easier. Thanks in advance "I'm living so far beyond...

Hello Anyone ever set up replication from a remote server back into a VPN. I have the publisher inside a VPN on an internal ip address eg 192.168.X.X address It can see the subscriber which is on a public web server. e.g. i can set up a SQL connection to it. So i set up the publication e.g...

I have an untyped xml data store containing an xml similiar to <roottype xmlns="http://www.namspace.com/XMLSchema/ns/DataSynchronisation" SchemaVersion="2.1"> <Field1>HCSK</Field1> <Field2>K111111</Field2> <Field3>2009-01-09-10.51.50.627620</Field3> <New>...

Ok, I have put this into simplier terms in order to facilitate an answer, but in short I am trying to complete the sliding window scenario on using multiple filegroups (Kimberly Tripp conviently uses the hardcoded same filegroup in her examples). I have a proc which will create a specified...

Hello all who read this, I have a quick question that is puzzling me. I have just migrated the database store from access to SQL 2005, but I want to continue using the Access front end, e.g. forms, reports vba etc. Most of the forms work ok but I cant get the reports to work and here are the...

I have a function on my BasePage called GetEncodedURL(), which takes a URL(string) and a string[] of args, and returns a URL Encoded String. In one of my APSX pages I have two asp:Hyperlink controls. The first one is within a gridview, with the NavigateURL property set to: '<%#...

How do I do the equivalent of a temp table in Oracle. I seen CREATE GLOBAL TEMPORARY TABLE but this isnt available in the version I have. Is there a replacement to this.. Here is the problem i have. I have a many to many relationship TableA - TableC, so I created a link table TableB to handle...

We currently have a large database - 64GB Data file, (which I know could be split into different data files). Our indexing job is taking between 4.5 - 5 hrs long, as we use dbcc dbreindex , this can have an impact on other tasks. We have SAN IO figures using SQLIO tool - write performance of...

First off apologies, my Oracle knowlegde is shocking and limited so if I use the wrong terminology my only excuse will be is I work in SQL Server. I have 1 physical server which is currently hosting a 200GB database but I have a requirement to have a further 4 databases of roughly the same...

I have a process which is rolling back a transaction, (I have already killed it due to a latch timeout), but now when I try to kill it again it says This was 11 hours ago. I have a database backup of before I tried the operation, I really need to stop this. (I am not able to restart the box due...

We have purchased a Quad Xeon Processor box with dual core etc etc. for some reason in Windows 2000, it shows 8 processors, is this a fault in Windows OS (is it a mistake in hardware i.e. might we have 8 processors), and if its only 4 actual processors, but displaying 8 how many processor...

I am trying to create a regular expression to accept a currency amount including decimal point (but not required), allowed up to 15 digits to the left of decimal and up to 4 digits to right. Amount must be greater than 0. I just cant seem to create this, any help appreciated. Thanks "I'm...

I have to change a integer field to be an identity. This isnt a big problem, the issue is I have 65 Million rows in the table and need the most efficient way of changing this over. The table has 3 indexes (inc clustered) I have tried BCPing the data out, truncating tha table, amending the field...

Hello i dont have access to my SQL database only access to asp pages. So I planned to run a script on one of the asp pages which would show an actual database build script (note the db only currently contains tables - with possible indexes) which I would then paste into QA and then run locally...

Does anyone know if there is a handy proc/function for returning the base type of a column? I need to return a list of all columns in a table, but only show the actual type as opposed to the User-Defined Data Types. I know I can look this up in systypes, but I was wondering if there is a built...

Does anyone know more details about this undocumented DBCC command. I know its used in sp_recompile, and somewhere I read that its meant to update the stats for the underlying tables used in the object parameter, but anymore details would be greatly appreciated. Thanks in advance. "I'm living...

How do I insert the results of a stored procedure into a table? i.e. INSERT INTO (exec 'aba_lockinfo')

How do you switch this to be on. If you do sp_help <tablename> the 8th column returned is &quot;TrimTrailingBlanks&quot;. I want to be able to switch this to be on, how do i do this?