Forum Replies Created

Viewing 15 posts - 2,386 through 2,400 (of 9,399 total)

  • RE: Today's Random Word!

    Revenant (10/27/2016)


    Ray K (10/27/2016)


    Ed Wagner (10/27/2016)


    Kaye Cahs (10/27/2016)


    Manic Star (10/27/2016)


    djj (10/27/2016)


    Ed Wagner (10/27/2016)


    Grumpy DBA (10/27/2016)


    Ed Wagner (10/27/2016)


    Luis Cazares (10/27/2016)


    Grumpy DBA (10/27/2016)


    Lincoln

    Cadillac

    Michigan

    Wolverines (Go Blue!!!!)

    Red Dawn (but I agree - Go Blue!)

    Night

    Twilight

    Zone

    Out

    Safe

    Lock

    Secure

  • RE: list of db features

    sqlserverDBA2016 (10/27/2016)


    Is there a query to get a list of db features

    I tried using SQL server central and then tools and then report but it says incompatible, I need...

  • RE: Today's Random Word!

    Kaye Cahs (10/27/2016)


    Manic Star (10/27/2016)


    djj (10/27/2016)


    Ed Wagner (10/27/2016)


    Grumpy DBA (10/27/2016)


    Ed Wagner (10/27/2016)


    Luis Cazares (10/27/2016)


    Grumpy DBA (10/27/2016)


    Lincoln

    Cadillac

    Michigan

    Wolverines (Go Blue!!!!)

    Red Dawn (but I agree - Go Blue!)

    Night

    Twilight

    Zone

    Out

  • RE: Today's Random Word!

    Grumpy DBA (10/27/2016)


    Ed Wagner (10/27/2016)


    Luis Cazares (10/27/2016)


    Grumpy DBA (10/27/2016)


    Lincoln

    Cadillac

    Michigan

    Wolverines (Go Blue!!!!)

    Red Dawn (but I agree - Go Blue!)

  • RE: why my query returns scientific notation for a varchar field?

    Are you sure your column is a varchar column?

    Are you trying to do some type of mathematical operation on it?

    Are you querying using SSMS or something else?

  • RE: Question on Simple Recovery Model

    coolchaitu (10/27/2016)


    Good morning Experts,

    In the Simple recovery model, are the tlogs truncated on checkpoint or physically shrinked? Does Log truncation mean physical shrinking of log file?

    The log entries are marked...

  • RE: Today's Random Word!

    Luis Cazares (10/27/2016)


    Grumpy DBA (10/27/2016)


    djj (10/27/2016)


    crookj (10/27/2016)


    Ed Wagner (10/26/2016)


    Revenant (10/26/2016)


    Grumpy DBA (10/26/2016)


    Ed Wagner (10/26/2016)


    High

    Low

    Lowlands

    Scotland

    FREEDOM!

    Slavery

    Lincoln

    Cadillac

    Michigan

  • RE: Concatenate and conatenatex

    Not being a PowerBI user, I learned something new. Thanks.

  • RE: Bit of a rant - queries on space

    Jeff Moden (10/26/2016)


    Kazmerelda (10/25/2016)


    My email to them has said I am not prepared to take off backups, and my worry is we won't have that space put in for them.

    Ok......

  • RE: Today's Random Word!

    Revenant (10/26/2016)


    Grumpy DBA (10/26/2016)


    Ed Wagner (10/26/2016)


    High

    Low

    Lowlands

    Scotland

  • RE: Index compression

    Eric M Russell (10/26/2016)


    SQL Server's buffer cache holds pages in their original compressed format.

    You can query the space allocated in the page buffer cache for individual objects using the following...

  • RE: unable to change(update) the column value in SQL server Database

    hegdesuchi (10/26/2016)


    thank you !!

    This makes sense!

    Well, client have a web service which inserts the values and lot of bugs with webservice and wrong value is brrn assigned to create...

  • RE: Shrinking the Log file...best practices?

    Jeff Moden (10/26/2016)


    HanShi (10/26/2016)


    I understand the goal Jeff is after, but leaving the LOG grow for a whole week (in FULL recovery model) is IMO a large overkill with potential...

  • RE: database features

    Eric M Russell (10/26/2016)


    Where I've worked in the past, SSIS/SSAS/SSRS is typically installed on a separate box or VM, and sometimes each component warrants it's own dedicated instance. You for...

  • RE: Shrinking the Log file...best practices?

    HanShi (10/26/2016)


    Jeff Moden (10/26/2016)


    p.s. As for ascertaining the recommended size for the log files, you could write a script to (for each DB)...

    1. Set the SIMPLE recovery model.

    2....

Viewing 15 posts - 2,386 through 2,400 (of 9,399 total)