Forum Replies Created

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

  • RE: Find foreign alphabet characters in a column

    Expanding on what Eirikur put together, here's how you could do it against a table (note my comments).

    -- Sample data

    DECLARE @table TABLE(stringID int identity primary key, stringTxt NVARCHAR(4000));

    INSERT @table(stringTxt)...

    "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 21, 2016 at 1:24 pm

    #1853631

  • RE: Recommended SQL Backup Software?

    I am also a fan of Redgate, never had any problems with it (I also don't work for Redgate). It's been awhile since I last used it but ApexSQL Backup...

    "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 21, 2016 at 12:40 pm

    #1853619

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (1/20/2016)

    Alan.B (1/20/2016)

    Eirikur Eiriksson (1/20/2016)

    Alvin Ramard (1/20/2016)

    Ed Wagner (1/20/2016)

    Steve Jones - SSC Editor (1/20/2016)

    This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue...

    "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 5:07 pm

    #1853337

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (1/20/2016)

    Alvin Ramard (1/20/2016)

    Ed Wagner (1/20/2016)

    Steve Jones - SSC Editor (1/20/2016)

    This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, 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 20, 2016 at 12:54 pm

    #1853270

  • 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

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