Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 2,462 total)

  • RE: sp_executesql N'SELECT * INTO Error

    I want to start by saying that I am not providing an answer here but rather providing a little food for thought....

    All permissions are the same on both servers.

    But 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

    November 29, 2012 at 7:12 pm

    #1564120

  • RE: Splitting Strings Based on Patterns

    Great, great article Dwain. Amazing work and perhaps your best article yet on SSC IMHO (it's certainly your longest).

    I would have been delighted to propose a looping solution as...

    "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

    November 29, 2012 at 6:48 pm

    #1564114

  • RE: Keeping Current

    mike 57299 (11/28/2012)

    Hi All...

    ... As part of our backup plan, we do transaction log backups every hour during the work day.

    I would like to copy the logs to...

    "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

    November 28, 2012 at 4:05 pm

    #1563498

  • RE: create index on nvarchar value

    sa.ordekci (11/28/2012)

    ...As i know, indexed fields increase searching time. For example primary key.

    Indexes usually make queries faster. Primary keys usually make queries faster because an index is created when 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

    November 28, 2012 at 3:59 pm

    #1563496

  • RE: Recursion with a Twist

    Evil Kraig F (11/28/2012)

    Alan.B (11/28/2012)

    Evil Kraig F (11/28/2012)

    This is NOT pretty, but it IS functional.

    I am trying to understand why went with a loop vs a set-based approach. I posted...

    "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

    November 28, 2012 at 3:20 pm

    #1563485

  • RE: Recursion with a Twist

    Evil Kraig F (11/28/2012)

    This is NOT pretty, but it IS functional.

    I am trying to understand why went with a loop vs a set-based approach. I posted a more set based...

    "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

    November 28, 2012 at 3:00 pm

    #1563474

  • RE: Recursion with a Twist

    This is a bit tricky and I am still working on this. Here's what I have thusfar...

    --Create temp table to hold the dummy data

    if object_id('tempdb..#IDs') is not null

    drop table #IDs

    CREATE...

    "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

    November 28, 2012 at 2:11 pm

    #1563453

  • RE: How can I generate XML and apply a style sheet in t-sql?

    By "apply a style sheet" are you talking about applying an XML transform using XSLT or apply CSS formatting?

    "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

    November 28, 2012 at 9:57 am

    #1563285

  • RE: Not sure why PIVOT returns a single row?

    You can also do this (I'm just showing another way to pivot):

    ;WITH sourceData ([RowID],[Region], [Factor])

    AS

    (

    SELECT '1','Capitol',' Text1' UNION ALL

    SELECT '2','Capitol',' Text2' UNION ALL

    SELECT '3','Capitol',' Text3' UNION ALL

    SELECT '1','Central',' Text4'...

    "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

    November 28, 2012 at 9:47 am

    #1563273

  • RE: Configuring Replication in 2012

    No 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

    November 28, 2012 at 9:33 am

    #1563263

  • RE: Replication Issue

    Just wanted to know whether it is correct because i will doing it on the production and have to be very sure before doing and don't have any test...

    "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

    November 27, 2012 at 10:00 pm

    #1562923

  • RE: Convert rows to columns

    Edit: I misunderstood your question... What's with the NULLS?

    "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

    November 27, 2012 at 8:40 pm

    #1562910

  • RE: Is DBA a limited Profession ?

    Is DBA a limited Profession? Short answer: No. Long answer: Nope.

    "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

    November 27, 2012 at 4:03 pm

    #1562881

  • RE: XML DOM

    nsrikanth.seo (11/26/2012)

    The XML DOM defines a standard way for accessing and manipulating XML documents.

    The XML DOM views an XML document as a tree-structure.

    Thank u,

    Regards

    Srikanth

    rxonlineshopee.com:-)

    The DOM presents an XML document as...

    "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

    November 27, 2012 at 3:58 pm

    #1562879

  • RE: Embedding Report on webpage

    I have seen it done with Sharepoint 2010 and using the Microsoft Report Viewer Redistributable. I have never done it though nor am I a Sharepoint guy.

    "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

    November 27, 2012 at 3:44 pm

    #1562872

Viewing 15 posts - 2,341 through 2,355 (of 2,462 total)