Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 2,458 total)

  • RE: Gathering Stored Procedure execution time in real time?

    You could capture that amount of time that a stored procedure executes using Extended Events. "

    "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

    June 11, 2015 at 1:29 pm

    #1804819

  • RE: Select multiple values from same column and make them to show in a row

    Can how post some DDL, sample data and the query you used to get the result set 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

    June 10, 2015 at 2:27 pm

    #1804499

  • RE: For XML Path used to Concatenate with a comma separated string - Error message first time run - then it seems to work

    Mile Higher Than Sea Level (6/10/2015)

    The first time this code is run, there is an error message (See attachment).

    After clicking OK, it just runs fine.

    Is this error message normal?...

    "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

    June 10, 2015 at 2:21 pm

    #1804494

  • RE: SQL Server DBA or BI

    dniranjan2000 (6/10/2015)

    Hi Alan,

    Many Thanks for your suggestion and recommending the books.

    currently I am concentrating on T-SQL for a good foundation.

    Kind regards

    Niranjan

    Excellent. I got my Start in SQL in a similar...

    "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

    June 10, 2015 at 9:45 am

    #1804394

  • RE: Finding / getting in touch with recruiters?

    I'm with everyone else - SQL Saturday and Local User Groups are great resources.

    I would add - I have working in the past with Tek Systems. I think they...

    "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

    June 9, 2015 at 2:12 pm

    #1804120

  • RE: help me write the SQL

    The image you post does not help. DDL and some easily consumable sample data would be better.

    The logic you are looking for will look something like this:

    -- SOME...

    "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

    June 9, 2015 at 1:59 pm

    #1804117

  • RE: Parsing large varbinary fields

    The internal result strings are delimited with Char(10), conservative counts are from 64k to over 100k lines in each record. ...

    Is there a way to parse the individual lines into...

    "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

    June 9, 2015 at 1:45 pm

    #1804114

  • RE: SQL Server DBA or BI

    If you want to go the DBA route then you will want to learn more about backing up/restoring databases, Installing and configuring SQL Server, VMs, Disk storage and things 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

    June 9, 2015 at 10:42 am

    #1804036

  • RE: SSRS IIF Statement with Parameters

    You have:

    = IIF(Parameters!getSource.Value)="ACME", "Company1",Parameters!getSource.Value)

    Remove the parenthesis after ".Value":

    = IIF(Parameters!getSource.Value="ACME", "Company1",Parameters!getSource.Value)

    "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

    June 9, 2015 at 10:28 am

    #1804028

  • RE: PatExclude8K

    Iwas Bornready (6/8/2015)

    Good script, thank you.

    Thanks 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

    June 8, 2015 at 10:50 am

    #1803749

  • RE: A Case FOR Cursors...

    Sioban Krzywicki (6/5/2015)

    Brian J. Parker (6/5/2015)

    RonKyle (6/5/2015)

    That's a different but interesting topic. For that I have a separate Holiday table.

    I agree that that's a better way. It's been 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

    June 5, 2015 at 4:12 pm

    #1803488

  • RE: A Case FOR Cursors...

    Brian J. Parker (6/5/2015)

    RonKyle (6/5/2015)

    That's a different but interesting topic. For that I have a separate Holiday table.

    I agree that that's a better way. It's been on my list...

    "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

    June 5, 2015 at 2:44 pm

    #1803479

  • RE: A Case FOR Cursors...

    Jeff Moden (6/5/2015)

    Brian J. Parker (6/5/2015)

    This is completely branching off the topic of the original article, but... I've grown accustomed to instantiating a Tally table whenever possible in any database...

    "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

    June 5, 2015 at 2:27 pm

    #1803471

  • RE: A Case FOR Cursors...

    RonKyle (6/5/2015)

    Why do you need the hour? Is that necessary to populate the date when it's just the date? I'm intrigued by this method, but not sure 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

    June 5, 2015 at 1:33 pm

    #1803463

  • RE: Should Salary Information Be Confidential?

    Not sure if anyone mentioned this yet but I figured I'd add in:

    US military jobs, even civilian ones on bases, have ranks, and the pay for each rank is known...

    "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

    June 5, 2015 at 1:20 pm

    #1803459

Viewing 15 posts - 1,366 through 1,380 (of 2,458 total)