Forum Replies Created

Viewing 15 posts - 256 through 270 (of 2,647 total)

  • RE: create procedure on top of another procedure

    Lowell (8/21/2012)

    SQLKnowItAll (8/21/2012)

    Lowell, why the WHILE 0=0?

    thanks for catching that!

    it was a copy paste blunder form something i adapted; i edited my post to yank that out;

    Darn, I was hoping...

    Jared
    CE - Microsoft

    August 21, 2012 at 1:54 pm

    #1528356

  • RE: create procedure on top of another procedure

    Lowell, why the WHILE 0=0?

    Jared
    CE - Microsoft

    August 21, 2012 at 1:48 pm

    #1528354

  • RE: Subscriber DB size is growing larger than Publisher

    ashwinboinala (8/21/2012)

    its recovery model is full and the problem is there are duplicate entries in db

    Well there's your problem 🙂

    Jared
    CE - Microsoft

    August 21, 2012 at 1:39 pm

    #1528352

  • RE: This differential backup cannot be restored because the database has not been restored to the correct earlier state.

    Welsh Corgi (8/21/2012)

    SQLKnowItAll (8/21/2012)

    Welsh Corgi (8/20/2012)

    Grant Fritchey (8/20/2012)

    Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.

    Thanks....

    Jared
    CE - Microsoft

    August 21, 2012 at 1:04 pm

    #1528341

  • RE: high reads

    GilaMonster (8/21/2012)

    Object_id is used to join to sys.objects (or sys.procedures if you prefer). Or you can use Object_name and pass it the object_id and database_id.

    Note that sys.objects is database-specific and...

    Jared
    CE - Microsoft

    August 21, 2012 at 12:37 pm

    #1528324

  • RE: high reads

    SQLKnowItAll (8/21/2012)

    GilaMonster (8/21/2012)

    Cross apply to sys.dm_exec_sql_text (on the plan_handle). One of the resultant columns is Object_ID.

    Ok, but if I run this:

    SELECT ps.object_id, s.objectid

    FROM sys.dm_exec_procedure_stats ps

    CROSS APPLY sys.dm_exec_sql_text(sql_handle) s I see...

    Jared
    CE - Microsoft

    August 21, 2012 at 12:32 pm

    #1528317

  • RE: high reads

    GilaMonster (8/21/2012)

    Cross apply to sys.dm_exec_sql_text (on the plan_handle). One of the resultant columns is Object_ID.

    Ok, but if I run this:

    SELECT ps.object_id, s.objectid

    FROM sys.dm_exec_procedure_stats ps

    CROSS APPLY sys.dm_exec_sql_text(sql_handle) s I see that...

    Jared
    CE - Microsoft

    August 21, 2012 at 12:24 pm

    #1528310

  • RE: high reads

    Hmm... My thought was that the OP wanted to know how to take information from sys.dm_exec_procedure_stats, and either cross apply it or join it to get the name of the...

    Jared
    CE - Microsoft

    August 21, 2012 at 12:17 pm

    #1528303

  • RE: log for database is not availabe

    sql2k8 (8/21/2012)

    Hi,

    I had turned of autoclose on the database and now things are working well.

    Integrity checks and backups are running well now.

    Thank You very much for the help.

    As autoclose is...

    Jared
    CE - Microsoft

    August 21, 2012 at 10:59 am

    #1528252

  • RE: high reads

    BaldingLoopMan (8/21/2012)

    thats the thing. The proc only does it sometimes. i dont know why. i assume it has something to do w the indexes being rebuild however havent proven that....

    Jared
    CE - Microsoft

    August 21, 2012 at 10:53 am

    #1528250

  • RE: high reads

    BaldingLoopMan (8/21/2012)

    i have a proc who on occasion it's execution plan goes to hell and it uses 11 million reads to finish. I think it's because there is a check...

    Jared
    CE - Microsoft

    August 21, 2012 at 10:46 am

    #1528241

  • RE: what are these logins ?

    Sqlism (8/21/2012)

    Hi Experts,

    I see some logins in sql server, can you explain why they exist and there uses?

    1.NT SERVICE\MSSQL$INSTANCENAME

    2.NT SERVICE\SQLAgent$INSTANCENAME

    3.##MS_PolicyEventProcessingLogin##

    4.##MS_PolicyTsqlExecutionLogin##

    Thanks

    The first 2 are virtual accounts. Check the backup application log...

    Jared
    CE - Microsoft

    August 21, 2012 at 9:58 am

    #1528213

  • RE: Error during backup (Operating system error 1003) with Tivoli Data Protection

    Hmm... The write failure may indicate a space issue? Do you have enough space on the backup media?

    Jared
    CE - Microsoft

    August 21, 2012 at 9:50 am

    #1528209

  • RE: This differential backup cannot be restored because the database has not been restored to the correct earlier state.

    Welsh Corgi (8/20/2012)

    Grant Fritchey (8/20/2012)

    Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.

    Thanks. I guess I...

    Jared
    CE - Microsoft

    August 21, 2012 at 9:42 am

    #1528204

  • RE: Error during backup (Operating system error 1003) with Tivoli Data Protection

    I would start here:

    Check the backup application log for detailed messages.

    Jared
    CE - Microsoft

    August 21, 2012 at 9:37 am

    #1528200

Viewing 15 posts - 256 through 270 (of 2,647 total)