Forum Replies Created

Viewing 15 posts - 4,276 through 4,290 (of 19,560 total)

  • RE: Microsoft Certified Master

    SimonLiew (7/25/2013)

    I've written a blog about my experience, hope it helps someway.

    http://sqlsimonl.blogspot.com.au/2013/02/simon-liew-microsoft-certified-master.html#!/2013/02/simon-liew-microsoft-certified-master.html

    My advice is not to benchmark how many people passed in their first attempt. Everyone's different. Passing an...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 27, 2013 at 1:56 pm

    #1645336

  • RE: How to put $ symbol in the query or result set

    erikd (8/27/2013)

    SQLRNNR (8/27/2013)

    erikd (8/27/2013)

    Ah. That's weird. Why does that happen? I jumped from 2005 to 2012, and never ran into that happening. I feel pretty lucky :Whistling:

    I should probably clarify...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 27, 2013 at 10:49 am

    #1645276

  • RE: How to put $ symbol in the query or result set

    erikd (8/27/2013)

    Ah. That's weird. Why does that happen? I jumped from 2005 to 2012, and never ran into that happening. I feel pretty lucky :Whistling:

    I should probably clarify a little...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 27, 2013 at 10:42 am

    #1645273

  • RE: How to put $ symbol in the query or result set

    erikd (8/27/2013)

    Koen Verbeeck (8/26/2013)

    kakumanukalyan (8/26/2013)

    SELECT ContactID,Concat('$',AVG(TotalDue)) AS [Avergare Total Due]

    FROM Sales.SalesOrderHeader

    GROUP BY ContactID

    ORDER BY 1 ASC

    Not really a fan of doing this in the database layer. If the result is...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 27, 2013 at 9:31 am

    #1645253

  • RE: SQL Server Tables

    sknox (8/27/2013)

    SQLRNNR (8/27/2013)

    For me, the wording of the question implies that a requirement of a heap be that it is completely devoid of indexes.

    Then you're not thinking in set-based...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 27, 2013 at 8:47 am

    #1645234

  • RE: SQL Server Tables

    Hugo Kornelis (8/27/2013)

    SQLRNNR (8/26/2013)

    Though it is easy enough to figure the intent of this question, I disagree with it.

    A Heap can have nonclustered indexes. A heap just means that...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 27, 2013 at 12:56 am

    #1645022

  • RE: SQL Server Tables

    Though it is easy enough to figure the intent of this question, I disagree with it.

    A Heap can have nonclustered indexes. A heap just means that the table is...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 26, 2013 at 11:56 pm

    #1645011

  • RE: Full and transaction log backup chain breakup

    anoop.mig29 (8/26/2013)

    GilaMonster (8/24/2013)

    anoop.mig29 (8/24/2013)

    @Gail problem is there are 2 dr of a single primary and only is participating in DR drill so i cannot stop ls backup job at primary.

    I...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 26, 2013 at 11:10 pm

    #1645005

  • RE: Are the posted questions getting worse?

    GilaMonster (8/26/2013)

    33 slides for 3 hours. Should be enough.

    With that many slides you could easily stretch it into an 8hr preso :hehe::w00t:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 26, 2013 at 1:11 pm

    #1644950

  • RE: Today's Random Word!

    JAZZ Master (8/26/2013)

    SQLRNNR (8/23/2013)

    Daniel Bowlin (8/23/2013)

    Ray K (8/23/2013)

    SQLRNNR (8/22/2013)

    opc.three (8/22/2013)

    Gantt

    Hostess

    Freihofers

    Bakery

    Donut run

    Cinnamon Roll

    flaming tire

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 26, 2013 at 9:36 am

    #1644910

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/25/2013)

    GilaMonster (8/25/2013)

    Jeff Moden (8/25/2013)

    GilaMonster (8/25/2013)

    What's your favourite index-related myth?

    What's yours?

    I have a few, but I need fodder for the PASS presentation (that's due today) 😀

    Not necessarily my favorites...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 26, 2013 at 9:23 am

    #1644906

  • RE: How to put $ symbol in the query or result set

    Koen Verbeeck (8/26/2013)

    kakumanukalyan (8/26/2013)

    SELECT ContactID,Concat('$',AVG(TotalDue)) AS [Avergare Total Due]

    FROM Sales.SalesOrderHeader

    GROUP BY ContactID

    ORDER BY 1 ASC

    Not really a fan of doing this in the database layer. If the result is NULL,...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 26, 2013 at 9:06 am

    #1644893

  • RE: Are the posted questions getting worse?

    GilaMonster (8/25/2013)

    What's your favourite index-related myth?

    Tables don't need a clustered index

    CI sorts the records in order on a page

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 25, 2013 at 6:04 pm

    #1644774

  • RE: How to put $ symbol in the query or result set

    Read the following thread. It should provide some examples and a caution about doing the concatenation at the database level rather than the presentation level

    http://www.sqlservercentral.com/Forums/Topic1407950-392-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 24, 2013 at 9:37 am

    #1644654

  • RE: Today's Random Word!

    Daniel Bowlin (8/23/2013)

    Ray K (8/23/2013)

    SQLRNNR (8/22/2013)

    opc.three (8/22/2013)

    Gantt

    Hostess

    Freihofers

    Bakery

    Donut run

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 23, 2013 at 4:20 pm

    #1644606

Viewing 15 posts - 4,276 through 4,290 (of 19,560 total)