Forum Replies Created

Viewing 15 posts - 15,106 through 15,120 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/21/2012)

    The Dixie Flatline (12/21/2012)

    WayneS (12/21/2012)

    SQLRNNR (12/21/2012)

    The Dixie Flatline (12/21/2012)

    In SSC Heaven, all the OPs do proper backups.

    ...And do proper restores.

    And they don't restart their servers to fix data corruption...

    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

    December 21, 2012 at 9:18 am

    #1570972

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (12/21/2012)

    ChrisM@Work (12/21/2012)

    Anybody out there?

    Yes, but I'm very busy fighting off the zombie apocalypse.

    No zombies here. They probably got robbed and re-killed on their way down the continent.

    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

    December 21, 2012 at 9:17 am

    #1570970

  • RE: We need the help of an MCP with passed 70-432 (SQL2008) urgently

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1399379-10-1.aspx

    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

    December 21, 2012 at 8:03 am

    #1570928

  • RE: We need the help of somebode with passed exam 70-432

    Rusalka68 (12/21/2012)

    We definitely need someone with this test, who can assign our company as part of a cooperation agreement this year for a few days.

    So you want someone who...

    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

    December 21, 2012 at 8:03 am

    #1570927

  • RE: Unwanted parameter truncation

    pdanes (12/21/2012)

    That is method 1, suggested by Grant, Jared and (I thought) you. No? If not, what did you mean?

    Neither Grant, Jared or myself suggested a 'normal' table. We suggested...

    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

    December 21, 2012 at 6:19 am

    #1570877

  • RE: CTE Usage

    sqlnaive (12/21/2012)

    I was aware that CTE uses a ';' at the beginning.

    Nope. Not at all. The ; is a statement terminator. It does not start statements any more than...

    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

    December 21, 2012 at 6:16 am

    #1570873

  • RE: Unwanted parameter truncation

    Neither of those is what was suggested.

    A parameter table that contains that list split into rows.

    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

    December 21, 2012 at 5:06 am

    #1570850

  • RE: SELECT query with "Writes" ?!

    stryk (12/21/2012)

    We do a Full Scan - using the MP - every weekend (because we have plenty of time to do this); every day we just do a sp_updatestats (because...

    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

    December 21, 2012 at 3:42 am

    #1570822

  • RE: Partitioning Error

    Look at the error message. Read what it says. It says nothing at all about the data being out of range.

    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

    December 21, 2012 at 2:00 am

    #1570789

  • RE: Faster way to release the Unused Space back to Disk

    crazy4sql (12/21/2012)

    why dont you change your recovery model to "bulk logged" while your ETLs are scheduled?

    Not going to affect the size or usage of the data file in any way.

    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

    December 21, 2012 at 1:35 am

    #1570782

  • RE: Faster way to release the Unused Space back to Disk

    Mac1986 (12/21/2012)

    I have done the things that you have suggested but still in the next ETL run, again the Datafile size is boosted up and used space by the file...

    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

    December 21, 2012 at 1:34 am

    #1570781

  • RE: Partitioning Error

    Bhuvnesh (12/21/2012)

    Can you please explain why ?

    What does the error message say you are missing?

    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

    December 21, 2012 at 1:33 am

    #1570778

  • RE: What is better: single or multiple datafile (mdf) in user database for better performance?

    ico-601891 (12/21/2012)

    But would be some performance penalty if I define my database with multiple files in the same disk?

    Not unless you have hundreds of files.

    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

    December 21, 2012 at 1:18 am

    #1570767

  • RE: SELECT query with "Writes" ?!

    stryk (12/21/2012)

    We already have a complete statistic update up running every day ...

    Fullscan or sampled?

    Index rebuilds seldom fix performance problems. The stats updates they do however fix many problem

    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

    December 21, 2012 at 12:57 am

    #1570761

  • RE: Ideal threshold for STATS UPDATE

    Mohammed Imran Ali (12/20/2012)

    2. What would be the ideal threshold for scheduling the update statistics job?

    There isn't one. There's no single threshold that works for all tables in all circumstances....

    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

    December 21, 2012 at 12:51 am

    #1570758

Viewing 15 posts - 15,106 through 15,120 (of 49,552 total)