Forum Replies Created

Viewing 15 posts - 32,221 through 32,235 (of 49,552 total)

  • RE: Manually Grow w/Multi files.

    digdave7 (6/24/2010)

    I was using

    ALTER DATABASE [XXXX] MODIFY FILE ( NAME = N'VSD2', SIZE = NumberBiggerThatbeforeKB )

    With exactly what value for NumberBiggerThatbeforeKB ?

    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

    June 25, 2010 at 1:24 am

    #1184820

  • RE: Trying to bring the database as suspect

    iirc it used to on SQL 2000. Can't remember that far back and I don't have a 2000 instance to play with any longer.

    I do have a partially written blog...

    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

    June 24, 2010 at 5:14 pm

    #1184755

  • RE: Are the posted questions getting worse?

    Another thousand posts for the thread. Anyone keeping track of how many days between the thousands? Might be interesting (or useless) statistics.

    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

    June 24, 2010 at 5:12 pm

    #1184754

  • RE: Are the posted questions getting worse?

    Um, help? http://www.sqlservercentral.com/Forums/Topic941103-357-1.aspx Obviously I'm explaining badly here...

    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

    June 24, 2010 at 5:11 pm

    #1184753

  • RE: Database stuck "in recovery"

    No. Log chain and restart recovery are UNRELATED.

    An intact log chain gives you the ability to restore a database to a particular point in time, in the case of...

    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

    June 24, 2010 at 5:06 pm

    #1184751

  • RE: Memory Setting in SQL SERVER 2008

    AKP (6/24/2010)

    This is microsoft recommended figure for Windows 2008 R2 64bit Server. But for windows 2003 Server, you can give 4GB.

    Reference?

    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

    June 24, 2010 at 5:04 pm

    #1184750

  • RE: How to know whether or not there is object-level permission in a database?

    Query sys.database_permissions

    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

    June 24, 2010 at 10:55 am

    #1184616

  • RE: Few disk space

    Nope. Do that and your databases will come up RECOVERY_PENDING and unavailable after the restart of SQL.

    The correct steps are:

    Run ALTER DATABASE statements to change the location of the files...

    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

    June 24, 2010 at 9:31 am

    #1184574

  • RE: Memory Setting in SQL SERVER 2008

    AKP (6/24/2010)

    As per Microsoft recommendation, You have to give 6 GB memory to Operating System(Window 2008 64Bit).

    6GB reserved for the OS on a server that only has 10GB? That's...

    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

    June 24, 2010 at 8:54 am

    #1184557

  • RE: SQL 2005

    BEGIN TRANSACTION

    UPDATE SomeTable Set SomeColumn = @AVariable

    INSERT INTO AnotherTable (StrCol)

    SELECT SomeColumn FROM SomeTable

    SELECT SomeColumn, OtherColumn FROM AnotherTable

    COMMIT TRANSACTION

    One transaction, three statements.

    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

    June 24, 2010 at 8:37 am

    #1184544

  • RE: database settings

    15 CPUs? That's an odd number.

    Unless the server is shared between SQL and other apps, there's no reason to change the affinity setting from the default of all.

    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

    June 24, 2010 at 8:28 am

    #1184537

  • RE: Concurrency in table without deadlocks

    Cláudio Silva (6/24/2010)

    This sp in non-concurrencial (one/two requests per second) environment takes between 0 and 50ms which is great, but when enter in concorrencial environment (dozens of requests in the...

    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

    June 24, 2010 at 8:27 am

    #1184536

  • RE: Concurrency in table without deadlocks

    Cláudio Silva (6/24/2010)

    I have a problem caused by one SP that is executed simultaneosly dozens of times in the same milisecond and duration takes between 600 and 800ms most of...

    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

    June 24, 2010 at 6:02 am

    #1184444

  • RE: SQL 2005

    balasach82 (6/24/2010)

    Still waiting for an reply...

    Patience. We're all unpaid volunteers with our own jobs.

    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

    June 24, 2010 at 6:00 am

    #1184441

  • RE: INSERT INTO SELECT WITH ORDER BY

    Paul White NZ (6/24/2010)

    SET NOCOUNT ON;

    GO

    CREATE TABLE dbo.Example

    (

    row_id INTEGER IDENTITY NOT NULL PRIMARY KEY CLUSTERED,

    data ...

    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

    June 24, 2010 at 4:01 am

    #1184404

Viewing 15 posts - 32,221 through 32,235 (of 49,552 total)