Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

  • RE: Add per column of months per client

    Phil Parkin - Wednesday, January 23, 2019 9:08 AM

    angelreynosog - Wednesday, January 23, 2019 7:40 AM

    January 23, 2019 at 9:22 am

    #2019835

  • RE: Fiscal Column Year - Month / Values Result

    Jeff Moden - Tuesday, January 22, 2019 9:30 PM

    Phil Parkin - Tuesday, January 22, 2019 3:32 PM

  • RE: Fiscal Column Year - Month / Values Result

    Jeff Moden - Tuesday, January 22, 2019 9:30 PM

    Phil Parkin - Tuesday, January 22, 2019 3:32 PM

  • RE: Year By Months -Columns

    Mike01 - Tuesday, January 22, 2019 11:03 AM

    Can you post DDL, sample data.  You will need to use a dynamic pivot to...

  • RE: Rotation for days in account receivable

    Mike01 - Tuesday, January 22, 2019 9:32 AM

    DDL, sample data and expected results will be helpful and get you the results you...

  • RE: Rank Table Sales Setup with Sale

    ScottPletcher - Thursday, January 10, 2019 3:05 PM

    Your ranges have gaps: where would 500,000.50 fall?

    At any rate, something like:

    SELECT s.sales,...

  • RE: Big Transaction Log

    USE DATABSE;

    GO

    SELECT file_id, name, type_desc, physical_name, size, max_size

    FROM sys.database_files ;

    GO

    file_id name ...

  • RE: Big Transaction Log

  • RE: Reduce Log Database

    It is the same query , not wanting to send it twice

  • RE: Reduce Log Database

    GilaMonster (6/27/2016)


    If you run these, what's the result for the database you have the problem with?

    DBCC SQLPERF(LogSpace)

    SELECT name, log_reuse_wait_desc from sys.databases

    Good day Mr. Gail Shaw,

    This is the result , I...

  • RE: Reduce Log Database

    GilaMonster (6/27/2016)


    If you run these, what's the result for the database you have the problem with?

    DBCC SQLPERF(LogSpace)

    SELECT name, log_reuse_wait_desc from sys.databases

    Good day Mr. Gail Shaw,

    This is the result , I...

  • RE: Reduce Log Database

    GilaMonster (6/27/2016)


    angelreynosog (6/27/2016)


    There is no defined structure as such , this is why I'm looking for guidance , how could. Currently , it is being done as I said ,...

  • RE: Reduce Log Database

    Y.B. (6/27/2016)


    Check the properties of your database and find it's Recovery Model.

    Log files are automatically truncated in Simple recovery model. Otherwise if the recovery model is set to FULL...

  • RE: Reduce Log Database

    Hello Mr. Gail Shaw,

    There is no defined structure as such , this is why I'm looking for guidance , how could. Currently , it is being done as I said...

  • RE: Parameter Boolean

    ok, is that what I said would cascade parameters the most appropriate way to work, but if you only want to filter my report with the parameter supplier and do...

Viewing 15 posts - 1 through 15 (of 16 total)