Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 6,041 total)

  • RE: Whitespace in 3-part name ignored???


    Sadly, this is T-SQL legal too.


    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 8, 2017 at 6:55 am

    #1932285

  • RE: Whitespace in 3-part name ignored???

    Let's keep this secret to ourselves, lest folks will want to start coding that way.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 8, 2017 at 5:51 am

    #1932264

  • RE: The Secure Medical Data Challenge

    jasona.work - Tuesday, March 7, 2017 10:35 AM

    One thing I've picked up from watching various investigative shows (the ones that give the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 7, 2017 at 12:52 pm

    #1932148

  • RE: Actionable Metrics

    You're making me think about about SQL Server performance monitoring metrics as an example.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 7, 2017 at 6:40 am

    #1932029

  • RE: Primary key violation on INSERT, even though TABLOCKX is held

    I wouldn't resort to (or rely upon) table locking or serializable isolation level for something like this. It could inadvertently block other processes that only need read access, and at...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 6, 2017 at 11:34 am

    #1931889

  • RE: Containing the Work

    Once SQL Agent and SSIS are ported to Azure, I expect they will be contained at the database level, functionality which would probably trickle down to the on-prem version of...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 6, 2017 at 7:48 am

    #1931801

  • RE: Create sql login for reporting activity

    Jeff Moden - Sunday, March 5, 2017 1:41 PM

    PeopleFlyFree - Friday, March 3, 2017 6:47 AM

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 6, 2017 at 7:31 am

    #1931788

  • RE: Create sql login for reporting activity

    PeopleFlyFree - Friday, March 3, 2017 9:38 AM

    I know there have been complaints about this in the past and I thought...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 3, 2017 at 11:20 am

    #1931588

  • RE: SQL Server on VMWare w/1CPU 1 Core

    The company I work for has 2000+ retail store locations, each running a local instance of SQL Server Express Edition to support their point of sale. That's production. We...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 3, 2017 at 8:49 am

    #1931539

  • RE: The Secure Medical Data Challenge

    jay-h - Thursday, March 2, 2017 6:38 AM

    Also we need to realize that PCR amplification used in DNA matching is a slow...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 3, 2017 at 8:27 am

    #1931522

  • RE: Performance of Temp table vs Variable Table in a Procedure

    John Mitchell-245523 - Friday, March 3, 2017 3:00 AM

    Yes, lack of statistics on table variables is likely to lead to inappropriate memory...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 3, 2017 at 7:01 am

    #1931490

  • RE: The Secure Medical Data Challenge

    drew.allen - Wednesday, March 1, 2017 10:47 AM

    andrew gothard - Wednesday, March 1, 2017 8:50 AM

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 1, 2017 at 1:52 pm

    #1931062

  • RE: Using a WHERE clause as a parameter

    What if they pass in the following parameter?

    ; DELETE FROM SYSADM.CUSTOMERS;

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 1, 2017 at 8:21 am

    #1930981

  • RE: RDP into SQL server BAD or not

    It doesn't matter how many GB of memory total are on the server. How much memory is reserved for Windows and applications (including SSIS/SSRS/SSAS) depends on the min/max memory settings...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 1, 2017 at 6:48 am

    #1930948

  • RE: The Secure Medical Data Challenge

    jay-h - Tuesday, February 28, 2017 3:51 PM

    Part of the issue of DNA is that it is not like a digital signature,...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    March 1, 2017 at 6:14 am

    #1930939

Viewing 15 posts - 1,636 through 1,650 (of 6,041 total)