Forum Replies Created

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

  • 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

  • RE: Extracting Numbers from String

    Just another way to approach this... If you know what characters you want to remove you can use this translate function. Note the comments for how to use.

    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 2, 2015 at 7:42 pm

    #1802480

  • RE: Alternavite to RDP on Prod server

    Yep. RDP is very bad for managing SQL Server. For stuff like services, event viewer, etc you can right-click on those things locally and and select "manage another computer"...

    "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 2, 2015 at 4:50 pm

    #1802475

  • RE: Extracting Numbers from String

    Eirikur Eiriksson (6/2/2015)

    Lowell (6/2/2015)

    Eirikur Eiriksson (6/2/2015)

    Lowell (6/2/2015)

    take a look at this thread from a while ago: it's got some excellent examples on stripping out non-numeric characters in the fastest way...

    "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 2, 2015 at 3:51 pm

    #1802468

  • RE: SSRS Report Permission

    sheba.sql (6/2/2015)

    Hello all,

    I gave a user all required permission to view the SSRS report. User is able to select from the dropdown list but unable to view the data, 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 2, 2015 at 3:35 pm

    #1802467

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