Forum Replies Created

Viewing 15 posts - 451 through 465 (of 806 total)

  • RE: Sequential Row Number.

    There are many ways to do something, and then the right way.

    Your way works but will not scale very well. The overhead it causes is unnessasary. To be frank, it's...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 2:24 pm

    #714214

  • RE: Trigger on system tables?

    rather just use profiler. Don't ever fiddle with system objects.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 10:03 am

    #714166

  • RE: Running SSIS packages with MSSQL agents and getting wierd failures

    let us know how things go...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 10:01 am

    #714164

  • RE: Sequential Row Number.

    I would not use that. Creating a temp table for the sake of a a SK it serious overkill and will kill performance.

    Simply install the row number component and use...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 10:00 am

    #714163

  • RE: Sequential Row Number.

    Sorry.

    Go to http://www.SQLIS.com and download it free.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 9:01 am

    #714133

  • RE: Running SSIS packages with MSSQL agents and getting wierd failures

    I would say try stagger the schedules by 2 minutes or something like that. Might be a bug with all the packages kicking off at the same time.

    I would assume...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 6:29 am

    #714075

  • RE: Index review?

    A starting point would be to use profiler to capture a days work (Use the Performance Tuning template) and then get the Index Wizard to analyse the data. This will...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 2:31 am

    #714032

  • RE: Loading data from SQL Server 2005 to Oracle 8i through SSIS

    Try reducing the buffer settings in the data flow slightly. (Reduced Performance though)

    How much memory you got in the machine?

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 2:26 am

    #714031

  • RE: Running SSIS packages with MSSQL agents and getting wierd failures

    Very weird error.

    Do you have all the patches or Sp2a installed?

    Does it only happen when you are using Agent to run the package?

    Do that other packages that fail connect to...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 2:23 am

    #714029

  • RE: Sequential Row Number.

    You could either use an Identity column in the SQL table, or use the Row Number component in SSIS. Both will give you a sequential number which you can seed.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 2:11 am

    #714025

  • RE: Super DBA

    How terrible is the acting in the video. DBA's can't be actors (Even though we do it on a daily basis )

    They are fellow...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 20, 2007 at 1:42 am

    #714021

  • RE: predicates and output lists and indexes

    Glad I could help. It's a hint that you should look at improving the index, bearing in mind inserts / updates etc.

    Look...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 19, 2007 at 3:50 pm

    #713968

  • RE: predicates and output lists and indexes

    Most probably, and you would have to look at the execution plan (The pretty picture one I like :blush

    In SQL 2000, if you sort...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 19, 2007 at 3:38 pm

    #713964

  • RE: ETL From Clipper to SQL (and back again)?

    it would appear that to has ODBC drivers.

    http://www.google.co.uk/search?q=advantage+odbc+driver&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enGB213GB213&aq=t

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 19, 2007 at 7:26 am

    #713831

  • RE: XP_Regread Error 5 in SQL 2005

    I'm working from a hazy memory here but as far as I remember, it was restricted but I seem to remember a way to override it. Have a scratch around...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 19, 2007 at 7:25 am

    #713830

Viewing 15 posts - 451 through 465 (of 806 total)