Forum Replies Created

Viewing 15 posts - 466 through 480 (of 1,999 total)

  • Reply To: Building Your Brand

    ktflash wrote:

    MVDBA (Mike Vessey) wrote:

    But interestingly, as I get older, my personal goals have changed. Salary is not a measure of success. I'm more happy when I get 2000 reads on an...

    January 27, 2020 at 2:39 pm

    #3720627

  • Reply To: removing stretch on a restore

    Hmmmmm….. looks like that is the correct fix as i'm getting the following error on my commands

    Cannot query table xxx.dbo.historic_xxxx' because this operation is currently disabled for this object.

    if I...

    January 27, 2020 at 2:19 pm

    #3720621

  • Reply To: Building Your Brand

    I worked for a company who "pimped out" test engineers and DBA people... to sell our "man hours" to clients we were encouraged to build a personal brand. this really...

    January 27, 2020 at 1:27 pm

    #3720566

  • Reply To: cardinality estimation

    Grant Fritchey wrote:

    I'm not aware of any CE issues moving between versions greater than 2014. The optimization engine has changed at each version, and that could, in some edge cases, cause...

    January 27, 2020 at 1:17 pm

    #3720563

  • Reply To: Cranky Curmudgeons

    I get T-rex poo and SQL profiler (I know Grant is going to bite on this one - i'll put money on the next words out of his mouth are...

    January 27, 2020 at 1:04 pm

    #3720561

  • Reply To: cardinality estimation

    so, to give some context - this is a consolidation of multiple servers (some 2014, some 2016) into a nice big server with "NO LINKED SERVERS" - it is however...

    January 27, 2020 at 11:09 am

    #3720544

  • Reply To: cardinality estimation

    thanks for that

    It's interesting in that article that there are new hint options and database specific settings, but not any opinion on whether they are good or bad.

    I like the...

    January 27, 2020 at 10:02 am

    #3720528

  • Reply To: Cranky Curmudgeons

    Michael L John wrote:

    Yes, I am cranky.  Because I am tired of being the guy with the shovel and broom who walks behind the horses in the parade.

    wait - ???? you get...

    January 27, 2020 at 8:45 am

    #3720504

  • Reply To: Web page listing SQL code

    in my searches - http://hilite.me/

    not too bad

    January 24, 2020 at 12:29 pm

    #3720087

  • Reply To: Web page listing SQL code

    curious on this one ---- has no-one ever come up with a CSS style for SQL code that is vaguely acceptable?

    January 24, 2020 at 12:24 pm

    #3720083

  • Reply To: how to optimise overlap query

    John Mitchell-245523 wrote:

    If @EndStation is always greater than @BeginStation, then you can simplify like this.  Note that I've also removed the NOTs and changed ANDs to ORs and >= to <...

    January 24, 2020 at 12:17 pm

    #3720079

  • Reply To: Cranky Curmudgeons

    Michael L John wrote:

    In today's meeting of the entire IT staff, we were discussing how interruptions prevent us from getting projects completed.

    My boss, using me as an example, stated that I was...

    January 24, 2020 at 9:01 am

    #3720010

  • Reply To: Cranky Curmudgeons

    jarick 15608 wrote:

      They tell me the SQL server is slow and when I do a trace, the application is sending 100's of lines of bad SQL to the database.  Half...

    January 23, 2020 at 5:26 pm

    #3717847

  • Reply To: Knowing What You Don’t Know

    Grant Fritchey wrote:

    MVDBA (Mike Vessey) wrote:

    i'm going to re-read the phoenix project (for about the 5th time) and seek wisdom. 🙂

    I need to get the Unicorn Project and read it.

    Santa clause bought me...

    January 23, 2020 at 3:03 pm

    #3717796

  • Reply To: BULK insert several thousand files

    which means either I screwed up on the 1st file import, or my files are not consistant…. which would be painfull

    but that is a great spot

    the col26 issue was because...

    January 23, 2020 at 2:07 pm

    #3717772

Viewing 15 posts - 466 through 480 (of 1,999 total)