Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hmckillop
  • Content: Threads
  • Order by date
  1. hmckillop

    Exporting specific data from DB into another DB

    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...
  2. hmckillop

    C# Console app quick quiz

    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)...
  3. hmckillop

    replication conflict monitoring

    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...
  4. hmckillop

    Replication - subscriber help?

    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...
  5. hmckillop

    Xquery and untyped XML datatype

    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>...
  6. hmckillop

    Dynamically create table on different filegroup

    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...
  7. hmckillop

    MS Access and Parameters not passing to Report Query

    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...
  8. hmckillop

    easy one for experts

    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: '<%#...
  9. hmckillop

    Temp Table problem Oracle 8.0.0.16

    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...
  10. hmckillop

    SQl Performance - specifically IO SAN

    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...
  11. hmckillop

    Tablespaces and instances?

    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...
  12. hmckillop

    KILL Spid in ROLLBACK

    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...
  13. hmckillop

    Quad XEON Processor shows up 8 processors - licencing

    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...
  14. hmckillop

    Create Regular Expression

    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...
  15. hmckillop

    Changing field to identity

    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...
  16. hmckillop

    Get database build script via sql code

    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...
  17. hmckillop

    How to get native column type?

    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...
  18. hmckillop

    DBCC LockObjectSchema

    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...
  19. hmckillop

    Insert SP results into a table?

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

    TrimTrailingBlanks

    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?

Part and Inventory Search

Back
Top