Forum Replies Created

Viewing 15 posts - 3,121 through 3,135 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/20/2014)

    Who's getting a Surface 3? Or wants one?

    Up in the air on this whole thing, but I'll admit it's tempting, depending on price.

    http://www.microsoft.com/en-us/news/press/2014/may14/05-20surfacepr.aspx

    I'll admit...

    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

    May 20, 2014 at 11:06 am

    #1715052

  • RE: Re-order views' fields' name

    No, you just need to select the fields in alpha order. That is far less impactful than to change the column order within the view.

    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

    May 20, 2014 at 10:51 am

    #1715046

  • RE: How to report database performance to upper management

    Clint-525719 (5/20/2014)

    Hello all. We are looking for a way to report database performance to upper management. I'll start by giving you an overview of our team structure. 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

    May 20, 2014 at 10:41 am

    #1715042

  • RE: Re-order views' fields' name

    Why reorder the view?

    You can just select the columns from the view in alphabetical order and be done with 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

    May 20, 2014 at 10:39 am

    #1715041

  • RE: Mysterious performance issue when joining a view

    Jake Shelton (5/20/2014)

    Added the Clustered Index to tbl.RegHist (after dropping the non-clustered one of the same name), runtime remains the same.

    Attempted to change the datatype for the Chassis column to...

    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

    May 20, 2014 at 10:19 am

    #1715037

  • RE: Are the posted questions getting worse?

    paul.knibbs (5/20/2014)

    SQLRNNR (5/20/2014)

    Definitely something to avoid.

    Maybe this guy saw that story about the programmer who outsourced all his own work to China for a fraction of his salary and thought,...

    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

    May 20, 2014 at 9:33 am

    #1715015

  • RE: Running Out Of Foreign Keys

    Hugo Kornelis (5/20/2014)

    Thanks for the question, Andy!

    However ... " (for once!)" - I resent that! 😉

    I laughed when I read (in the generic maximum capacity specifications link): "the recommended maximum...

    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

    May 20, 2014 at 9:28 am

    #1715013

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/20/2014)

    GilaMonster (5/20/2014)

    I'm just going to leave this here...

    http://www.sqlservercentral.com/Forums/Topic1572621-391-1.aspx

    Yeah, I saw that. If it isn't a scam, it sounds like it would be a full time job.

    Definitely something...

    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

    May 20, 2014 at 9:19 am

    #1715004

  • RE: urgent_Backup_needed

    ChrisM@Work (5/20/2014)

    vasugunda (5/20/2014)

    Hello everyone

    I am a new starter to sql and msbi

    Are there anyone who can give me back up when Iam in job

    its a bit urgent...

    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

    May 20, 2014 at 9:18 am

    #1715003

  • RE: best practices for storing ssn?

    Sean Lange (5/19/2014)

    Eric M Russell (5/19/2014)

    Maxer (5/18/2014)

    A company I work with stores all HR data for all past and present employees in a table that has SSN, DOB, address, 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

    May 19, 2014 at 10:28 am

    #1714715

  • RE: how come can write SELECT TOP 1%' without a FROM clause?

    The use cases for a join using "LIKE" in the join conditions will be far fewer than your traditional <, >, <>, = operators. There is a benefit to...

    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

    May 19, 2014 at 10:10 am

    #1714706

  • RE: how come can write SELECT TOP 1%' without a FROM clause?

    KoldCoffee (5/19/2014)

    ja ja, SQLRNNR, I get you, but I need to know the components available before making any decisions. Probably the equi join is good for something in some...

    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

    May 19, 2014 at 9:59 am

    #1714699

  • RE: how come can write SELECT TOP 1%' without a FROM clause?

    Luis Cazares (5/19/2014)

    I'm sorry if I didn't make myself clear. The reference was supposed to be for KoldCoffee, as I assumed that you knew this. 😉

    :hehe::cool:

    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

    May 19, 2014 at 9:58 am

    #1714698

  • RE: how come can write SELECT TOP 1%' without a FROM clause?

    Luis Cazares (5/19/2014)

    SQLRNNR (5/19/2014)

    There is no special name for it. It's just another way of writing a join condition.

    Actually, it could be considered as a non equi join. You...

    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

    May 19, 2014 at 9:11 am

    #1714676

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/19/2014)

    jcrawf02 (5/19/2014)

    As for el Potter, what irked you so much Grant? Was it the fact they were lost in the woods (and whiny, oh so very whiny) for...

    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

    May 19, 2014 at 8:04 am

    #1714641

Viewing 15 posts - 3,121 through 3,135 (of 19,560 total)