Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 8,761 total)

  • RE: sql server memory issue

    giri10488 (7/13/2015)

    can sql server free some memory to os & when,how?

    Too increase the OS memory, change the max memory settings.

    😎

    July 13, 2015 at 2:37 am

    #1811877

  • RE: sql server memory issue

    giri10488 (7/13/2015)

    I have an issue with a server memory. SQL server is allocated 32 Gb out of 40 GB memory and sql server is using all the memory which is...

    July 13, 2015 at 1:25 am

    #1811868

  • RE: Locked Out!

    jackfh (7/12/2015)

    Unfortunately, that didn't show me anything I could work with. I can't see the password. I have a domain account running services. I reset the PW...

    July 13, 2015 at 12:49 am

    #1811866

  • RE: Locked Out!

    jackfh (7/12/2015)

    We had a password changed on the sa account and, upon reboot, the MSSQLSERVER service stopped working and gives a login error when attempting to start it. ...

    July 12, 2015 at 10:51 pm

    #1811861

  • RE: query data

    Quick suggestion, use union all and order on the two id columns, here is an example

    😎

    USE Test;

    GO

    SET NOCOUNT ON;

    ;WITH BASE_DATA AS

    (

    SELECT

    BT.BookID

    ,0 AS TitleID

    ...

    July 12, 2015 at 9:43 pm

    #1811859

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/11/2015)

    Can't speak to that for sure but I believe I have the worst example of them all. My sweetie talks to me and I still can't figure...

    July 11, 2015 at 8:15 am

    #1811804

  • RE: Today's Random Word!

    Revenant (7/10/2015)

    SQLRNNR (7/10/2015)

    DonlSimpson (7/10/2015)

    Ed Wagner (7/10/2015)

    SQLRNNR (7/10/2015)

    Ed Wagner (7/10/2015)

    Patrick Stewart

    Dempsey

    Jack

    Gene

    Hackman

    Popeye

    Williams

    July 10, 2015 at 12:44 pm

    #1811736

  • RE: How to improve that query?

    Luis Cazares (7/10/2015)

    Eirikur Eiriksson (7/10/2015)

    Puzzles me though that the last condition will never be hit as it is a subset of the first one, typo perhaps?

    😎

    It's more an optic illusion,...

    July 10, 2015 at 12:40 pm

    #1811733

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/10/2015)

    Eirikur Eiriksson (7/10/2015)

    SQLRNNR (7/10/2015)

    Sean Lange (7/10/2015)

    Just saw this posted as an explanation to a problem.

    I'm new to SQL already researched in the Chinese do not think swimming on...

    July 10, 2015 at 12:15 pm

    #1811720

  • RE: How to improve that query?

    Kutang Pan (7/10/2015)

    Is there any other way to write the below query:

    SELECT

    SUM(CASE WHEN Type = 4 AND STATUS IN (1, 2, 3) THEN Value ELSE 0 END)

    ,SUM(CASE WHEN...

    July 10, 2015 at 12:04 pm

    #1811713

  • RE: Today's Random Word!

    Ed Wagner (7/10/2015)

    Sean Lange (7/10/2015)

    DonlSimpson (7/10/2015)

    Ed Wagner (7/10/2015)

    SQLRNNR (7/10/2015)

    Ed Wagner (7/10/2015)

    Patrick Stewart

    Dempsey

    Jack

    Gene

    Kelly

    Machine Gun

    Thompson

    July 10, 2015 at 11:06 am

    #1811693

  • RE: Today's Random Word!

    SQLRNNR (7/10/2015)

    DonlSimpson (7/9/2015)

    Ed Wagner (7/8/2015)

    DonlSimpson (7/8/2015)

    djj (7/8/2015)

    Ed Wagner (7/8/2015)

    crookj (7/8/2015)

    Ed Wagner (7/8/2015)

    DonlSimpson (7/7/2015)

    Revenant (7/7/2015)

    Ed Wagner (7/7/2015)

    crookj (7/7/2015)

    Ed Wagner (7/7/2015)

    djj (7/7/2015)

    Ed Wagner (7/7/2015)

    TomThomson (7/7/2015)

    Leaf

    Branch

    Root

    Administrator

    SA

    Disabled

    Challenged

    Heracles

    Hercules

    Theseus

    Thesaurus

    Wordy

    Loquacious

    Locutus

    Picard

    What's that?

    Actor

    July 10, 2015 at 9:09 am

    #1811646

  • RE: Are the posted questions getting worse?

    SQLRNNR (7/10/2015)

    Sean Lange (7/10/2015)

    Just saw this posted as an explanation to a problem.

    I'm new to SQL already researched in the Chinese do not think swimming on my mistake

    :w00t:

    Whu??

    Where is the...

    July 10, 2015 at 9:04 am

    #1811643

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (7/10/2015)

    On an unrelated notice, I created my own blog (and moved away from LessthanDot):

    Under the kover of business intelligence[/url]

    And yes, I stole the copyright notice from Grant and...

    July 10, 2015 at 3:11 am

    #1811529

  • RE: run SQL job continuously

    mxy (7/8/2015)

    i want to call a stored procedure continuously. i have only option to schedule using sql job, triggers doesnt help.

    Job calls a sp which loads data. My question is...

    July 9, 2015 at 12:35 pm

    #1811425

Viewing 15 posts - 4,951 through 4,965 (of 8,761 total)