Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 2,462 total)

  • RE: Using sp_MSForeachdb to create a SCHEMA

    Will read the entire OP moving forward.

    "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

    May 5, 2015 at 2:50 pm

    #1795758

  • RE: Cannot find the object "Table_Name" because it does not exist or you do not have permissions.

    rpetit1230 (5/5/2015)

    I'm trying to run an Insert on tables using a User Login but I keep getting the error above. I ran the insert using my own credentials and 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

    May 5, 2015 at 2:41 pm

    #1795753

  • RE: Are the posted questions getting worse?

    Luis Cazares (5/1/2015)

    Jeff Moden (5/1/2015)

    I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him...

    "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

    May 1, 2015 at 2:53 pm

    #1795124

  • RE: SQL - Where Row_Number = 1 discussion

    w.zia.2015 (4/30/2015)

    Afternoon ladies and gents,

    I'm trying to find an alternative, more efficient way of processing some code to select the top row of a specific order.

    At the moment we use...

    "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

    April 30, 2015 at 9:39 am

    #1794749

  • RE: How to use a year and month fields to get a range of records

    pietlinden (4/28/2015)

    Save yourself the headache. Store the dates as dates, not as two columns with numbers. Then you can do date math really easily, index columns and all...

    "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

    April 28, 2015 at 9:12 pm

    #1794169

  • RE: How to use a year and month fields to get a range of records

    I think you are looking for (I'm calling your Year column "yearCol" and month column "monthCol":

    WHERE

    (yearCol = 2014 AND monthCol >= 9) -- All dates in year...

    "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

    April 28, 2015 at 9:10 pm

    #1794168

  • RE: Matching two Data Sets

    Using the DDL and example data that you provided can you provide an example of what the correct output would look like?

    "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

    April 28, 2015 at 5:20 pm

    #1794147

  • RE: Is it worth to pursue a C# cert for a SQL Dev focused career path?

    Getting a cert should not hurt you in any way. That said, I learned C# about 12/13 years ago because, at the time I wanted to be a .NET web...

    "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

    April 28, 2015 at 11:38 am

    #1794042

  • RE: XML Data retrieval

    The @ sign is used for referring to XML attributes. You are looking for the value of the Element.

    Below is the code that will get you what you are...

    "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

    April 27, 2015 at 8:56 pm

    #1793854

  • RE: What is a "set-based loop?"

    dwain.c (4/27/2015)

    Alan.B (4/27/2015)

    Jeff Moden (4/26/2015)

    Alan.B (4/26/2015)

    Over the past year I have heard some folks around here talk about a "set based loop". What's that all about? Can someone provide 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

    April 27, 2015 at 8:37 pm

    #1793852

  • RE: What is a "set-based loop?"

    Gary Harding (4/27/2015)

    Jeff Moden (4/26/2015)

    You're seriously aware of one of the more famous Pseudo-Cursors there is... a SELECT that uses a Tally Table.

    When I first saw this type of usage...

    "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

    April 27, 2015 at 10:45 am

    #1793745

  • RE: What is a "set-based loop?"

    Jeff Moden (4/26/2015)

    Alan.B (4/26/2015)

    Over the past year I have heard some folks around here talk about a "set based loop". What's that all about? Can someone provide an example?

    There are...

    "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

    April 27, 2015 at 10:44 am

    #1793739

  • RE: Noob Powershell String Parsing Question

    I figured it out...

    $myArray =@()

    foreach ($item in $TestLocations) { $myArray += $item.LineNumber }

    "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

    April 24, 2015 at 2:30 pm

    #1793416

  • RE: Compare column in two tables

    dwain.c (4/20/2015)

    Interesting solutions there gentleman, but regardless of how you set up your PRIMARY KEY/INDEXing, might this not be just a tad simpler?

    SELECT name, =MAX()

    FROM

    (

    SELECT name,...

    "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

    April 22, 2015 at 8:30 pm

    #1792906

  • RE: Compare column in two tables

    DonlSimpson (4/22/2015)

    Alan.B (4/21/2015)

    Minnu (4/21/2015)

    Hi Team,

    The solution provided by are working fine..

    but there is a change in my result.

    my request is

    if a record_1 is in Table_A and Table_B, then

    output...

    "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

    April 22, 2015 at 6:07 pm

    #1792886

Viewing 15 posts - 1,546 through 1,560 (of 2,462 total)