Forum Replies Created

Viewing 15 posts - 601 through 615 (of 2,458 total)

  • RE: Sequence generation

    TheSQLGuru (7/12/2016)

    Alan: your PK breaks inserts of >1 row with the same datetime value, which is going to happen both with multi-row batch inserts as well as concurrent access (due...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 12, 2016 at 12:08 pm

    #1889688

  • RE: The COUNT Function in T-SQL

    patrickmcginnis59 10839 (7/12/2016)

    Igor Micev (7/12/2016)

    patrickmcginnis59 10839 (7/12/2016)

    An ORDER BY clause can be used explicitly in the end as well. In that case the COUNT is not deterministic. See Deterministic and...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 12, 2016 at 12:01 pm

    #1889686

  • RE: The COUNT Function in T-SQL

    Great work Igor, 5 stars!. You did a great job grouping (pun not intended :-P) together the most important aspects of COUNT. Fantastic article and a great resource to point...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 12, 2016 at 11:53 am

    #1889682

  • RE: Sequence generation

    Jeff beat me to it. Here's some DDL that shows how to implement what Jeff suggested.

    USE tempdb -- a safe place to test this out...

    GO

    -- (0) Your table...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 12, 2016 at 10:49 am

    #1889662

  • RE: max degree of parallelism

    To get the current max degree of parallelism for a specific instance of SQL Server:

    SELECT value_in_use

    FROM sys.configurations

    WHERE name = 'max degree of parallelism'

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 12, 2016 at 10:19 am

    #1889651

  • RE: Today's Random Word!

    Manic Star (7/12/2016)

    djj (7/12/2016)

    crookj (7/12/2016)

    djj (7/12/2016)

    Revenant (7/11/2016)

    Ed Wagner (7/11/2016)

    whereisSQL? (7/11/2016)

    HappyGeek (7/11/2016)

    Ed Wagner (7/11/2016)

    djj (7/11/2016)

    Y.B. (7/11/2016)

    Luis Cazares (7/11/2016)

    djj (7/11/2016)

    Ray K (7/11/2016)

    Ed Wagner (7/11/2016)

    Lion

    Tiger

    Bears (oh, my)

    Care

    Package

    Amazon

    Prime

    Target

    Practice

    Marksmanship

    Aim

    Focus

    Motivation

    Speaker

    Anxiety

    attack

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 12, 2016 at 7:09 am

    #1889596

  • RE: Today's Random Word!

    Revenant (7/11/2016)

    HappyGeek (7/11/2016)

    eccentricDBA (7/11/2016)

    Ed Wagner (7/11/2016)

    whereisSQL? (7/11/2016)

    Manic Star (7/11/2016)

    djj (7/11/2016)

    BWFC (7/11/2016)

    Ed Wagner (7/11/2016)

    Grumpy DBA (7/11/2016)

    eccentricDBA (7/11/2016)

    Ed Wagner (7/11/2016)

    Manic Star (7/11/2016)

    Luis Cazares (7/11/2016)

    Ed Wagner (7/11/2016)

    Boom

    chick-chicky-boom

    Explosion

    Shrapnel

    collateral damage

    Arnold Schwarzenegger

    Terminator

    Semi-colon

    sigmoid colon

    Sigmund Freud

    Psychoanalysis

    Why

    Socratic Method

    Ask

    Bid

    den

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 11, 2016 at 10:55 am

    #1889480

  • RE: Nasty Fast N-Grams (Part 1): Character-Level Unigrams

    Ed Wagner (7/8/2016)

    Very nice work, Alan. I think you explained the concept really well and used some very good examples. I have to tell you that it reminds...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 8, 2016 at 2:07 pm

    #1889265

  • RE: Simple CLR request

    Ok Solomon, I tried to figure this out and failed. Forgive my CLR noobness (I create about 1 CLR/year) and I'm sure this is simple but I'm having a hard...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 7, 2016 at 8:26 am

    #1888952

  • RE: New T-SQL Fixed Width "Splitter"

    Marcia J (7/5/2016)

    I don't know if it's just my machine, but the final code box is empty. I tried Chrome, IE, and IE with compatibility settings. I assume...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 7, 2016 at 7:23 am

    #1888906

  • RE: Experience, Location & Salary for Database Professionals in USA

    sqld-_-ba (7/6/2016)

    Hello Fellow DBAs/Developers/Consultants/Managers,

    I couldn't find a reliable + recent source for DBA salaries in USA.

    Glassdoor.com is very good and reliable. For example - a google search for "glassdoor dba...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 6, 2016 at 10:12 am

    #1888734

  • RE: Finding a substring and extracting a number associated with it

    J Livingston SQL (7/5/2016)

    Hi Alan..have been following your recent scripts and am suitably impressed.

    Thanks a lot J. That means a lot!

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 5, 2016 at 6:47 pm

    #1888602

  • RE: Split AlphaNumeric

    Here's a couple solutions based on what your output should look like for the values "MDL-9054-1" and "TX GMS-7000"

    DECLARE @strings TABLE(string varchar(100));

    INSERT @strings VALUES('MDL-9054-1'),('TX GMS-7000');

    SELECT

    ColA = SUBSTRING(string,1,CHARINDEX('-',string)-1),

    ...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 5, 2016 at 3:26 pm

    #1888578

  • RE: Finding a substring and extracting a number associated with it

    Another approach would be to split the text into word-level bi-grams using NGrams8K[/url]. See the article for the function and a description of what a word-level bi-gram is.

    Using...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 5, 2016 at 3:10 pm

    #1888573

  • RE: Help creating a dynamic table of numbers

    thomashohner (7/5/2016)

    ... re-code the wheel.

    Haha! +1

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 5, 2016 at 9:36 am

    #1888491

Viewing 15 posts - 601 through 615 (of 2,458 total)