Forum Replies Created

Viewing 15 posts - 46 through 60 (of 626 total)

  • Reply To: 20 Years of Compare

    Congrats! Here's to another 20!

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 4, 2019 at 4:45 pm

    #3677301

  • Reply To: Pass Summit 2019 - Housing Question

    Steve Jones - SSC Editor wrote:

    don't worry about shuttles. You can take the train from the airport to downtown in the middle of all hotels. Easy to walk from there. Or super shuttle or...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 4, 2019 at 1:55 pm

    #3677217

  • Reply To: Pass Summit 2019 - Housing Question

    Ray K wrote:

    I started this thread over here for questions like this...

    Actually your post is what inspired me to post this topic.  I figured where else could I find people...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 3, 2019 at 11:07 pm

    #3677029

  • Reply To: Should Salary Information Be Confidential?

    Well this is definately a controversial topic.  I work in law enforcement where all positions are part of a Union even those in management which was really weird notion for...

    • This reply was modified 6 years, 9 months ago by Y.B..

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    August 27, 2019 at 3:04 pm

    #3674756

  • Reply To: Organized Learning

    Well said!  I find in interesting how almost every DBA story begins with a baptism through fire.

    1.  "There's something wrong with the database...quick point a finger at some IT guy!"

      2. ...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    August 14, 2019 at 1:32 pm

    #3671312

  • Reply To: Timing is Everything

    Where I work the IT folks that need elevated permissions have two accounts for the exact same reasons you mention Steve.  But for some reason the Network team that implemented...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    August 8, 2019 at 6:02 pm

    #3669992

  • Reply To: Required Database Monitoring Tool

    I DON'T work for RedGate but I do use SQL Monitor to monitor 15 instances and I can tell you I couldn't go back to pre RedGate days.  I'm not...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    July 10, 2019 at 5:28 pm

    #3661667

  • Reply To: Same set of Included Columns in Multiple NC Indexes on Indexed View

    The key column(s) from your clustered index don't have to be added because they are automatically added to every single Non-Clustered index you create.  You can add them yourself but...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    July 8, 2019 at 12:31 pm

    #3660733

  • Reply To: Same set of Included Columns in Multiple NC Indexes on Indexed View

    Having matching included columns on multiple non-clustered indexes are fine so long as you're not overlapping indexes.  Included columns are great to ensure you can 'cover' a query in order...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    July 3, 2019 at 4:02 pm

    #3659848

  • Reply To: How do I GRANT permissions on these?

    I want to second what Michael said.  You really don't want to be assigning permissions to specific users generally speaking.  You're just asking for trouble that will come back to...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    July 2, 2019 at 5:44 pm

    #3659454

  • Reply To: Formatting % with the sign

    Deleted comment as I realized this was for Reporting Services.

    • This reply was modified 6 years, 12 months ago by Y.B.. Reason: Wrong topic

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 19, 2019 at 3:48 pm

    #3655327

  • Reply To: Are We Suckers?

    Great article Steve and thanks for sharing the link to the original.  I've been pretty lucky in the sense that my employers understood the value of work/life balance.  If you...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 11, 2019 at 8:09 pm

    #3652487

  • Reply To: row size exceeds the maximum allowable of 8060 bytes

    The answer is right there in the error message.  A row size can't exceed 8k.  If you want to know more about that you should read about how SQL stores...

    • This reply was modified 7 years ago by Y.B..

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 31, 2019 at 12:53 pm

    #3648959

  • Reply To: Linked Server Query incorrectly returns 0 rows on SSMS

    Just a guess here but if it takes 15 minutes to run on the actual target DB there is a good chance your linked server connection is hitting a time...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 27, 2019 at 6:26 pm

    #3647618

  • Reply To: Service Broker Sending Directions

    If I create a contract in Service Broken, what are my options for sending directions of my message types?

    Yeah, I really hate those broken services. 😉

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 17, 2019 at 1:09 pm

    #3644539

Viewing 15 posts - 46 through 60 (of 626 total)