Forum Replies Created

Viewing 15 posts - 541 through 555 (of 2,462 total)

  • RE: Index INCLUDE

    nsadams87xx (8/12/2016)

    So it really should only be used with columns that are not updated very often, have large amounts of data, and those columns are often used together?

    Adding to what...

    "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

    August 12, 2016 at 10:46 am

    #1895260

  • RE: How do you know when it is time to leave a job?

    HappyGeek (8/11/2016)

    Iwas Bornready (7/25/2016)

    Yet Another DBA (7/22/2016)

    Time to leave?

    Hmm, with some companies its the day after I started.

    That's sad you didn't know that before you started.

    So how exactly do you...

    "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

    August 12, 2016 at 10:35 am

    #1895258

  • RE: Count the occurrence of word in a Resume Table

    shambhavi13 (8/11/2016)

    Thank you so much .

    Have one another question in mind .. what if I want to search more than one one word in a single document but in...

    "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

    August 12, 2016 at 9:10 am

    #1895231

  • RE: Make Schema Changes on Publication Databases

    Suth (8/12/2016)

    Hi,

    I currently need to make a number of schema changes to a database that is set up for replication (Transactional) the schema changes...

    "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

    August 12, 2016 at 8:01 am

    #1895218

  • RE: Question on Extended event

    vsamantha35 (8/11/2016)

    Thanks Alan.

    I have one more question, how to handle / avoid query timeouts?

    What Gail said really sums it up. 😉

    "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

    August 11, 2016 at 2:22 pm

    #1895114

  • RE: Questions on spills to tempdb

    Brandie Tarvin (8/11/2016)

    Recently I noticed some of my code has the warning "Operator used tempdb to spill data during execution with spill level 1." I have a few questions on...

    "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

    August 11, 2016 at 2:19 pm

    #1895113

  • RE: DateTo parameter not returning correct data

    To alleviate the SARGability problem with the "WHERE CAST(RequiredByDate AS DATE) BETWEEN @StartDate AND @EndDate" solution Drew and I provided you could create an indexed view like so:

    CREATE VIEW dbo.vw_TempDate

    WITH...

    "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

    August 11, 2016 at 9:39 am

    #1895032

  • RE: DateTo parameter not returning correct data

    Consider this query:

    DECLARE @StartDate DATETIME;

    DECLARE @EndDate DATETIME;

    SET @StartDate = '20160801'

    SET @EndDate = '20160805'

    SELECT startdate = @StartDate, enddate = @EndDate;

    Results:

    startdate ...

    "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

    August 11, 2016 at 8:30 am

    #1895007

  • RE: Strange update behaviour

    cmullen77 29296 (8/10/2016)

    Hey Alan,

    That was my point.. I had an issue running an update statement, so I started eliminating rows to figure out what was causing my problem. ...

    "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

    August 10, 2016 at 9:05 pm

    #1894924

  • RE: Question on Extended event

    http://www.scarydba.com/2015/03/12/monitoring-timeouts/%5B/url%5D

    "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

    August 10, 2016 at 7:13 pm

    #1894920

  • RE: Strange update behaviour

    cmullen77 29296 (8/10/2016)

    Okay, I MUST be missing something;

    update EmpActions set isactive = 'N' where 1=2

    When I run this, my MS SQL server goes to about 33% and just...

    "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

    August 10, 2016 at 7:06 pm

    #1894919

  • RE: help with effective dating logic

    is250sp (8/10/2016)

    I have a table with the following records.....

    emplid effdt effseqjobcode

    00001068 3/27/200500241

    00001068 ...

    "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

    August 10, 2016 at 12:56 pm

    #1894886

  • RE: Using Charindex

    sam 55243 (8/10/2016)

    Hi All,

    I'm using stored procedure where i'm getting role Id in comma separated values and i need to check for specific role id in that. Im using charindex...

    "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

    August 10, 2016 at 12:41 pm

    #1894882

  • RE: How do you manage your junior DBA

    S7 (8/10/2016)

    Do you give him/her a daily tasks to todo? How do you manage them? please help.

    Depends on what kind of DBA (operations, application, all of the above), how junior...

    "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

    August 10, 2016 at 12:19 pm

    #1894875

  • RE: Count the occurrence of word in a Resume Table

    shambhavi13 (8/10/2016)

    I am pretty satisfied with the NGrams8k solutions you gave . The results are accurate and since I only have to deal with one candidate at a time the...

    "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

    August 10, 2016 at 11:25 am

    #1894862

Viewing 15 posts - 541 through 555 (of 2,462 total)