Forum Replies Created

Viewing 15 posts - 46 through 60 (of 73 total)

  • RE: rarely used procedures in db

    Thanks Grant....am clear now.....

    -----------------------------------------------------------------------
    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]

    May 5, 2010 at 10:47 pm

    #1162944

  • RE: rarely used procedures in db

    This has given some direction but not serving my need exactly...

    can any one please post any query( may be using dmv) to get unused objects list directly..

    -----------------------------------------------------------------------
    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]

    May 5, 2010 at 3:27 am

    #1162304

  • RE: Overlapping indexes

    Nope..you misunderstood..

    overlapping indexes are the indexes which overlapped over the columns...for example..if i have 3 indexes..

    index 1 is on Table1 on col1,col2,col3

    index 2 is on Table1 on col1,col2

    index 3 is...

    -----------------------------------------------------------------------
    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]

    May 4, 2010 at 5:25 am

    #1161706

  • RE: Row transpose

    Second one is so sweet and fast as you....thanks again......

    -----------------------------------------------------------------------
    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]

    April 30, 2010 at 12:48 am

    #1160235

  • RE: Row transpose

    Wonderful coldcofee..you deserve a great Applause...

    -----------------------------------------------------------------------
    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]

    April 29, 2010 at 5:17 am

    #1159554

  • RE: help in avoiding loop

    Thanking all for responses..

    I did some work on this procedure..rewritten the code without using while loops...tried having tally table to insert the values from comma separated string into temp tables...

    -----------------------------------------------------------------------
    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]

    March 23, 2010 at 11:08 pm

    #1138697

  • RE: Finding columns which are FKs and having no indexes

    One more question which i missed in Original Post..

    Does it require to have an index on FK columns. can any one please post possitives and negatives of having an index...

    -----------------------------------------------------------------------
    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]

    March 3, 2010 at 10:27 pm

    #1128260

  • RE: Finding columns which are FKs and having no indexes

    Thanks for the query. It works great.........

    -----------------------------------------------------------------------
    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]

    March 3, 2010 at 9:41 pm

    #1128235

  • RE: Create table dynamically using loop

    Is this you are looking for?

    declare @tblStr varchar(max)

    declare @intMnth int

    set @intMnth =1

    while @intmnth < 12

    begin

    set @tblStr = 'CREATE TABLE [dbo].[DERInfo_2010'+cast(@intmnth as varchar(10))+'](

    [trnxid] [int] IDENTITY(1,1) NOT NULL,

    [DDate] [datetime] NOT NULL,

    [TID]...

    -----------------------------------------------------------------------
    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]

    February 22, 2010 at 11:41 pm

    #1123440

  • RE: Auto commit

    Thanks ALZDBA...

    -----------------------------------------------------------------------
    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]

    February 11, 2010 at 2:02 am

    #1117444

  • RE: Error while querying DMvs

    Thanks Bru..i donot have access to Server. i will ask DBA to set this permission..

    -----------------------------------------------------------------------
    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 16, 2009 at 11:23 am

    #1093221

  • RE: Error while querying DMvs

    Thanks....how / where to set the permission?

    -----------------------------------------------------------------------
    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 16, 2009 at 11:05 am

    #1093205

  • RE: SQL 2008 Installation

    Thanks Bru...

    -----------------------------------------------------------------------
    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 11, 2009 at 9:08 am

    #1091243

  • RE: Uninstalling SQL 2k components

    Thanks bru for response..

    One more thing i missed in my original post is...compatiblilty level for the DBs in SQL 2005 is set to 80. does it have any dependency on...

    -----------------------------------------------------------------------
    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 10, 2009 at 11:49 am

    #1090770

  • RE: how to post query ...

    Thanks..I will try when i post next query ...

    -----------------------------------------------------------------------
    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 7, 2009 at 12:27 pm

    #1088816

Viewing 15 posts - 46 through 60 (of 73 total)