Forum Replies Created

Viewing 15 posts - 1,831 through 1,845 (of 49,552 total)

  • RE: 1 Tb is How many rows in a databse

    Thom A - Friday, February 3, 2017 7:45 AM

    If you had a table, containing 1 column, and data type BIT, each row...

    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

    February 3, 2017 at 8:04 am

    #1926605

  • RE: 1 Tb is How many rows in a databse

    susmitha117 - Friday, February 3, 2017 7:35 AM

    How many rows does a database contain in 1TeraByte?

    No way to answer that question. I...

    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

    February 3, 2017 at 8:03 am

    #1926604

  • RE: Your Favorite Feature that Needs Work

    1) Make Distributed Replay easier to use.
    I love DReplay, it makes stress tests, upgrade tests so easy to do, but it's finicky as hell, command-line only and...

    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

    February 3, 2017 at 8:01 am

    #1926603

  • RE: log file keep growing

    WhiteLotus - Wednesday, February 1, 2017 7:55 PM

    GilaMonster - Wednesday, February 1, 2017 8:47 AM

    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

    February 1, 2017 at 11:35 pm

    #1926252

  • RE: log file keep growing

    Beatrix Kiddo - Wednesday, February 1, 2017 9:46 AM

    After you've done that, consider increasing the frequency of your log backups to see...

    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

    February 1, 2017 at 9:48 am

    #1926135

  • RE: log file keep growing

    WhiteLotus - Tuesday, January 31, 2017 7:47 PM

    At the end I executed this statement “BACKUP LOG DBname TO DISK = 'NUL'†and...

    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

    February 1, 2017 at 8:47 am

    #1926122

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Wednesday, February 1, 2017 4:36 AM

    Don't take this the wrong way, but that bit I bolded is NOT...

    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

    February 1, 2017 at 8:43 am

    #1926119

  • RE: Urgent Career Advice Required

    praveennair1704 - Tuesday, January 31, 2017 11:06 PM

    Hence I am thinking of applying for PR in Canada and then apply for SQL...

    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

    February 1, 2017 at 8:41 am

    #1926115

  • RE: Sort order guaranteed?

    kevaburg - Tuesday, January 31, 2017 4:07 AM

    GilaMonster - Saturday, January 28, 2017 4:24 PM

    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

    February 1, 2017 at 8:38 am

    #1926114

  • RE: Question

    Yes.
    No table definitions, so I can't just write you a query. The essence of it is that you join the table to itself with an offset. You can use...

    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

    January 30, 2017 at 11:41 am

    #1925701

  • RE: Cost threshold for parallelism

    george.p - Monday, January 30, 2017 7:29 AM

    GilaMonster - Saturday, January 28, 2017 4:19 PM

    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

    January 30, 2017 at 11:27 am

    #1925694

  • RE: TempDB Log File Growing Exponentially But Remains 99% Empty?

    Eirikur Eiriksson - Monday, January 30, 2017 4:21 AM

    SELECT
     SDB.name
    ,SDB.log_reuse_wait_desc
    FROM sys.databases SDB
    WHERE SDB.name = N'tempdb';

    Edit: Mis-read

    Since...

    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

    January 30, 2017 at 4:26 am

    #1925566

  • RE: TempDB Log File Growing Exponentially But Remains 99% Empty?

    neil.baal 44846 - Monday, January 30, 2017 4:08 AM

    Every few days the TempDB log file is growing up to 64GB on disk,...

    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

    January 30, 2017 at 4:23 am

    #1925565

  • RE: Issue with while loop

    Ed Wagner - Saturday, January 28, 2017 9:12 PM

     Are you able to run simple queries against any table?

    He should be. 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

    January 29, 2017 at 3:18 am

    #1925512

  • RE: Issue with while loop

    mcfarlandparkway - Saturday, January 28, 2017 5:57 PM

    Here is my function we are already inserting into temp table inside the function.. this...

    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

    January 29, 2017 at 3:17 am

    #1925511

Viewing 15 posts - 1,831 through 1,845 (of 49,552 total)