Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 2,462 total)

  • RE: Should Salary Information Be Confidential?

    I had boss once, a VP, who was not all that bright and he would share his Outlook calendar; nothing wrong with that - we all shared our calendars (and...

    "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 4, 2015 at 9:33 pm

    #1803222

  • RE: incement by 5 starting at 5

    I have a get numbers function that I use for exactly this sort of thing. It comes in handy often...

    IF OBJECT_ID('dbo.GetNumsAB','IF') IS NOT NULL

    DROP FUNCTION dbo.GetNumsAB;

    GO

    CREATE FUNCTION dbo.GetNumsAB(@low int, @high...

    "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 4, 2015 at 6:17 pm

    #1803211

  • RE: The right way to query an extended events session?

    Grant beat me to it.

    I only just started using extended events and have a lot to learn but I have found that querying the file directly has been pretty...

    "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 4, 2015 at 5:51 pm

    #1803203

  • RE: Usage of CTE - Trick with Dates

    HLogic (6/4/2015)

    nycdotnet (6/18/2013)

    Interesting article. Regarding the paradox of semicolons on CTEs - the rule is "the statement before the CTE has to end with a semicolon".

    I believe...

    "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 4, 2015 at 9:44 am

    #1803064

  • RE: SQL SERVER 2008 to Json

    datelligence (5/2/2012)

    Hi, I need to query data from a MSSQL server 2008 table and parse it in JSON. Have any ideas.

    Need to query any table.

    Need to...

    "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 4, 2015 at 7:44 am

    #1802988

  • RE: please help us to improve this query performance level without affecting the existing functionality

    mohanaprabhu.v (6/4/2015)

    SELECT tblInvoice.*, tblCustomer.FirstName + SPACE(1) +

    tblCustomer.LastName as CustomerName FROM tblInvoice WITH(NOLOCK)

    LEFT JOIN tblCustomer WITH(NOLOCK) ON tblInvoice.CustomerNo = tblCustomer.CustomerNo

    See the link in my signature about the best way to get...

    "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 4, 2015 at 6:26 am

    #1802954

  • RE: Are the posted questions getting worse?

    TomThomson (6/3/2015)

    Luis Cazares (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    Lynn Pettis (6/2/2015)

    SMH...

    Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of -6...

    "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 3, 2015 at 5:52 pm

    #1802844

  • RE: BI Path?

    bsmith 63193 (6/3/2015)

    There's so much to know about BI but I can break it down into 3 groups: Reporting, ETL and Analysis. If you want to go the reporting route...

    "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 3, 2015 at 5:50 pm

    #1802843

  • RE: Are the posted questions getting worse?

    So I'm curious about this (I'm trying to understand how SSC works):

    Then the comment is not there...

    "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 3, 2015 at 4:26 pm

    #1802835

  • RE: BI Path?

    bsmith 63193 (6/3/2015)

    I am wanting to redirect my current career path into Business Intelligence (BI) and am looking for feed back from the community on recommended steps to take to...

    "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 3, 2015 at 4:07 pm

    #1802834

  • RE: Performance Tuning - Adding Index

    ramana3327 (6/3/2015)

    Hi,

    I am working application performance.

    I created a index for one of select statement. It is reducing the execution time more than a min but

    How can we say the newly...

    "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 3, 2015 at 11:29 am

    #1802746

  • RE: A T-sql question.

    Dan121 (6/3/2015)

    TranId NameDate

    111John 1/3/2015

    111Mike4/4/2015

    222Mike5/5/2015

    222John1/6/2015

    333kim3/7/2015

    333Kim2/8/2015

    I need all order no. associate with above columns (with exact 5 rows).

    example:

    elect TranId , Name, Date ,...

    "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 3, 2015 at 11:19 am

    #1802744

  • RE: Going from 15 Minute intervals to 1 min intervals

    I am certain that this can be done but we don't have enough to go by here. Can you post an example of what log data looks like and how...

    "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 3, 2015 at 11:05 am

    #1802741

  • RE: Access SQL instance without sa password

    As far as I know you are out of luck.

    Are you sure the credentials were removed or was that account just disabled? If possible you could work with 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

    June 3, 2015 at 10:56 am

    #1802740

  • RE: How can I format this Control

    You can't do that. That area is reserved by SSRS for parameters and there is no way to change that using native SSRS. You could, however, use a third party...

    "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 3, 2015 at 10:49 am

    #1802737

Viewing 15 posts - 1,396 through 1,410 (of 2,462 total)