Forum Replies Created

Viewing 15 posts - 35,056 through 35,070 (of 49,552 total)

  • RE: Master.dbo.SysColumns

    It's the syscolumns view in the master database. syscolumns used to be a table in SQL 2000 it's now a view and it's one of the meta-data views. There's 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

    December 30, 2009 at 1:38 am

    #1097351

  • RE: select distinct query

    golden-1131024 (12/30/2009)

    Index creation is a workaround, is there any advice to have both performance improvement but with less db size increment?

    A workaround?

    Indexing is the key to good performance. No indexes,...

    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

    December 30, 2009 at 1:32 am

    #1097349

  • RE: Finding user connected to a Database in SQL Server 2008

    It's probably the checkpoint process. As I said, don't worry about it. The system processes have all sorts of wait types in 2005 and above and they're supposed to have...

    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

    December 30, 2009 at 1:29 am

    #1097348

  • RE: Help interpreting DBCC CHECKDB error

    Glad to hear that.

    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

    December 30, 2009 at 1:27 am

    #1097347

  • RE: SQL Server Express - Free download

    Microsoft gives an immense amount of software away for free.

    Just a couple of examples: the express versions of SQL Server and Visual Studio and all the Windows Live apps, Virtual...

    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

    December 29, 2009 at 12:36 pm

    #1097185

  • RE: Database backup: Backup to a new media set, and erase all existing backup sets...

    That said...

    Check with whoever's responsible for the backups and ask whether or not there are any differential backups been run. If there are, to avoid messing up the recovery chain,...

    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

    December 29, 2009 at 12:29 pm

    #1097183

  • RE: Database backup: Backup to a new media set, and erase all existing backup sets...

    edtraviles (12/29/2009)

    I presume removing the existing backup destination in this dialog won't affect anything except the one-off backup I want to run, i.e. the removed destination will still be valid...

    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

    December 29, 2009 at 12:23 pm

    #1097180

  • RE: Having trouble connecting to a cluster in single-user mode with a DAC connection.

    I am out of ideas.

    Nothing needed on a cluster other than remote DAC. I have done it before, no problems at all.

    Way out idea. Does the cluster have 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

    December 29, 2009 at 12:22 pm

    #1097178

  • RE: Database backup: Backup to a new media set, and erase all existing backup sets...

    edtraviles (12/29/2009)

    I presume I use 'Add...' to specify a new path and filename for the one-off backup, highlight it when I run the backup, and leave the existing alone(?),

    No. If...

    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

    December 29, 2009 at 10:39 am

    #1097120

  • RE: Best practice for Cluster Setup

    Hit your favourite search engine and search for clustering best practices on technet.microsoft.com. There are pages and pages (and I mean that quite literally) on it.

    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

    December 29, 2009 at 10:37 am

    #1097119

  • RE: Are the posted questions getting worse?

    GSquared (12/29/2009)

    For anyone here a month or so ago, I have good news on the employment front. Starting a new job with a much better company in mid-Jan. ...

    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

    December 29, 2009 at 10:34 am

    #1097118

  • RE: Having trouble connecting to a cluster in single-user mode with a DAC connection.

    You're 100% sure that remote DAC is enabled?

    EXEC sp_configure 'remote admin connections'

    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

    December 29, 2009 at 9:11 am

    #1097070

  • RE: My Database is (In Recovery) - SQL2005 over Windows 2003

    So that means that restart-recovery is in process. Give it time and the DB will either come online or it will go suspect.

    Error log?

    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

    December 29, 2009 at 8:20 am

    #1097047

  • RE: My Database is (In Recovery) - SQL2005 over Windows 2003

    Willian Funes (12/29/2009)

    the log file show me a message "SQL server has encountered 1 occurrence(s) of cachestore flush for the bounds trees cachestore (part of plan cache) due to some...

    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

    December 29, 2009 at 8:13 am

    #1097044

  • RE: My Database is (In Recovery) - SQL2005 over Windows 2003

    Willian Funes (12/29/2009)

    Hi, the instruction "select * from sys.databases" work fine and I get all DB

    Yes, it will work. sys.databases is in master. The reason for asking you to query...

    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

    December 29, 2009 at 8:10 am

    #1097041

Viewing 15 posts - 35,056 through 35,070 (of 49,552 total)