Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 2,462 total)

  • RE: Concatenating multiple rows(certain columns)

    DDL, more sample data and a better description make this easier but here is a possible solution...

    -- (1) Sample Data

    DECLARE @table TABLE (ID int, Seq char(2), [desc] varchar(50), DateOpen date,...

    "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 29, 2015 at 10:28 am

    #1774091

  • RE: Need help getting XML data out of SQL table

    You can lose one cross apply and further simplify the query like this:

    SELECT

    o.value('(del_Nr/text())[1]', 'VARCHAR(10)') as PONbr,

    o.value('(del_Third_Nr/text())[1]', 'VARCHAR(10)') AS NCubeID,

    ...

    "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 28, 2015 at 9:39 am

    #1773738

  • RE: 3rd party tools for backup compression

    Michael Valentine Jones (1/26/2015)

    I haven't seen much improvement in compression using third party backup tools compared to the native SQL Server 2008R2 backup compression.

    Some of the third party backup tools...

    "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 26, 2015 at 9:41 am

    #1773165

  • RE: 3rd party tools for backup compression

    As far as 3rd party tools are concerned, SQL Backup Pro[/url] has worked well for me. It has a lot of other useful functionality in addition to compression.

    "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 26, 2015 at 9:14 am

    #1773147

  • RE: Help needed for very simple data manipulation

    Option 2

    I was making the assumption that "AND"/"OR" values were not in their own column. If I was wrong, here's another option:

    WITH

    x AS

    (

    SELECTyt1.c1,

    yt1.c2,

    yt1.c3,

    yt1.c4,

    xx =...

    "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 26, 2015 at 8:40 am

    #1773138

  • RE: Help needed for very simple data manipulation

    Sample DDL is always helpful; I put some together for your this time. I think you are looking for something like this:

    -- (1) Sample DDL and Sample data

    DECLARE @yourtable 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

    January 26, 2015 at 8:28 am

    #1773132

  • RE: Issue retrieving XML value in result set...

    Just a quick performance note; when returning a text value from XML, you should specify the text() node for better performance.

    For example, this:

    [extendedinfo].value('(/ExtendedInfo/Fragmentation)[1]', 'DECIMAL(4,1)') )+'%' AS 'extendedinfo'

    should be this:

    [extendedinfo].value('(/ExtendedInfo/Fragmentation/text())[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

    January 23, 2015 at 2:44 pm

    #1772839

  • RE: Change Dataset for a Tablix ?

    No prob. Glad to help!

    "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 23, 2015 at 2:22 pm

    #1772835

  • RE: Import XML file in an Table

    I believe the answer is in the article you posted. under Security Considerations it reads (emphasis mine),

    ...A login using SQL Server authentication cannot be authenticated outside of the Database Engine....

    "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 23, 2015 at 2:19 pm

    #1772834

  • RE: Change Dataset for a Tablix ?

    First you click anywhere on the new tablix. When you do that there is a grey outline, right-click on the top left-hand corner...

    Next, click on the Tablix Properties option. Provided...

    "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 23, 2015 at 12:58 pm

    #1772809

  • RE: Optimizing Stored Procedure to go Parallel.

    TheSQLGuru (1/22/2015)

    pkapas (1/22/2015)

    I'm a one man team for the whole company, taking care of System Administration, Database Administration, Development, Networking, Implementations, End-User support, etc. Basically everything IT. A jack of...

    "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 22, 2015 at 2:57 pm

    #1772417

  • RE: Create a Pop up window in ssrs

    I am working on a project where we are using asp.net mvc. This may be an option as well. Take a look at:

    http://www.codemag.com/Article/1009061

    "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 22, 2015 at 10:41 am

    #1772328

  • RE: Exam 70-461 question

    The book that Koen mentioned is my favorite t-sql book and I second his recommendation. Anything by Ben-Gan is worth it's weight in gold Imho. I have not taken 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

    January 22, 2015 at 10:23 am

    #1772322

  • RE: Optimizing Stored Procedure to go Parallel.

    Take a look at make_parallel() by Adam Mechanic. I have had a lot of success with it and may be helpful in this situation.

    http://sqlblog.com/blogs/adam_machanic/archive/2013/07/11/next-level-parallel-plan-porcing.aspx

    "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 22, 2015 at 9:20 am

    #1772282

  • RE: Growing Your SQL Server Skills without Breaking the Bank

    Great article! I would add one more thing... Redgate go to Redgate SQL In the City:-P.

    "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 2, 2015 at 12:47 am

    #1767346

Viewing 15 posts - 1,801 through 1,815 (of 2,462 total)