Forum Replies Created

Viewing 15 posts - 46 through 60 (of 121 total)

  • RE: Log file shrinking

    pooyan_pdm (8/9/2012)

    run select * from sys.databases and check log_reuse_wait_desc

    you might have an active transaction to check that you can use dbcc opentran('DBName')

    I did that and it came back with...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    August 9, 2012 at 12:31 pm

    #1524033

  • RE: Comparing negative number for conditional formatting

    Haha, that was it exactly! Too early in the morning for that 😉 And my formatting was backwards. Thanks!

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    April 19, 2012 at 7:07 am

    #1475989

  • RE: Long running query on only one server

    Alexander Suprun (3/13/2012)

    How do you expect someone to explain it to you if we don't know what exactly have you changed and how the execution plan looks now? In general,...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    March 13, 2012 at 7:49 pm

    #1458964

  • RE: Long running query on only one server

    I figured out that it was actually being caused by indexing.

    On the old server, there were several of the tables that were heaps with non-clustered indexes. I...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    March 13, 2012 at 6:35 pm

    #1458950

  • RE: Long running query on only one server

    rafael lenartowicz (3/11/2012)

    I've seen it happen where indexes / exec plans got "stale" after backup/restore; SQL totally ignoring existance of indexes, even though they're there and "should" be used.

    I'd start...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    March 12, 2012 at 6:15 am

    #1457778

  • RE: Long running query on only one server

    Here is the current execution plan

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    March 11, 2012 at 2:37 pm

    #1457631

  • RE: Long running query on only one server

    Aneesh Soman (3/8/2012)

    Please add more info about the particular query.

    SELECT mbm1.BMWHS

    ,mbm1.BPROD AS BPROD_L1

    ,iimx.IPROD AS BCHLD

    ,iimx.IDESC

    ,iimx.IITYP

    ,iimx.IUMS

    ,(cmf.Ingredients+cmf.Packaging) AS COST

    ,((ISNULL(mbm1.BQREQ,1))/ISNULL(cic1.ICBTCH,1))

    *((ISNULL(mbm2.BQREQ,1))/ISNULL(cic2.ICBTCH,1))

    *((ISNULL(mbm3.BQREQ,1))/ISNULL(cic3.ICBTCH,1))

    *((ISNULL(mbm4.BQREQ,1))/ISNULL(cic4.ICBTCH,1))

    *((ISNULL(mbm5.BQREQ,1))/ISNULL(cic5.ICBTCH,1))

    *((ISNULL(mbm6.BQREQ,1))/ISNULL(cic6.ICBTCH,1))

    AS QTYREQ_NOSCRAP

    ,((ISNULL(mbm1.BQREQ,1)*ISNULL(mbm1.BMSCP,1))/ISNULL(cic1.ICBTCH,1))

    *((ISNULL(mbm2.BQREQ,1)*ISNULL(mbm2.BMSCP,1))/ISNULL(cic2.ICBTCH,1))

    ...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    March 8, 2012 at 1:17 pm

    #1456782

  • RE: Find best key columns for Clustered Index

    Thanks. I understand the concepts when you know the data but what if you don't know the data? Is there a quick script that will show each columns...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    December 19, 2011 at 1:34 pm

    #1423296

  • RE: Reindexing via a MultiServer Administration Job

    Thank you, I will take a look!

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    November 10, 2011 at 4:17 pm

    #1406046

  • RE: SA disabled and no other logins with Sysadmin...HELP!

    So what we ended up doing was to stop the services and start in single user mode and add the new accounts.

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    September 3, 2011 at 11:42 am

    #1376785

  • RE: Linked Server Basics - Who can use them

    Go to the linked server properties, the security tab. There is a radio button below that says for logins not in the list, what do you do? If you check,...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    August 10, 2011 at 7:24 am

    #1366537

  • RE: Linked Server Basics - Who can use them

    Steve Jones - SSC Editor (8/9/2011)

    There is a default mapping, which makes the linked server a public object, but if you say that Joe in SQL Server is mapped to...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    August 9, 2011 at 9:54 am

    #1366042

  • RE: Linked Server Basics - Who can use them

    So you can put an Oracle login in the "Remote User" field? When I try it gives me an "invalid user/pass" error, even though it works if I just...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    August 9, 2011 at 9:01 am

    #1365986

  • RE: Have to startup SSMS 'As Administrator' in OS when local

    Jeffrey Williams-493691 (5/31/2011)

    This should get you started: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx

    That worked, thanks!

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    May 31, 2011 at 4:35 pm

    #1332299

  • RE: Have to startup SSMS 'As Administrator' in OS when local

    Jeffrey Williams-493691 (5/31/2011)

    This is the same issue you will see on Windows Vista or Windows 7. You are running into an issue with UAC - which is causing you...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

    May 31, 2011 at 1:40 pm

    #1332250

Viewing 15 posts - 46 through 60 (of 121 total)