Forum Replies Created

Viewing 15 posts - 3,826 through 3,840 (of 15,381 total)

  • RE: Which type of Numbers?

    Sean Pearce (9/16/2014)

    And this relates to SQL Server how? I am not here for maths lessons.

    It isn't even really math. From the wiki page.

    These are odd facts, very suitable...

    September 16, 2014 at 7:13 am

    #1745762

  • RE: Frequent Index Fragmentation

    Jai-SQL DBA (9/15/2014)

    CREATE TABLE [dbo].[TEST](

    [ID] [bigint] IDENTITY(1,1) NOT NULL,

    [NIV] [varchar](17) NULL,

    [SLT] [smallint] NULL,

    [ORD] [nvarchar](12) NOT NULL,

    [FULLSLT] [int] NULL,

    [Status] [nvarchar](10) NULL,

    CONSTRAINT [PK_dbo.TEST] PRIMARY KEY CLUSTERED

    (

    [ID] ASC

    )WITH (PAD_INDEX =...

    September 15, 2014 at 7:58 am

    #1745485

  • RE: Are the posted questions getting worse?

    BWFC (9/15/2014)

    Sean Lange (9/15/2014)

    BWFC (9/15/2014)

    Sean Lange (9/15/2014)

    BWFC (9/15/2014)

    Sean Lange (9/15/2014)

    Lynn Pettis (9/13/2014)

    SQLRNNR (9/13/2014)

    Sean Lange (9/13/2014)

    Woo Hoo!!! I was able to find a coach to fill in for me today and...

    September 15, 2014 at 7:41 am

    #1745479

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/15/2014)

    Sean Lange (9/15/2014)

    Ed Wagner (9/14/2014)

    Sean Lange (9/13/2014)

    Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my...

    September 15, 2014 at 7:38 am

    #1745477

  • RE: Are the posted questions getting worse?

    BWFC (9/15/2014)

    Sean Lange (9/15/2014)

    BWFC (9/15/2014)

    Sean Lange (9/15/2014)

    Lynn Pettis (9/13/2014)

    SQLRNNR (9/13/2014)

    Sean Lange (9/13/2014)

    Woo Hoo!!! I was able to find a coach to fill in for me today and I was able...

    September 15, 2014 at 7:32 am

    #1745475

  • RE: Frequent Index Fragmentation

    Jai-SQL DBA (9/15/2014)

    Hi guys,

    I am facing an issue with index fragmentation.I have a DB in which few of the tables have started getting fragmented very frequently .As I rebuild the...

    September 15, 2014 at 7:24 am

    #1745468

  • RE: Are the posted questions getting worse?

    BWFC (9/15/2014)

    Sean Lange (9/15/2014)

    Lynn Pettis (9/13/2014)

    SQLRNNR (9/13/2014)

    Sean Lange (9/13/2014)

    Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my...

    September 15, 2014 at 7:22 am

    #1745466

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/14/2014)

    Sean Lange (9/13/2014)

    Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The...

    September 15, 2014 at 7:16 am

    #1745463

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/13/2014)

    SQLRNNR (9/13/2014)

    Sean Lange (9/13/2014)

    Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday....

    September 15, 2014 at 7:07 am

    #1745454

  • RE: Are the posted questions getting worse?

    Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an...

    September 13, 2014 at 5:39 pm

    #1745296

  • RE: Table Record Access Counter

    Counting it will work until the day management wants to know how many time in the month of June did URL xxx get requested. Or when was the last time...

    September 12, 2014 at 10:18 am

    #1745145

  • RE: How to update this?

    Edvard Korsbæk (9/11/2014)

    Thanks!

    Did the trick,

    Best regards

    Edvard Korsbæk

    Great. Glad that worked for you and thanks for letting me know.

    September 12, 2014 at 7:03 am

    #1745066

  • RE: Are the posted questions getting worse?

    Luis Cazares (9/11/2014)

    Ed Wagner (9/11/2014)

    Heh - We just got our driveway paved with asphalt on Tuesday (the day before the rain) and our dog doesn't know what to do any...

    September 11, 2014 at 3:21 pm

    #1744943

  • RE: Trying to get results in a specific order

    robert.wiglesworth (9/11/2014)

    I think I got it. It looks like I really don't need lastname and firstname in the second CTE. Only need the address to join to and the groupnumber....

    September 11, 2014 at 12:31 pm

    #1744899

  • RE: Trying to get results in a specific order

    robert.wiglesworth (9/11/2014)

    BOOM just like that. I tried using a CTE and a row_number, just didn't think of having to do it twice.

    Thank you!!

    You are welcome. Glad that worked for...

    September 11, 2014 at 10:59 am

    #1744869

Viewing 15 posts - 3,826 through 3,840 (of 15,381 total)