Forum Replies Created

Viewing 15 posts - 1 through 15 (of 17 total)

  • RE: iPads for Christmas

    iPad meets the Rural Lifestyler.

    Like quite a number of IT professionals in the Bay of Plenty, NZ, I have bought into the dream of having an intense IT career and...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    December 13, 2010 at 4:16 pm

    #1261977

  • RE: Performance - fast query running slow in a stored procedure

    New plan, post changes hereto attached.

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    November 4, 2010 at 1:31 pm

    #1246796

  • RE: Performance - fast query running slow in a stored procedure

    Thanks ALZDBA - this guided me into a number of areas to tweak a validate.

    USERNAME - I created a computed field to create a SimpleUserName (sometimes it was fully qualified...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    November 3, 2010 at 6:12 pm

    #1246341

  • RE: Performance - fast query running slow in a stored procedure

    Thanks Craig - MAXDOP did resolve the Parallelism issue. Performance did tweak a bit.

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    November 3, 2010 at 6:03 pm

    #1246340

  • RE: Performance - fast query running slow in a stored procedure

    Execution plans have been attached.

    Have tweaked the code to parse the csv string of usernames to a tmp table to see if things would go better by removing some of...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    November 1, 2010 at 9:33 pm

    #1245185

  • RE: Getting Fired from an Unpaid Job.

    I fully understand this whole situation. This is all part of the "beauty" and "pain" of a capitalist society - not to say it is a bad thing - it...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    September 12, 2010 at 4:54 pm

    #1219789

  • RE: Map IP Address to a Geographical Location

    This is great - despite the limitations on accuracy.

    I have a collection of IP Addresses in the Visitor_Log table, which I convert to an IPNum - no problems there -...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    April 21, 2010 at 5:56 pm

    #1155784

  • RE: Uncommitted Commands not reporting correctly (I think)

    I found a similar post in another forum which gave me some guidance to getting this "potentially" sorted.

    http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/9ea9343b-6dac-4fcb-bde2-4cdcf4862daa

    1.I stopped SQL Server Agent on my Distribution server in order to effectively...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    February 9, 2010 at 8:28 pm

    #1116545

  • RE: undistributed commands problem

    Did you get anywhere with this?

    I have a SQL2005 - SQL2008 replication giving me similar grief.

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    February 9, 2010 at 7:21 pm

    #1116528

  • RE: Replication: Count undistributed transactions

    Someone told me to try this but I haven't been able to prove it yet, due to a problem I am having, but it might help you:

    select

    cast(count(*) as varchar(20))...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    February 9, 2010 at 7:20 pm

    #1116526

  • RE: Limiting Audit Login/Logout events

    michael.wiles (5/29/2008)

    I am trying to fine tune an application in VB that access SQL Server 2005. After reviewing the SQL Profiler log there seems to be an excessive amount...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    February 3, 2010 at 3:12 pm

    #1113260

  • RE: SQL2005 to 2008 - Error converting VarChar to Datetime

    That fixed it!

    Had to add a DATETIME2 field, copy the data from the original field, remove indexes that referred to the orig, delete the orig field, rename the new field...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    December 3, 2009 at 1:49 pm

    #1087368

  • RE: SQL2005 to 2008 - Error converting VarChar to Datetime

    Thanks - I will give that a go.

    In which case, I have lots of tables in this DB that need the datatype DATETIME to be upgraded - just as well...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    December 1, 2009 at 2:52 pm

    #1086143

  • RE: SQL2005 to 2008 - Error converting VarChar to Datetime

    The data tyep is a [datetime], as it was in SQL2005 - I take it that [datetime2] is now the equivalent in SQL2008?

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    December 1, 2009 at 12:18 pm

    #1086015

  • RE: SQL2005 to 2008 - Error converting VarChar to Datetime

    No - not a varchar(8) but it passes a varchar (any size, usually 27), specifically this value '2009-11-30 15:16:43.9270000' and that's when SQL2008 gives the error "Error converting data type...

    [font="Arial"]-----------------------------------------------------------------
    Rich N - Development Manager @ Delta Technology Solutions Ltd - M.O.T.H.E.R. your virtual Sys Admin - Remote Server Health Monitoring - 24 x 7 www.deltatsl.com    [/font]

    November 30, 2009 at 9:54 pm

    #1085640

Viewing 15 posts - 1 through 15 (of 17 total)