Forum Replies Created

Viewing 15 posts - 44,431 through 44,445 (of 49,552 total)

  • RE: Rebuilding Indexes

    Have you looked in Books Online. There's a fair bit in there. Look under ALTER INDEX.

    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

    September 18, 2008 at 1:50 am

    #873424

  • RE: Problem with encryption

    Check that the database you're running it in is in compatibility mode 90.

    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

    September 18, 2008 at 1:49 am

    #873423

  • RE: How to validated a field for special characters in SSIS?

    Duplicate post. No replies to this thread please

    http://www.sqlservercentral.com/Forums/Topic571498-147-1.aspx

    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

    September 18, 2008 at 1:43 am

    #873420

  • RE: Performance counters on Windows Server 2003

    Please don't cross post. It just wastes people's time and fragments replies.

    Answered here:

    http://www.sqlservercentral.com/Forums/Topic570887-145-1.aspx

    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

    September 18, 2008 at 1:43 am

    #873418

  • RE: Error: 18456, Severity: 14, State: 16.Login failed for user 'sa'. [CLIENT: XXX.XXX.XX.XXX]

    Then there must be something different about the databases that are on SQL 2000 and the databases that are on SQL 2005. The thing is, the error is saying there'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

    September 18, 2008 at 1:34 am

    #873417

  • RE: Database 'msdb' cannot be opened

    I think you're going to have to restore it from a backup. SQL won't run properly without MSDB and, since it's a system database you can't just drop it.

    I'd seen...

    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

    September 18, 2008 at 1:24 am

    #873413

  • RE: Indexed Columns Duplicated

    Stef (9/17/2008)

    I'd like to hear how people would deal with this situation, if we replaced Index1 and 3 with a new Index with Column1, Column3, Column5 would that affect read...

    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

    September 17, 2008 at 2:01 pm

    #873253

  • RE: Restore System Database

    http://msdn.microsoft.com/en-us/library/ms190749(SQL.90).aspx

    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

    September 17, 2008 at 2:00 pm

    #873252

  • RE: question on sa user

    SQL 2005 requires a password to be entered during installation if mixed mode is selected. It doesn't set a default. There's no practical way of decrypting the stored passwords

    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

    September 17, 2008 at 1:59 pm

    #873251

  • RE: update statistics

    TRACEY (9/17/2008)

    Thats good the index statistics check..

    getting names called

    clust

    NULL

    clst

    nc1

    nc2

    is it possible to get table also printed out.

    Sure. Add o.name to the select clause

    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

    September 17, 2008 at 1:57 pm

    #873250

  • RE: Database 'msdb' cannot be opened

    You don't need to drop it before restoring, and I don't think it can be deleted.

    Here's an msdn article on restoring MSDB

    http://msdn.microsoft.com/en-us/library/ms190749(SQL.90).aspx

    Before trying all that, try just running

    RESTORE DATABASE...

    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

    September 17, 2008 at 1:53 pm

    #873248

  • RE: How to determine last time log growth happened

    That reads out of the default trace.

    If you're not trying to go too far back in time, it will work. The trace is limited to 5 files of 20...

    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

    September 17, 2008 at 10:16 am

    #873123

  • RE: Only one of the 16 processors is busy

    What kind of 'batch processing'?

    Sometimes SQL will parallel processes and sometimes it won't as there is an overhead in running stuff in parallel.

    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

    September 17, 2008 at 9:42 am

    #873100

  • RE: How to determine last time log growth happened

    I don't believe this kind of info is kept historically, unless there's some custom monitoring in place.

    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

    September 17, 2008 at 9:41 am

    #873098

  • RE: Error: 18456, Severity: 14, State: 16.Login failed for user 'sa'. [CLIENT: XXX.XXX.XX.XXX]

    Tanveer (9/17/2008)

    The default db for 'sa' is master but this default exist in sql 2000 as well and there I have no issues.

    That's as it's supposed to be.

    Do you...

    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

    September 17, 2008 at 9:33 am

    #873093

Viewing 15 posts - 44,431 through 44,445 (of 49,552 total)