Forum Replies Created

Viewing 15 posts - 12,736 through 12,750 (of 59,062 total)

  • RE: Why Haven’t You Upgraded SQL Server?

    Thom A - Wednesday, March 7, 2018 7:55 AM

    Jeff Moden - Wednesday, March 7, 2018 7:48 AM

    March 7, 2018 at 10:12 am

    #1982256

  • RE: Why does my stored procedure return -1?

    junk.mail291276 - Wednesday, March 7, 2018 7:42 AM

    Thanks everyone,

    Turns out this was causing the return of -1:
    SET NOCOUNT ON
    If I set NOCOUNT...

    March 7, 2018 at 7:49 am

    #1982218

  • RE: Why Haven’t You Upgraded SQL Server?

    I still want to know why Mr. Britton has 100,000 instances. 😉

    March 7, 2018 at 7:48 am

    #1982217

  • RE: Create Index Script with Fill Factor Question

    ctsufer31 - Tuesday, March 6, 2018 9:05 PM

    I believe I have found a solution to my issue. There are two articles that...

    March 7, 2018 at 7:45 am

    #1982216

  • RE: Why does my stored procedure return -1?

    I'll also add that all those IN (SELECT DISTINCTs are a waste of clock cycles because IN will always stop at the first occurrence of whatever it is you're looking...

    March 6, 2018 at 8:03 pm

    #1982181

  • RE: Create Index Script with Fill Factor Question

    Sergiy - Tuesday, March 6, 2018 6:47 PM

    Jeff Moden - Tuesday, March 6, 2018 6:28 PM

    March 6, 2018 at 7:54 pm

    #1982180

  • RE: Create Index Script with Fill Factor Question

    Sergiy - Tuesday, March 6, 2018 5:39 PM

    It does not matter at all.
    FIll Factor is only taken into consideration when an index...

    March 6, 2018 at 6:28 pm

    #1982176

  • RE: Help me in designing table and its indexes

    RonKyle - Tuesday, March 6, 2018 10:11 AM

    While there's always an exception, I've not yet seen where separation to multiple tables...

    March 6, 2018 at 5:44 pm

    #1982174

  • RE: Help me in designing table and its indexes

    Speaking of the OP...

    @ SQLAddict01 , your absence from your own request for help is a bit conspicuous.  Any feedback on...

    March 6, 2018 at 9:44 am

    #1982102

  • RE: Help me in designing table and its indexes

    RonKyle - Tuesday, March 6, 2018 4:25 AM

    RonKyle - Monday, March 5, 2018 5:06 AM

    This...

    March 6, 2018 at 9:36 am

    #1982099

  • RE: updates are not happening through ssms

    dastagiri16 - Sunday, March 4, 2018 9:12 PM

    Jeff Moden - Sunday, March 4, 2018 12:09 PM

    March 5, 2018 at 8:36 pm

    #1982041

  • RE: How does SQL Server handle concurrent operations?

    junk.mail291276 - Monday, March 5, 2018 3:10 PM

    Hello everyone,
    Thanks for all the replies. Sorry for the late response.
    On Friday, I was preparing...

    March 5, 2018 at 8:34 pm

    #1982040

  • RE: Help me in designing table and its indexes

    RonKyle - Monday, March 5, 2018 5:06 AM

    This might be a case where it depends what you want to do with the...

    March 5, 2018 at 8:27 pm

    #1982039

  • RE: How to bring database just before the delete occurred.

    coolchaitu - Sunday, March 4, 2018 10:26 PM

    Jeff Moden - Sunday, March 4, 2018 5:17 PM

    March 5, 2018 at 6:12 am

    #1981929

  • RE: Help me in designing table and its indexes

    SQLAddict01 - Friday, March 2, 2018 3:07 PM