Forum Replies Created

Viewing 15 posts - 2,761 through 2,775 (of 8,761 total)

  • RE: Server Hangs

    s0da9 (11/13/2016)


    Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT...

  • RE: Good to have Multiple Data Warehouses?

    xsevensinzx (11/13/2016)


    Jeff Moden (11/12/2016)


    To wit, I frequently go with the "no data warehouse" option in favor of just writing some streamlined code to solve actual problems instead of a system...

  • RE: SQL BACKUP FAILED (?) Job file missing

    Ed Wagner (11/12/2016)


    Eirikur Eiriksson (11/12/2016)


    To me it looks like a Maintenance Plan related error, strongly suggest to switch to Ola Hallengren's SQL Server Maintenance Solution[/url], much more robust.

    😎

    Question, what if...

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/12/2016)


    Eirikur Eiriksson (11/12/2016)


    What a spamtastic Saturday morning:pinch:

    😎

    Indeed it has been. I've personally hidden about 100 spam posts in the last 4 to 5 hours. The bots...

  • RE: duration in extended event not working properly

    GilaMonster (11/12/2016)


    You missed a zero

    with a thousand separator added your filter was: duration>200 000, so filtering for duration greater than 0.2 seconds

    Gail, in you experience, how accurate is the timing...

  • RE: Understanding from .. from

    Edvard Korsbæk (11/12/2016)


    You can replace the first instance of FROM dbo.DutyRosterShift with the alias B, that's what the parser will do anyway.

    😎

    If I change to:

    DELETE FROM dbo.DutyRosterShift B...

  • RE: Understanding from .. from

    Edvard Korsbæk (11/12/2016)


    Hi All!

    I got some code from another, where i have som understanding problems.

    Its pretty long, but the start is:

    DELETE FROM dbo.DutyRosterShift FROM dbo.DutyRosterShift B

    WHERE

    B.DutyRosterId...

  • RE: Corrupted innodb table crashing mysql instance how to recover table?

    jackadision (11/12/2016)


    Dear sir,

    According to me this is not a spam post, post contains links are always not spam. The link given by me in my previous post contains lots...

  • RE: Corrupted innodb table crashing mysql instance how to recover table?

    jackadision (11/12/2016)


    Restore corrupt or damaged MY SQL database by using its backup, through this way you can repair any types of error. Or use a third party MY SQL Repair...

  • RE: Substring a value after a period

    Jeff Moden (11/11/2016)


    hoseam (11/11/2016)


    I get string values as input, e.g 'Documentation.Account', whatever value I get I want to extract it to get anything after a period(.) e.g'Account' I was thinking...

  • RE: Are the posted questions getting worse?

    What a spamtastic Saturday morning:pinch:

    😎

  • RE: MICROSOFT SQL SERVER LICENSE TERMS

    Quick questions, why consider Sql Server 2008 Express when you have later and better versions?

    What is the overall architecture of your software, client-server, web application, desktop application?

    How many concurrent...

  • RE: TSQL Formatting tool?

    Jeff Moden (11/11/2016)


    Eric M Russell (11/11/2016)


    Jeff Moden (11/11/2016)


    Eric Mamet (11/10/2016)


    Can someone recommend a (free?) tool to format TSQL Code.

    Ideally, it should be something working in both SSMS and Visual...

  • RE: SQL BACKUP FAILED (?) Job file missing

    To me it looks like a Maintenance Plan related error, strongly suggest to switch to Ola Hallengren's SQL Server Maintenance Solution[/url], much more robust.

    😎

    Question, what if any errors are there...

  • RE: Stolen Server Memory and Database Cache Memory

    Jose Marcelo Dias de Oliveira (11/10/2016)


    Hi

    I have the same behavior in 2 SQL Servers where Stolen Server Memory and Database Cache Memory counters are decreasing (Db Cache) and increasing (Stolen...

Viewing 15 posts - 2,761 through 2,775 (of 8,761 total)