Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 2,462 total)

  • RE: Holidays and Calendar Generation

    Interesting article. Well done sir.

    "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

    February 16, 2016 at 8:05 am

    #1858989

  • RE: Are the posted questions getting worse?

    For those of you who are into quantum mechanics...

    IT'S OFFICIAL: Gravitational waves have been detected, Einstein was right

    "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

    February 11, 2016 at 3:03 pm

    #1858205

  • RE: Is monitoring production servers allowed using a Developer Edition?

    Microsoft actually allows you to chat with their licensing specialists online. It's been a few years but I have used this service and found them quite helpful.

    http://blogs.technet.com/b/volume-licensing/archive/2011/11/23/click-to-chat-now-on-microsoft-com-licensing.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

    February 2, 2016 at 8:03 am

    #1855990

  • RE: Are the posted questions getting worse?

    BL0B_EATER (1/29/2016)

    Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?

    During some tough projects I...

    "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, 2016 at 2:04 pm

    #1855394

  • RE: Are the posted questions getting worse?

    Phil Parkin (1/27/2016)

    Just expanding on this discussion a little: if there are people here who know both AWS and Azure, it would be nice to hear their views on pros...

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

    #1855064

  • RE: illegal xml character

    Just a guess but perhaps, before saving as Excel file, you could change:

    <summary>Errors were detected in file 'C:\Users\\Desktop\WS_Print.xlsx'</summary>

    To

    <summary>Errors were detected in file ''C:\Users\\Desktop\WS_Print.xlsx''</summary>

    Note the two single quotes instead 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 27, 2016 at 3:11 pm

    #1854829

  • RE: Easy puzzle, complicated query

    Can you explain what you mean by "line" and perhaps show us what the correct output would be for the sample data that you 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

    January 27, 2016 at 1:22 pm

    #1854809

  • RE: SQL Puzzle - Update

    I don't fully get what you are trying to do here. Can you post some sample data that shows what the desired output looks like?

    In the meantime, here's a...

    "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 27, 2016 at 1:18 pm

    #1854808

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/26/2016)

    TomThomson (1/25/2016)

    GilaMonster (1/25/2016)

    Bandwidth, latency and data out of the country (for 1 and 3)

    I see the same. Plus in the EU it's probably illegal to host 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 26, 2016 at 4:12 pm

    #1854585

  • RE: Reading XML files

    ramana3327 (1/26/2016)

    Hi,

    We have an xml file in network share. I am not what are the columns in that xml files to insert into a table

    SELECT * into XMLwithTest FROM OPENROWSET...

    "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, 2016 at 3:18 pm

    #1854574

  • RE: Same query produces dramatically different plans with identical data but one different table name?

    You did not attach anything. Can you attach the two versions of the query plans using just SSMS. I'm sure we can get to the bottom of this.

    "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, 2016 at 3:05 pm

    #1854568

  • RE: Crafting Your Resume

    Ivanova (1/26/2016)

    Sad to say, part of crafting a resumé which will pass the first stage of eliminations and get you in front of an interviewer may well be to omit...

    "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, 2016 at 9:19 am

    #1854472

  • RE: Bulk Insert XML...help

    No Namespace issues as far as I can tell. Here's a couple examples of how to parse your XML data:

    DECLARE @xml XML =

    '<xml xmlns:dt="urn:dt" xmlns:msxsl="urn:schemas-microsoft-com:xslt" dateofservice="1/1/2016 10:00" mmsid="201599999999" userid="dxxxxx9-xxx0-xxdb-xxx0-e8xxxxxxbcd" npid="dfxxxxx9-6xx0-xxxx-bxx0-exxxc1xxxxxd"...

    "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 25, 2016 at 2:29 pm

    #1854300

  • RE: Crafting Your Resume

    Good editorial and good link to the StackOveeflow article.

    I wonder how long resumes/CVs are going to be around. I could be wrong but kids in kindergarten today won't know...

    "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 25, 2016 at 7:29 am

    #1854153

  • RE: Need direction with DB table structure, denormalize?, and using SSIS and XML

    Should I normalize the data and create a table for client, assessments, assessment data (joined by assesmentID and clientID foreign keys)? Or should I create a denormalized data warehouse?...

    "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 2:38 pm

    #1853657

Viewing 15 posts - 1,021 through 1,035 (of 2,462 total)