Forum Replies Created

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

  • 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

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

    Koen Verbeeck (8/5/2013)

    Great overview. I'll refer to this post every time someone asks for free training 😀

    Ditto that. Me too!

    "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:42 am

    #1767344

  • RE: Parsing HTML to SQL using SQLDOM

    taylor_benjamin (12/29/2014)

    This is a really cool exercise. However, it should remain simply that.

    SQL is not HTML

    HTML is not SQL

    I can't believe nobody else has raised a warning flag 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

    December 29, 2014 at 7:02 pm

    #1766901

  • RE: SQL Server 2014 Checklist for Performance

    Sorry if I am repeating what anyone else said - I have not had a chance to read through all the comments. Here's my 2 cents:

    Normalize the data as it...

    "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

    December 29, 2014 at 10:01 am

    #1766817

  • RE: Parsing HTML to SQL using SQLDOM

    Great article. We'll done sir!

    I do, however, disagree a little with this line (emph. mine)...

    But HTML is often not well-formed XML. Some tags are "singleton" tags--that do not require end...

    "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

    December 28, 2014 at 12:10 am

    #1766597

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