Forum Replies Created

Viewing 15 posts - 10,471 through 10,485 (of 49,552 total)

  • RE: Transaction/Locking issues

    Any chance of seeing the code and the table definitions?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2014 at 12:02 am

    #1678678

  • RE: More than 1 Distributor database per instance?

    You can only have one distribution database per instance.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 8, 2014 at 10:40 am

    #1678502

  • RE: Errors during update Statistics

    alanm 5339 (1/8/2014)

    I ran your CheckDB command on each database on the server (not including the system ones). Each one just reported that "the command completed successfully" and nothing...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 8, 2014 at 10:32 am

    #1678497

  • RE: Errors during update Statistics

    Why didn't you address the problem when this or the scheduled checkDB job started to fail? (You do have a scheduled CheckDB job?)

    You're probably going to lose data as a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 8, 2014 at 8:19 am

    #1678435

  • RE: Errors during update Statistics

    Log the job output to a file (properties of the job step -> advanced).

    However, you have larger problems, run the following, post the full and complete results and start doing...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 8, 2014 at 7:55 am

    #1678427

  • RE: Getting same Roles to producion database

    Script the permissions from dev before you restore (semi-manual), run the script that recreates the permissions after the restore.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 8, 2014 at 12:27 am

    #1678321

  • RE: Moving system databases

    http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 7, 2014 at 1:35 pm

    #1678223

  • RE: How to partition table

    We still don't have enough information about the problem to even guess at a solution. I can't read your mind, I can't see your server.

    GilaMonster (1/6/2014)

    Get the book I recommended,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 7, 2014 at 9:30 am

    #1678132

  • RE: SQL SERVER is Running without Model Database.

    Can you post (as an attachment) one of the error logs for the server?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 7, 2014 at 7:06 am

    #1678061

  • RE: Execution Plan Behavior

    chandan_jha18 (1/7/2014)

    Thanks. But the index which is being used is having only 1 column and if the other column is being retrieved internally from clustered index, shouldn't the execution plan...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 7, 2014 at 4:46 am

    #1678020

  • RE: TEMPDB in sqlserver 2012

    Don't restart, it could well be a waste of time.

    20GB is not huge for a TempDB and if the files grew to that size is means that TempDB needs to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 7, 2014 at 4:41 am

    #1678018

  • RE: Begginer in SQL Procedures

    Break it into multiple procedures and ditch all the ELSE statements, you don't need them and they're making things more complex

    IF (@Var = 1)

    EXEC PROC1

    IF (@Var=2)

    EXEC...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 7, 2014 at 12:16 am

    #1677972

  • RE: High CPU Usage

    Chapter 3 - https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2014 at 2:44 pm

    #1677890

  • RE: SQL Server Memory

    Backup buffers, thread stacks, linked server drivers, CLR, few other things too.

    Chapter 4 - https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2014 at 9:12 am

    #1677794

  • RE: DATEDIFF Statement help!

    joey6401c (1/6/2014)

    Thanks for the reply

    I modified my query but it returns an error

    Delcare @dt date

    Set @dt = GETDATE()

    select distinct v1.name 'Machine Name', v1. 'Username', t1.displayname 'Unlicensed Application', t1.installdate 'Install Date'...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2014 at 9:10 am

    #1677792

Viewing 15 posts - 10,471 through 10,485 (of 49,552 total)