Are the posted questions getting worse?

  • Luis Cazares (4/10/2015)


    Grant Fritchey (4/10/2015)


    Brandie Tarvin (4/10/2015)


    Grant Fritchey (4/10/2015)


    Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:

    Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.

    Are you saying I'm on drugs?

    Was that supposed to be a secret? :w00t:

    Look, Grant, there's a reason you didn't get the circus job. We just didn't want to break the news to you.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Luis Cazares (4/10/2015)


    Grant Fritchey (4/10/2015)


    Brandie Tarvin (4/10/2015)


    Grant Fritchey (4/10/2015)


    Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:

    Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.

    Are you saying I'm on drugs?

    Was that supposed to be a secret? :w00t:

    I just got a .NET error screen when I clicked the link in the new post email. It was repeatable for about a minute and I couldn't go to the forums home either. It didn't give anything away.

    As for being on drugs...I think that's a separate question and certainly not my business. 😛

  • Brandie Tarvin (4/10/2015)


    Grant Fritchey (4/10/2015)


    Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:

    Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.

    I might have been that high once but I have plausible deniability because I can barely remember college.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Brandie Tarvin (4/10/2015)


    Luis Cazares (4/10/2015)


    Grant Fritchey (4/10/2015)


    Brandie Tarvin (4/10/2015)


    Grant Fritchey (4/10/2015)


    Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:

    Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.

    Are you saying I'm on drugs?

    Was that supposed to be a secret? :w00t:

    Look, Grant, there's a reason you didn't get the circus job. We just didn't want to break the news to you.

    <squeak>really?</squeak>

    And I showered and everything.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Grant Fritchey (4/10/2015)


    Brandie Tarvin (4/10/2015)


    Grant Fritchey (4/10/2015)


    Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:

    Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.

    Are you saying I'm on drugs?

    What ever you're on, I want two of those:-D

    😎

  • Brandie Tarvin (4/10/2015)


    Grant Fritchey (4/10/2015)


    Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:

    Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.

    What are you using for the SFTP?

    😎

  • Eirikur Eiriksson (4/10/2015)


    Brandie Tarvin (4/10/2015)


    Grant Fritchey (4/10/2015)


    Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:

    Not that I've ever been that high, but I'm putting out fires and trying to resolve SFTP in SSIS issues.

    What are you using for the SFTP?

    😎

    Ah, well, that's the issue.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin (4/10/2015)


    Eirikur Eiriksson (4/10/2015)


    What are you using for the SFTP?

    😎

    Ah, well, that's the issue.

    If I remember correctly, you have some kind of an issue with using OSS, so you cannot use the likes of FileZilla or WinSCP, is that right?

    😎

  • Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

    http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

    But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Luis Cazares (4/10/2015)


    Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

    http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

    But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.

    Well you can have two clustered indexes on a table.

    Clustered XML Index and a Clustered (traditional sense) Index would be one means.

    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

  • SQLRNNR (4/10/2015)


    Luis Cazares (4/10/2015)


    Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

    http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

    But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.

    Well you can have two clustered indexes on a table.

    Clustered XML Index and a Clustered (traditional sense) Index would be one means.

    My bet is that Luis got it right, damn, I do want two of what Grant is on:blink:

    😎

  • SQLRNNR (4/10/2015)


    Luis Cazares (4/10/2015)


    Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

    http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

    But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.

    Well you can have two clustered indexes on a table.

    Clustered XML Index and a Clustered (traditional sense) Index would be one means.

    Except that clustered XML indexes are called Primary XML Indexes. 😛

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Luis Cazares (4/10/2015)


    SQLRNNR (4/10/2015)


    Luis Cazares (4/10/2015)


    Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

    http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

    But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.

    Well you can have two clustered indexes on a table.

    Clustered XML Index and a Clustered (traditional sense) Index would be one means.

    Except that clustered XML indexes are called Primary XML Indexes. 😛

    As I said, what ever Grant is on is going to turn any heap into a cluster:-P

    😎

  • Luis Cazares (4/10/2015)


    SQLRNNR (4/10/2015)


    Luis Cazares (4/10/2015)


    Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

    http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

    But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.

    Well you can have two clustered indexes on a table.

    Clustered XML Index and a Clustered (traditional sense) Index would be one means.

    Except that clustered XML indexes are called Primary XML Indexes. 😛

    There is also another trick that can be used to get 2 clustered indexes on a table (at least the same effect as 2 clustered indexes). :-D:-D

    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

  • SQLRNNR (4/10/2015)


    Luis Cazares (4/10/2015)


    SQLRNNR (4/10/2015)


    Luis Cazares (4/10/2015)


    Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

    http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

    But, think about it, what if you're in situation where, if you just had two clustered indexes on a table, you'd be set. INCLUDE all the columns, and it's exactly the same as a second clustered index. Done.

    Well you can have two clustered indexes on a table.

    Clustered XML Index and a Clustered (traditional sense) Index would be one means.

    Except that clustered XML indexes are called Primary XML Indexes. 😛

    There is also another trick that can be used to get 2 clustered indexes on a table (at least the same effect as 2 clustered indexes). :-D:-D

    Why not adding a Full Text and a Spatial index? On a second thought, that would be Cluttered index not Clustered:-P

    😎

Viewing 15 posts - 48,166 through 48,180 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply