Forum Replies Created

Viewing 15 posts - 16 through 30 (of 73 total)

  • RE: Logshipping failure

    am not seeing any specific error. on restore job history, it says step failed. 🙁

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    January 27, 2011 at 12:35 pm

    #1279313

  • RE: Can cursor avoided here?

    Thanks Lutz.. I will let you know once it gets changed and the impact..

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    December 17, 2010 at 11:59 am

    #1264193

  • RE: Query slow

    Thanks a lot Lutz...I just modified query and it executes like a champ...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    November 12, 2010 at 6:09 am

    #1249956

  • RE: Query slow

    Thanks..lets see how it goes...it would take some time to go thru processes to have this NCI...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    November 10, 2010 at 12:23 pm

    #1249107

  • RE: Query slow

    here goes the DDL..Only CI on PK exists..

    CREATE TABLE [dbo].[Temp](

    [GUID] [char](36) NOT NULL,

    [fk_InventoryID] [int] NOT NULL,

    [TranType] [int] NOT NULL,

    [Amount] [money] NOT NULL CONSTRAINT [DF_TempAmount] DEFAULT (0),

    [TimeStamp] [datetime] NOT NULL,

    [Results]...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    November 10, 2010 at 11:47 am

    #1249086

  • RE: where current of?

    Thanks Cory.

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    September 29, 2010 at 12:47 pm

    #1229278

  • RE: Slow running proc...

    Thanks Lutz..I will work on them as you advised...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    September 20, 2010 at 6:33 am

    #1223958

  • RE: Slow running proc...

    CirquedeSQLeil --- Got any clues on this?

    have a great weekend...

    Thanks

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    September 17, 2010 at 1:44 pm

    #1223302

  • RE: Slow running proc...

    Thanks for immediate resposne.. Its being called in side a huge procedure..being called inside a cursor as below.

    IF dbo.CheckDayMatch(@ViewDate, @SessionFrequency) = 1

    Below is the procedure ,from where the...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    September 17, 2010 at 10:21 am

    #1223158

  • RE: How do I get one row in a result set from 2 rows in parent table without using cursors.

    check if this is what yo are looking for result set1

    if object_id('tb1') is not null

    drop table tb1

    CREATE TABLE [dbo].[tb1](

    [trade] [varchar](10) NULL,

    [leg] [varchar](10) NULL, -----say it is my Unique key

    [ccy] [varchar](10)...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    August 13, 2010 at 2:33 am

    #1206468

  • RE: Create #Temp Table using While Loop Instead of Cursor

    check if you are looking something like below....if not, post table defintions ,sample data and expected results to get faster and accurate responses.

    if object_id('tempdb..#test123') is not null

    drop table #test123

    SELECT id1...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    August 12, 2010 at 11:05 pm

    #1206396

  • RE: Avoid cursor....

    Jeff / Jvanderberg...Thanks a lot for your explantions...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    July 26, 2010 at 11:43 pm

    #1198539

  • RE: Avoid cursor....

    No luck with your code..can you please generate the code which was mentioned in my first mail with your logic...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    July 25, 2010 at 11:22 pm

    #1198009

  • RE: Avoid cursor....

    Thanks for the reply. But this wont solve my work as my code is filtering databases in where clause while selecting the cursor..

    declare CURSOR FOR SELECT [name]

    ...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    July 25, 2010 at 11:09 pm

    #1198003

  • RE: Help with SQL Coding

    With the given information, it would be difficult to provide tested code , but check if following works..

    --Change Below code

    --IF @temp = App_ID --This is the part giving error.

    --to

    IF...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    July 9, 2010 at 4:27 am

    #1190690

Viewing 15 posts - 16 through 30 (of 73 total)