Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 2,458 total)

  • RE: Is this an SQL Server error

    I do not understand at all why I get a duplicate key error, when I am modifying data in the same record previously searched, not adding a new one.

    That's an...

    "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

    January 20, 2016 at 12:14 pm

    #1853258

  • RE: What is recursion?

    Based on this thread it sounds as if you are dealing with a recursive CTE and I think you've received pretty good input.

    With respect to SQL Server the only...

    "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

    January 20, 2016 at 7:53 am

    #1853148

  • RE: Time and Space: How to Monitor Drive Space in SQL Server

    Just finished reading this. Excellent article Ed!

    Extra cudos on the clever title and the naming of #DatesOfDeath made me chuckle.

    "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

    January 20, 2016 at 7:11 am

    #1853127

  • RE: Shredding XML

    guru2007 (1/12/2016)

    Any simple answer to why I was receiving null from the query I was using?

    Just adding to what Eirikur said - returning a NULL is the default behavior for...

    "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

    January 12, 2016 at 12:24 pm

    #1851390

  • RE: Improving string comparisons that use like

    As already stated. atomic values would be ideal but sometimes you have to play the schema your dealt. One solution would be Full Text indexing then, instead of WHERE policyid...

    "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

    January 11, 2016 at 10:03 pm

    #1851221

  • RE: Shredding XML

    Try:

    select dummyxml.value('(/*:Contact/*:CustomerId/text())[1]', 'nvarchar(max)')

    from [dbo].[DummyTable]

    "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

    January 11, 2016 at 9:42 pm

    #1851219

  • RE: Full Text Search Slowness

    Ok, I have a nasty fast alternative for your under performing full-text index. We're going to create what I'll call a Nindex (N-Grams Index); it involves a Tally table 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

    January 11, 2016 at 7:38 pm

    #1851213

  • RE: Full Text Search Slowness

    homebrew01 (1/11/2016)

    Alan.B (1/11/2016)

    A few things:

    Can you post the query plan that's used for this query?

    Also, does that column need to be NULLable? If not can you set it to NOT...

    "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

    January 11, 2016 at 1:58 pm

    #1851131

  • RE: Full Text Search Slowness

    A few things:

    Can you post the query plan that's used for this query?

    Also, does that column need to be NULLable? If not can you set it to NOT NULL, run...

    "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

    January 11, 2016 at 12:36 pm

    #1851098

  • RE: XQuery question

    Brad Allison (1/11/2016)

    I had a crash course on XQuery over this weekend as I have a client that is in need of some text data out of an XML column...

    "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

    January 11, 2016 at 12:23 pm

    #1851095

  • RE: the use of CTEs

    Jeff Moden (1/7/2016)

    Alan.B (1/6/2016)

    You can't write a recursive CTE with using pre-CTE features.

    Technically correct because only an rCTE can be an rCTE but the rather well advertised rave 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

    January 11, 2016 at 12:14 pm

    #1851093

  • RE: the use of CTEs

    erics44 (1/8/2016)

    ChrisM@Work (1/8/2016)

    erics44 (1/8/2016)

    ChrisM@Work (1/8/2016)

    erics44 (1/8/2016)

    Hugo Kornelis (1/8/2016)

    erics44 (1/8/2016)

    Hugo Kornelis (1/8/2016)

    Jeff Moden (1/7/2016)

    Alan.B (1/6/2016)

    You can't write a recursive CTE with using pre-CTE features.

    Technically correct because only an rCTE can...

    "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

    January 11, 2016 at 12:03 pm

    #1851090

  • RE: Salary vs contract rate?

    [font="Arial Narrow"]

    SeattleDBA (1/10/2016)

    Alan.B (1/4/2016)

    If the FTE salary for my area is $130,000 to $140,000 for a senior level DBA, that would be about $65 (W2) per hour based on 2,000...

    "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

    January 11, 2016 at 11:43 am

    #1851078

  • RE: Adios, IE

    Good riddance, I'm a Chrome guy myself. The only time I have IE open is because some application/website that I am working with must work with IE (e.g. an SSRS...

    "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

    January 11, 2016 at 10:58 am

    #1851054

  • RE: When a Service Pack or Cumulative Update Install Fails by “Evaporating"

    Good stuff. I've been there.

    "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

    January 11, 2016 at 8:21 am

    #1850978

Viewing 15 posts - 1,036 through 1,050 (of 2,458 total)