Forum Replies Created

Viewing 15 posts - 33,121 through 33,135 (of 49,552 total)

  • RE: Backup and restore solution for 800TB of data

    Lowell (4/29/2010)

    Steve can you put out some numbers for perspective? SSC has a lot of users and traffic, compared to many of us small biz guys we usually deal with;...

    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

    April 29, 2010 at 3:57 pm

    #1160090

  • RE: Backup when mssqlservice is stopped

    Lots of DBs cause backups to fail? With what error?

    How were you doing those backups? Maintenance 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

    April 29, 2010 at 8:10 am

    #1159718

  • RE: The statistics affect the sort ?!

    Grant Fritchey (4/29/2010)

    But... almost forgot this, part of why you use monotonically increasing values as clustered keys so often (or identities defaulted to the primary key) is because inserts always...

    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

    April 29, 2010 at 7:58 am

    #1159705

  • RE: Backup and restore solution for 800TB of data

    GregoryF (4/29/2010)

    Are you really sure it's 800TB and not 800GB?

    SQL 2008 only support 512TB Databases

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

    So does SQL 2005

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

    No. Not 512 TB. 524,272 TB. 524 PB (petabytes)

    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

    April 29, 2010 at 7:50 am

    #1159697

  • RE: Checkpoints and Performance

    2 year old thread.

    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

    April 29, 2010 at 7:46 am

    #1159692

  • RE: The statistics affect the sort ?!

    Rows are not necessarily sorted within a page, but there's a slot index that defines the order that they should be in. The pages however are not necessarily stored in...

    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

    April 29, 2010 at 7:44 am

    #1159690

  • RE: Backup when mssqlservice is stopped

    Cold backups (when the service is stopped) are not recommended for SQL Server. Take database backups (BACKUP DATABASE) and copy those to tape/offsite storage.

    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

    April 29, 2010 at 7:38 am

    #1159675

  • RE: Backup and restore solution for 800TB of data

    Are you sure it's TB, not GB? A log file cannot be bigger than 2TB.

    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

    April 29, 2010 at 7:34 am

    #1159671

  • RE: DBA L1,L2 AND L3 ?

    Depends on the company. It's not something that has a precise, universal definition.

    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

    April 29, 2010 at 7:33 am

    #1159670

  • RE: Backup and restore solution for 800TB of data

    Get a professional in. There are going to be very few people with experience in databases over a few TB and an 800TB has to be one of the biggest...

    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

    April 29, 2010 at 7:30 am

    #1159666

  • RE: Read logfile with vb.net (in admin mode)

    Since you're using SQL 2008, have you looked at Change data capture or Change tracking? Other than those, triggers on the tables you're interested in or SQL trace.

    The transaction 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

    April 29, 2010 at 5:47 am

    #1159573

  • RE: Exam 70-448

    Have you checked out the MS list of skills measured?

    http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-448&locale=en-us

    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

    April 29, 2010 at 5:19 am

    #1159555

  • RE: Help with a query - NOT IN or NOT EXISTS

    Oh, and the query... This is one way, it may be a little slow if there's lots of data. Idea is to get all possible combinations of member and quiz,...

    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

    April 29, 2010 at 5:05 am

    #1159548

  • RE: Help with a query - NOT IN or NOT EXISTS

    I would recommend that you write the SQL to get a standard resultset and do the pivoting for display in the front end.

    So your SQL query, for the example results,...

    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

    April 29, 2010 at 4:58 am

    #1159546

  • RE: need help for query tunning

    How many rows does the query return? How long does it currently run? How many rows are in the tables?

    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

    April 29, 2010 at 4:39 am

    #1159537

Viewing 15 posts - 33,121 through 33,135 (of 49,552 total)