Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 49,552 total)

  • RE: Seeing invalid column and object everytime I create StoreProcedure or insert a new column

    Click the Edit menu in Management Studio. Select Intellisense (at the bottom) and then Refresh Local Cache. (Ctrl-Shift-R as a shortcut)

    It's purely the delay in SSMS refreshing the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 21, 2017 at 1:37 am

    #1929471

  • RE: sql debugger enabling in the production server without admin privileges?

    Rankerg - Monday, February 20, 2017 12:25 PM

     usually we don't have test /development server so can I still enable debugger?

    You can....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 20, 2017 at 2:24 pm

    #1929443

  • RE: Index Performance

    And keep in mind that even if the DMV shows both are used (and it probably will), the smaller index may not be necessary and removing it probably won't hurt...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 20, 2017 at 3:32 am

    #1929326

  • RE: sql debugger enabling in the production server without admin privileges?

    Debugging requires sysadmin permissions, and it is NOT something you want to be doing on production. Get yourself a development environment and test there. There's no good reason to be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 20, 2017 at 3:01 am

    #1929320

  • RE: How do I state my foreign key in my Create Table?

    pietlinden - Sunday, February 19, 2017 12:57 PM

    Can you name the constraint when you declare it that way?

    Yes you can. Just add...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 20, 2017 at 12:08 am

    #1929305

  • RE: How do I state my foreign key in my Create Table?

    Normally when I create tables with foreign keys, I'll specify the foreign key as part of the column definition. Keeps everything in one place.

    eg
    CREATE TABLE...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 19, 2017 at 11:38 am

    #1929278

  • RE: HOW TO DROP UNIQUE NON CLUSTERED INDEX

    joeroshan - Friday, February 17, 2017 2:15 AM

    Clustered index is the table, so you might want to recreate the index without the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 17, 2017 at 2:35 am

    #1929048

  • RE: Are the posted questions getting worse?

    BLOB EATER - Friday, February 17, 2017 12:44 AM

    I so want to know.... its searching time I guess.

    Nope, not online.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 17, 2017 at 1:49 am

    #1929044

  • RE: Are the posted questions getting worse?

    Aaaahhhhh!!!!!!

    I'd rant, but the people in question might see this, and that would not be a good thing, so I'll just stick to AAAaaahhhhh!!!!!

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 16, 2017 at 2:49 pm

    #1928989

  • RE: Log shipping from sql 2008 to 2016?

    Siten0308 - Thursday, February 16, 2017 1:44 PM

     big thanks SSChampion for your help 🙂

    btw, the person who helped you is Perry.
    Champion...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 16, 2017 at 2:44 pm

    #1928986

  • RE: Getting the first of the month based on yesterday's date

    Edit: Didn't notice it was SSIS. Should read properly.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 16, 2017 at 6:52 am

    #1928826

  • RE: Getting the first of the month based on yesterday's date

    Kazmerelda - Thursday, February 16, 2017 3:49 AM

    So question, how would I adapt this to pick up the start of the month...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 16, 2017 at 3:53 am

    #1928790

  • RE: Efficient way of writing this stored procedure (Takes too much time to run)

    Table definitions please & index definitions.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 16, 2017 at 12:37 am

    #1928779

  • RE: Connection string

    The error means that the login "my user" does not have access to the database named "Database name", check your DB security.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 16, 2017 at 12:35 am

    #1928778

  • RE: Using SQL Profiler

    On a development environment, sure. Developers break development, they only inconvenience themselves.
    Profiler permission on production, no way in hell. Profiler, the GUI at least, can cause severe problems...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 16, 2017 at 12:32 am

    #1928777

Viewing 15 posts - 1,756 through 1,770 (of 49,552 total)