Forum Replies Created

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

  • RE: Prompt for Date Range?

    tsobiech (6/12/2015)

    ...

    Things would be so much easier if I could just use a parameter in a view.

    That's what an inline table valued function is (or at least how you can...

    "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 12, 2015 at 11:57 am

    #1805178

  • RE: sp_who3 showing sleeping ask

    Shawn Melton (6/12/2015)

    Just go download Sp_WhoIsActive and use it.

    +1

    Awesome tool!

    "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 12, 2015 at 8:55 am

    #1805083

  • RE: sp_who3 showing sleeping ask

    And... SP_WHO3 is not a built-in Microsoft sproc. - can you post the DDL you are using to create SP_WHO3?

    "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 12, 2015 at 8:42 am

    #1805077

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

    JP10 (6/11/2015)

    Alan, your saying for the total time it took to execute and not in real time correct?

    I don't know if I understand your question so I'm not sure if...

    "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 7:02 pm

    #1804868

  • 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

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