Forum Replies Created

Viewing 15 posts - 20,806 through 20,820 (of 49,552 total)

  • RE: SQL2008 Replication and Log File Growth

    Quote from the blog post in question (http://blogs.msdn.com/b/sqlserverfaq/archive/2009/06/01/size-of-the-transaction-log-increasing-and-cannot-be-truncated-or-shrinked-due-to-snapshot-replication.aspx)

    The issue is yet to be fixed and hence the workaround to avoid the issue is to either remove the REPLICATION OF SCHEMA...

    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 23, 2012 at 2:15 pm

    #1437374

  • RE: SQL2008 Replication and Log File Growth

    Which queries?

    Did you read over the blog post on snapshot replication that the article references?

    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 23, 2012 at 1:21 pm

    #1437350

  • RE: Are the posted questions getting worse?

    jcrawf02 (1/23/2012)

    SQLRNNR (1/23/2012)

    jcrawf02 (1/23/2012)

    Blargh. User just requested a pie chart for their analysis....:sick:

    Make sure you do that entirely in TSQL

    challenge accepted, now let's see how long that takes me...

    Oooh... Spatial...

    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 23, 2012 at 12:32 pm

    #1437324

  • RE: Best way to return a 1 or 0 for an if exists query

    Geoff A (1/23/2012)

    I was just wondering with the new feature of SQL since the app was first written, there might be a better way.

    Can't think of any new features 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

    January 23, 2012 at 12:26 pm

    #1437317

  • RE: Best way to return a 1 or 0 for an if exists query

    Geoff A (1/23/2012)

    this is pretty much my option 1, no?

    If there's only ever 1 or 0 matching rows, kinda yes.

    If there could be more, then no, not performance wise....

    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 23, 2012 at 12:18 pm

    #1437307

  • RE: Numerical datatypes & the quirkiness within

    Also, there's no requirement at all for a money data type to store currency. The name implies it does, but it can store any fixed precision number.

    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 23, 2012 at 12:13 pm

    #1437304

  • RE: Best way to return a 1 or 0 for an if exists query

    Lowell (1/23/2012)

    i think you can do it inline with a sub select, like this without using an If structure:

    CREATE Procedure [dbo].[sp_GGA_Testing]

    @status int,

    @ID int

    As

    SELECT ISNULL(ExistsVal,0)

    FROM

    (select 1 AS ExistsVal

    from tblONE

    where...

    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 23, 2012 at 12:08 pm

    #1437299

  • RE: SQL2008 Replication and Log File Growth

    Have a read through the replication section of the following article, it's got a link to a known problem with snapshot replication that causes this

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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 23, 2012 at 12:02 pm

    #1437295

  • RE: Best way to return a 1 or 0 for an if exists query

    CREATE PROCEDURE [dbo].[sp_GGA_Testing_3] @status INT, @ID INT

    AS

    IF EXISTS (SELECT 1

    ...

    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 23, 2012 at 11:59 am

    #1437291

  • RE: Casting and implied data type conversion

    WayneS (1/23/2012)

    As long as one of the values is a decimal, the "/" will return a decimal value. So this will also work:

    UPDATE TABLE SET COLUMN_A=COLUMN_A+(COLUMN_B/50.0)

    However, Gail's comments about lack...

    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 23, 2012 at 11:37 am

    #1437280

  • RE: unable to bring database in single user mode

    There's another existing connection and you didn't specify a ROLLBACK option on the Alter Database?

    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 23, 2012 at 11:10 am

    #1437255

  • RE: Casting and implied data type conversion

    garystephen (1/23/2012)

    So I should do (CAST COLUMN_B AS DECIMAL(3,2)) instead. Gotcha.

    Well, (3,2) or whatever precision and scale are appropriate for your particular case.

    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 23, 2012 at 11:09 am

    #1437254

  • RE: Restore from Differental Backup - Migrating to new Reporting Server

    RESTORE DATABASE MyDB

    FROM DISK = 'I:\MyDB_backup_201201171726.bak'

    WITH REPLACE,

    STANDBY = <location for undo file>,

    MOVE 'MyDB' TO 'D:\SQLServer\Data\MyDb.mdf',

    MOVE 'MyDB_log' TO 'D:\SQLServer\Log\MyDB.ldf'

    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 23, 2012 at 11:08 am

    #1437252

  • RE: Insert Statement Syntax Error

    What red parts?

    Please, please use table aliases to make that easier to read.

    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 23, 2012 at 10:25 am

    #1437230

  • RE: Numerical datatypes & the quirkiness within

    No, common misconception.

    The three data types involved in the calculation are money, hence the intermediate results of the calculation are also money, then right at the end (after all 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 23, 2012 at 10:24 am

    #1437229

Viewing 15 posts - 20,806 through 20,820 (of 49,552 total)