Forum Replies Created

Viewing 15 posts - 1,786 through 1,800 (of 19,560 total)

  • RE: Today's Random Word!

    accelerant

    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

    November 24, 2014 at 2:23 pm

    #1760615

  • RE: Find the Most Recent Post

    While a decent question about an analytic function in SQL Server, I am not enthused by the terminology used in reference to the table variable.

    Table variables are not "memory tables."...

    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

    November 23, 2014 at 11:59 am

    #1760386

  • RE: Real World T-SQL Tricks

    Ed Wagner (11/21/2014)

    lshanahan (11/21/2014)

    Recently been trying to wrap my brain around APPLY and it's sibling CROSS APPLY as I have some situations where they could prove useful.

    I'm using 2005 at...

    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

    November 21, 2014 at 3:13 pm

    #1760292

  • RE: Are the posted questions getting worse?

    andrew gothard (11/21/2014)

    Bar in my home town.

    Can't see it being suitable for a gathering, somehow. Certainly if Jeff Moden's invited,

    http://www.tavistockleisure.com/r-bar.htm

    It's great that the window shades all had RBAR...

    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

    November 21, 2014 at 8:33 am

    #1760183

  • RE: Index Behaviour

    Stewart "Arturius" Campbell (11/21/2014)

    Sean Lange (11/21/2014)

    Great question but the explanation and the linked article were terribly disappointing. The article says to use the table designer for creating indexes after it...

    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

    November 21, 2014 at 8:29 am

    #1760179

  • RE: Index Behaviour

    Koen Verbeeck (11/21/2014)

    Nice question, not so great explanation.

    Still wonder why number 1 is not a clustered index scan.

    Does SQL Server always prefer a covering nonclustered index over a clustered index?

    (still...

    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

    November 21, 2014 at 8:22 am

    #1760171

  • RE: Log file doesn't emptied

    DBA_AUS (11/20/2014)

    on one of our server tempd db grows upto 150GB and beyond. so we moved it onto a seperate disk. i have seen it goes upto 150 + and...

    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

    November 21, 2014 at 7:47 am

    #1760137

  • RE: Log file doesn't emptied

    DBA_AUS (11/20/2014)

    thanks that make sense. I was under the impression that after t-log backup if space is not in use it should be released to OS.

    if this is the case...

    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

    November 20, 2014 at 6:06 pm

    #1759987

  • RE: Moving Data to new Filegroup DOESN'T WORK

    Another trick to move that is to partition the table with an unbounded function. Then you can rebuild the clustered index and merge the data into the new partition.

    It...

    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

    November 20, 2014 at 1:47 pm

    #1759967

  • RE: Today's Random Word!

    Ed Wagner (11/20/2014)

    SQLRNNR (11/20/2014)

    Ed Wagner (11/20/2014)

    SQLRNNR (11/20/2014)

    Ed Wagner (11/20/2014)

    SQLRNNR (11/20/2014)

    anise

    Fennel

    seed

    Growth

    hormone

    Cheat

    death

    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

    November 20, 2014 at 12:20 pm

    #1759944

  • RE: SQL consolidation

    You are welcome.

    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

    November 20, 2014 at 11:15 am

    #1759931

  • RE: SQL consolidation

    The issues I have seen boil down to the tools not launching after the 2014 tools were installed. This persisted until the removal of the 2014 tools.

    I'm not really...

    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

    November 20, 2014 at 11:08 am

    #1759929

  • RE: SQL consolidation

    I have done it both ways. It works fine for the database engine. I have seen some issues come about with the install of SSMS and that was...

    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

    November 20, 2014 at 10:40 am

    #1759918

  • RE: Achievement Unlocked: Balance 0

    Miles Neale (11/20/2014)

    A friend last year was asked why he worked seven days a week and for 10-12 hours a day. A couple of us told him he...

    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

    November 20, 2014 at 10:36 am

    #1759915

  • RE: Achievement Unlocked: Balance 0

    Years ago I worked at a place that did not value vacation of the employees. I found myself working every day of family vacations because everything was a fire....

    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

    November 20, 2014 at 10:34 am

    #1759913

Viewing 15 posts - 1,786 through 1,800 (of 19,560 total)