Forum Replies Created

Viewing 15 posts - 571 through 585 (of 860 total)

  • RE: Moving database

    amarnath_sk (3/16/2009)

    Hi,

    Can any one suggest me what things i have to consider while moving database from development environment to production.

    in advance thank you.

    Well, Stress analysis, Performance baseline and Orphan users...

    March 16, 2009 at 2:27 pm

    #960580

  • RE: slow running query/queries

    Good advise above, but above all this it is always a good practice to create a baseline of your workload , later you can compare the monitoring activity with this...

    March 16, 2009 at 1:59 pm

    #960558

  • RE: TEMPLOG

    Ratheesh.K.Nair (3/16/2009)

    Hi Experts,

    I got the error

    Msg 911, Level 16, State 1, Line 1

    Could not locate entry in sysdatabases for database 'Templog'. No entry found with that name. Make sure that...

    March 16, 2009 at 1:47 pm

    #960552

  • RE: Do I need to run maintenance?

    callum.bundy (3/16/2009)

    Read the blog, feel a bit silly now.

    Changed all my plans, dropped re-index and shrink so I will check how many GB of change there is on the weekend

    Thanks...

    March 16, 2009 at 1:16 pm

    #960535

  • RE: Transaction Log Shrinking

    CrazyDBA (3/11/2009)

    As i said all 3 databases are indentical. One out of 3 has more transaction as its live database. Another two used by hardly one or two users. so...

    March 11, 2009 at 11:02 am

    #957693

  • RE: Rename Instance

    Mike Levan (3/11/2009)

    select @servername it gives me REVDEV\REVDEV

    Your "computername"/"instancename"

    March 11, 2009 at 9:41 am

    #957607

  • RE: Could not allocate space for object. because the 'PRIMARY' filegroup is full.

    Which SQL server edition are you using? Right click on SSMS on the database and you can see the "size" and "spaceavailable". If you still have disk space available increase...

    March 11, 2009 at 9:38 am

    #957605

  • RE: What is the Syntax for Multiple Trace Flags

    Steve Jones - Editor (3/11/2009)

    http://msdn.microsoft.com/en-us/library/ms187329.aspx

    You can include 1..n trace flags with DBCC TRACEON

    OP was wanting solution at the startup steve:)

    March 11, 2009 at 8:41 am

    #957543

  • RE: What is the Syntax for Multiple Trace Flags

    NateT (3/11/2009)

    I'm trying to troubleshoot some deadlock issues and that is when I saw that comment.

    My apologies, but I was trying to give more insight into your troubleshoot just...

    March 11, 2009 at 8:29 am

    #957529

  • RE: Unique Constraint

    ishaan99 (3/10/2009)

    Tried adding the ignore_dup_key clause also as in index below but somehow it errors out saying

    The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for...

    March 11, 2009 at 8:22 am

    #957521

  • RE: What is the Syntax for Multiple Trace Flags

    NateT (3/11/2009)

    In the Books Online, under Trace flags [SQL Server]:deadlocks it says "It is possible to enable both trace flags to obtain two representations of the same deadlock event."

    I'm trying...

    March 11, 2009 at 8:11 am

    #957503

  • RE: Not able to remove the file from db

    karthikeyan (3/11/2009)

    ALTER DATABASE [Sales] REMOVE FILE [INDEXES]

    ALTER DATABASE [Sales] REMOVE FILEGROUP [INDEXES]

    Both are not working....

    Thanks,

    Did you check whether these files exist at all? it should be a minor...

    March 11, 2009 at 6:18 am

    #957389

  • RE: spt_fallback_db

    Eswin (3/11/2009)

    hi experts

    can anyone tell me what is the object "spt_fallback_db"

    when i ran a select query its not stop executing

    i found a couple of shared locks on the...

    March 11, 2009 at 6:02 am

    #957378

  • RE: Not able to remove the file from db

    karthikeyan (3/11/2009)

    When I try to remove the file from the database and I got the below error

    Server: Msg 5009, Level 16, State 3, Line 1

    ALTER DATABASE failed. Some disk names...

    March 11, 2009 at 5:38 am

    #957361

  • RE: How to deploy database in production server

    Yep, that's true sorry did not mention it.

    March 11, 2009 at 5:28 am

    #957354

Viewing 15 posts - 571 through 585 (of 860 total)